Hi,
I have a BulkInsert setup to import files daily. It uses a format file to specift the end of row:
<RECORD>
<FIELD ID="1" xsi:type="CharTerm" TERMINATOR='"' (single quotes round a double)
<FIELD ID="2" xsi:type="CharTerm" TERMINATOR='"\r\n' (Double Quote \r \n)
</RECORD>
<ROW>
<COLUMN SOURCE="2" NAME="DATA" xsi:type="SQLVARYCHAR"/>
</ROW>
Now for the most, this works totally fine..
It looks for a double quote and then a [CR][LF].
The issue i have is that there is a free hold text field, where people can enter whatever they want (yay.. comments fields...)
If they start the string with a carriage return.. it looks exactly like the end of line.. A double Quote and then a [CR][LF].
I cant get them to change their ways.. Is there any ideas of how to get round this?
Thanks
Rob