Pipe Delimited File - data loading in wrong field

[haymarketpaul]

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

[settu_periasamy]

Hi Paul,

I just reload your data (without any change), i got the result like

version : 11.2 SR9

[haymarketpaul]

Oh that's weird - i've just tried again (without any change) and it's still doing it wrong??

[Gysbert_Wassenaar · Accepted solution]

Try this as format spec: (txt, codepage is 1252, embedded labels, no quotes, delimiter is '|');

[haymarketpaul]

Perfect - Thank you