topic Re: File delimited metadata - split on Unicode char (FS-1c, RS-1e in Talend Studio

File delimited metadata - split on Unicode char (FS-1c, RS-1e

_AnonymousUser — Thu, 12 Jan 2017 16:21:30 GMT

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"

i'm trying to do this. but without success.

thanks in advance.

Re: File delimited metadata - split on Unicode char (FS-1c, RS-1e

Anonymous — Thu, 12 Jan 2017 17:37:10 GMT

What is the exact problem? I do not comprehend the post.

Re: File delimited metadata - split on Unicode char (FS-1c, RS-1e

_AnonymousUser — Fri, 13 Jan 2017 13:26:16 GMT

hmm, i had some issues to attach pictures.
here is a screen of text-input
and metadata creation

Re: File delimited metadata - split on Unicode char (FS-1c, RS-1e

_AnonymousUser — Mon, 06 Feb 2017 13:01:17 GMT

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.