topic Re: Is possible delimit by character '‹'? Separators in QlikView

Is possible delimit by character '‹'? Separators

Fri, 02 May 2014 14:21:40 GMT

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.

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

MK_QSL — Fri, 02 May 2014 14:24:19 GMT

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

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

Gysbert_Wassenaar — Fri, 02 May 2014 14:24:52 GMT

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

delimiter is '‹'

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

swuehl — Fri, 02 May 2014 14:25:50 GMT

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.

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

Fri, 02 May 2014 15:03:55 GMT

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