Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
QV12 SR3
Have an odd problem that i can't figure out.
When loading from a pipe delimted text file I have some rows where the data is going in to the wrong field
ie
What should be in Add2 (addressline2) is going into Add3
and
What should be in CompanyName is going in to Add1
The only common theme i can see with the data is that the preceding field data has apostrophes within it. I have tried purging these out in the LOAD but the issue still occurs?
I've attached the offending data txt file, a qvw of the loaded data and a screenshot that hopefully highlights the issue a bit better.
Any ideas what's causing it to happen and how to fix much appreciated
Try this as format spec: (txt, codepage is 1252, embedded labels, no quotes, delimiter is '|');
Hi Paul,
I just reload your data (without any change), i got the result like
version : 11.2 SR9
Oh that's weird - i've just tried again (without any change) and it's still doing it wrong??
Try this as format spec: (txt, codepage is 1252, embedded labels, no quotes, delimiter is '|');
Perfect - Thank you