Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Is possible delimit by character '‹'? Separators

Good Morning Everyone, I have a file that is delimited by the character '‹', but in the options of separators, it doesn't exist. It shows me the character '<', it isn't the same.

Is there a form to forced it?

Thanks.

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Is possible delimit by character '‹'? Separators

Load the file fields as one field and use SubField to separate the fields.

4 Replies
MVP
MVP

Re: Is possible delimit by character '‹'? Separators

Load the file fields as one field and use SubField to separate the fields.

MVP & Luminary
MVP & Luminary

Re: Is possible delimit by character '‹'? Separators

Create the load statement with the file wizard. Then manually replace the delimiter in the generated script.

delimiter is ''


talk is cheap, supply exceeds demand
MVP
MVP

Re: Is possible delimit by character '‹'? Separators

Have you tried specifying the special character as delimiter:

LOAD @1

FROM

SampleForQlikview.txt

(txt, codepage is 1252, no labels, delimiter is '‹', msq);

You probably need to adapt the codepage, too.

Not applicable

Re: Is possible delimit by character '‹'? Separators

Thanks.. It works..... Have a Nice Day...