Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi
what format of file do you use
because i load strings with $ sign without an error
tab dilimeted
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.
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');
ah ha
there is actually a small right arrow and a dollar sign. WTF is that
Hi Stuart
Did you ever get this solved? I have encountered exactly the same issue.
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
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);
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?