community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Difficulty parsing text file with pipe delimiter

Asteroid

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-------------

codexdoooe
10001A33impact
10002A34impact
10003A35impact

 

Pulsar
Pulsar

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.

Asteroid

It worked. Thank You

Highlighted
Asteroid

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

Labels