Txt file load failing due to special character

[#1]

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

[lironbaram]

hi

what format of file do you use

because i load strings with $ sign without an error

tab dilimeted

[jonathandienst]

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.

[#4]

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');

[#5]

ah ha

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

[#6]

Hi Stuart

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

[#7]

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]

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);

[#9]

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?