Difficulty parsing text file with pipe delimiter

[aysha6029]

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

[Kenda · Accepted solution]

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

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