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

Txt file load failing due to special character

Edit: its not the $ thats casuing the issues; its a special charcter

Hi,

I have a text file and one of the lines has a $ sign in part of the string. Because of this QV is stopping at that line loading 762 lines of data  instead of 700,000 lines.

Is there any way I can force the script to include this line, as although I could delete the entry I actually would prefer to load it.

thanks !

Stuart

8 Replies
lironbaram
Honored Contributor II

Re: Txt file load failing due to dollar sign

hi

what format of file do you use

because i load strings with $ sign without an error

tab dilimeted

MVP
MVP

Re: Txt file load failing due to dollar sign

I suggest that you upload a file containing the first 1000 rows for your file, as well as the load script you are using -- this will include line 762. $ is usually just another character in the string, so we would need to look at the data and what you are doing to diagnose the problem.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Txt file load failing due to dollar sign

I cant upload the data as it is sensitve.

QV is taking the $ and ending the load there

(txt, codepage is 1252, embedded labels, delimiter is '\t');

Not applicable

Re: Txt file load failing due to dollar sign

ah ha

there is actually a small right arrow and a dollar sign. WTF is that

Not applicable

Re: Txt file load failing due to special character

Hi Stuart

Did you ever get this solved? I have encountered exactly the same issue.

Not applicable

Re: Txt file load failing due to special character

Hi,

Not really. KEEPCHAR I am using as a workaround but I am still seeing issues on storing back out to QVD….

Weird and annoying

chrwolf64
Contributor III

Re: Txt file load failing due to special character

Hi Stuart,

maybe the char is a "eof". In some viewer it looks like a → and QV stop with reading.

In this case you can use the "Ignore EOF" option to read the full file:

(txt, codepage is 1252, embedded labels, delimiter is '\t', no eof);

Not applicable

Re: Txt file load failing due to special character

Hi I tried with the following, and it's giving me error when i change the last time to include codepage 1252 and "no eof".

LOAD

    replace(ltrim(replace("Ticket Number",'0',' ')),' ','0') as "Tic num",   

    "Description",

    "Customer Name",

FROM [lib://dashboard/Customer*.txt]

(txt, codepage is 1252, embedded labels, delimiter is '|', msq, no eof);

When i put back the original which is below, there is no error but the data is not loaded properly due to the special characters.

(txt, utf8, embedded labels, delimiter is '|', msq, no eof);

Can you assist me?

Community Browser