Amol Zagade (3/11/2010)
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.