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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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.