Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Master III
Partner - Master III

hi

what format of file do you use

because i load strings with $ sign without an error

tab dilimeted

jonathandienst
Partner - Champion III
Partner - Champion III

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
Author

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
Author

ah ha

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

Not applicable
Author

Hi Stuart

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

Not applicable
Author

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

cwolf
Creator III
Creator III

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
Author

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?