Difficulty parsing text file with pipe delimiter

Hi Friends,

I am having difficulty in parsing a text file with pipe delimiters. Please find the format below. tried to go through the old discussions, but i am not able to parse the file

----Original File---------

|code| X | doooe|

|---------------------|

|10001|A33|impact|

|10002|A34|impact|

|10003|A35|impact|

------Required Format-------------

code	x	doooe
10001	A33	impact
10002	A34	impact
10003	A35	impact

Workflow

Tips and Tricks

Parse

Transformation

Preparation

Accepted answers

Kenda

Hey @aysha6029! Within your Input Data tool's configuration, change the delimiter to | (see the photo below).

pipe delimiter.PNG

If this isn't working for you, try using a Text to Columns tool with | as the delimiter.

All comments

Kenda

Hey @aysha6029! Within your Input Data tool's configuration, change the delimiter to | (see the photo below).

pipe delimiter.PNG

If this isn't working for you, try using a Text to Columns tool with | as the delimiter.

aysha6029

It worked. Thank You

yashd

Use the "Text to Columns" tool under Parse Tool tab. and under Delimiters Box enter " | " . That should work.

or

When you input the file, Click on the Input tool on the cavas on the left hand side The configuration , Number 5 is delimiters enter | and that should work too,

Thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703