Extracting a delimited CSV gave weird results.

**Aswathy** · 10-21-2008, 03:18 AM

Hi All,

I am trying to extract a CSV into an excel workbook using

Data > Import External Data > Import Data

and specified that its a delimited text and the delimiter is a comma ",". One of the columns in the row has got a pretty long text and contains certain new line characters as well. After extracting the CSV the data in this particular column is treated as a different data entries.

Somebody please help. I have added the file in xls format since csv upload is not permitted.

Cheers,
Aswathy

**sglife** · 10-21-2008, 03:28 AM

Just open your .csv file using excel, then save as MS excel workbook

**Aswathy** · 10-21-2008, 03:46 AM

Hello Buddy,

I am doing all these gimmicks to get a macro recorded and to reuse the code

Any thoughts on that... ???

Cheers,
Aswathy

**Andy Pope** · 10-21-2008, 03:54 AM

Attach the file as a .txt file. We can done load and rename for testing.

**Aswathy** · 10-21-2008, 03:58 AM

Hi Andy,

Attached the file as txt.

Cheers,
Aswathy

**Andy Pope** · 10-21-2008, 04:11 AM

I see, the line feed is getting interpreted. Can not see any option that would allow for ingoring of character whilst importing.

I think you may need to open the csv file as a workbook and then copy the information into the required sheet.