File delimited metadata - split on Unicode char (FS-1c, RS-1e
Hello, i'm trying to create a metadata for "File delimited", but basted not on ";" or "," ... but on "FS" and "RS" FS ->FILE SEPARATOR (U+241C) C/C++/Java source code "\u241C"
RS -> RECORD SEPARATOR (U+241E) C/C++/Java source code "\u241E"
hello, partial solution is: in row separator use this = Character.toString((char) 28) 28 => FS in Field Separator use this = Character.toString((char) 30) 30 => RS but, i have no idia why, i have only one column, its looks like "File delimited" split one first occurrence of "Character.toString((char) 30)" and then stop. Funny thing, when i use Character.toString((char) 30) on Row separator, its works fine, i have all my rows. and it not stops after first occurrence.
hello, partial solution is: in row separator use this = Character.toString((char) 28) 28 => FS in Field Separator use this = Character.toString((char) 30) 30 => RS but, i have no idia why, i have only one column, its looks like "File delimited" split one first occurrence of "Character.toString((char) 30)" and then stop. Funny thing, when i use Character.toString((char) 30) on Row separator, its works fine, i have all my rows. and it not stops after first occurrence.