grep without string

Either of the these will do: grep -v “def” input_file | grep “abc” or grep “abc” input_file | grep -v “def” The following will also preserve coloring if you only want to see the output on stdout: grep –color=always “abc” input_file | grep -v “def” The -v option (stands for “invert match”) tells grep to … Read more

Using JavaScript to check whether a string contains Japanese characters (including kanji)

Check whether this works or not. I found this website that seems to list all the characters in Unicode that might be used in Japanese text. The corresponding regex (for single character) would be: /[\u3000-\u303f\u3040-\u309f\u30a0-\u30ff\uff00-\uff9f\u4e00-\u9faf\u3400-\u4dbf]/ ————-_____________————-_____________————-_____________ Punctuation Hiragana Katakana Full-width CJK CJK Ext. A Roman/ (Common & (Rare) Half-width Uncommon) Katakana The ranges are (as … Read more

STRING_AGG aggregation result exceeded the limit of 8000 bytes error

Try as below select c.id , c.bereichsname , STRING_AGG( CAST(j.oberbereich as nvarchar(MAX)),’,’) oberBereiches from stellenangebote_archiv j join bereiche c on j.bereich_id = c.id group by c.id, c.bereichsname So the problem is the length of the concatenated string is exceeding the character limit of the result column. So we are setting the limit to max by … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)