Archives of the TeradataForum

Message Posted: Fri, 27 Feb 2004 @ 12:16:15 GMT

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

Hi,

I am having a csv file that is to be used for importing data. But the problem is that some description columns in the csv files contain comma itself, so this is causing problem.

The structure of csv file is like this:

Id,Name,Desc,Value
1,xyz,This is description,and is having a comma in it,10

Now when I am trying to import such data using Multiload it reads

Id as 1
Name as xyz
Desc as This is description
Value as and is having comma in it

which is wrong.We need to import 10 in Value column and "This is description,and is having a comma in it" in Description column.

Can this problem be solved?

Regds

Anuradha.

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