Skip to Content
0
Former Member
Dec 20, 2012 at 05:17 PM

How to create columns from pipe separated text file & send to a table

410 Views

I have a text file, which comes in values in pipe | separated format.

When I try to import the file under (File Format Editor) I can see the values but how do I make each as a separate column that way I can add it to a table.

As in the picture you can see, I can only get Field1 as a 1 column, but I need to add each value in between |3|00|GREENGRAPES| as separate columns

Eg:

Prod_ID Prod_Num Name

3 00 GREENGRAPES

Any ideas any one ...

Attachments

Capture.JPG (296.3 kB)