Archives of the TeradataForum

Message Posted: Fri, 24 Jan 2003 @ 20:54:43 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi

Does any one have idea on loading a data file with variable record lenght. The file is a comma delimted file and each field is packed in double quotes ie.,' " '. I cmae across a situation wherein some of the values in one of the fields are having comma inside the value and multilaod sees that as a separate field.

Is there any way to avoid such situation wiithout causing multiload to fail or reject the records as it thinks that the particular reocrd/field is larger than specified length.

Any suggestions or ideas are much appreciated.

Thanks for help in advance.

Srikanth Uppaluru

	<Prev	Next>		<<First	<Prev	Next>	Last>>