Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Multiload Import of CSV file with embedded commas
From:   Anuradha Mehra , Gurgaon


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:

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?



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020