• Amol Zagade (3/11/2010)


    Hi

    Field Delimiter: |~|

    Row Delimiter : Newline

    Do I ask for a file where row-delimter is not a newline?

    No: You ask for a replacement file where the newline character is not in the columns.

    You could (try to) process the data supplied according to the RULE that states a new line denotes a new row, but you will have broken records.

    You could spend a while cleaning up the rogue new line characters, but at what cost?

    You could outsource the data to a commerical data-cleaning company, but cost remains an issue.

    Unless you need to keep someone very happy and are prepared to run at a potential loss, send it back with an explanatory note.