• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

parse field with special characters

pwright

Member
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

Active Member
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.
 
Last edited:
Top