Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

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"

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

thanks in advance. 
Labels (3)
1 Solution

Accepted Solutions
_AnonymousUser
Specialist III
Specialist III
Author

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.

View solution in original post

3 Replies
Anonymous
Not applicable

What is the exact problem? I do not comprehend the post.
_AnonymousUser
Specialist III
Specialist III
Author

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

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.