parse field with special characters

[pwright]

I have a file (.csv) I need to import that is comma delimited, however one of the fields looks like this:

DSI000417214258SF000182 189970JHOWZEDSISCAN32MCAQ00321

I don't know how to define the delimiter in this field to break out the individual information.

When I read it in Notepad++ the  looks like EOT.

How do I define this delimiter to E1?

 

[Jay Kumar]

hi wright,

Please open with .csv file in notepad , not in NotePad++

 

[Jay Kumar]

if your are able to attached the file, it will make easy to understand the file Delimiter.

i have used business function Parse Text String (B0500690) to pickup the cell/ field value from CSV file record.

 

[RKUSA]

I think you need to fix your app which is creating this .csv file.

 

[PavelK]

Also Table conversion is good tool for read csv.