file load is incorrectly splitting a row into 2 rows

[twills12]

I am loading a text file and noticed a problem with some of the rows.  The load is splitting some of the rows into 2 rows.  Is there a way to code the load to force it to load correctly?

I've tried various options through the load wizard but always see in the preview pane that the 3rd row is being split after '03/12/2016' and the remainder is treated as a 4th row.

Any suggestions?

Thanks.

[veidlburkhard]

Hi Tony,

this is because you have a CR in your third line of text. See the picture:

You must delete this control character before loading the text.

Hope this helps

Burkhard

[twills12]

Thanks Burkhard, that definitely makes sense and helps.

Is that possible in the script or do I need to have the source file edited if not?

[veidlburkhard]

I think, Tony, you have to do this in the source file. Cause QV doesn't load the CR.

Good luck

Burkhard

[twills12]

That's what I was afraid of.  Thanks Burkhard.