How to insert pipe (|) in a txt file?

[BRDASID]

Hello community, how are you?
I need help inserting pipe (|) between characters in a large txt file and I believe it is possible with ease using Alteryx.
I am attaching examples of how the file is and how it should be.
Thank you in advance.

Daniela

[Carlithian · Accepted solution]

Hey, so I think what you are wanting to do is just replace the whitespace with a pipe. This formula should do it for you, its taking any amount of whitepace and making it a pipe

REGEX_Replace([FieldName ], '\s+', '|')

If you then want your output to delimit it on the pipe, you can update that in the Output tool, outputting it as a csv and selecting | as the delimeter

[BRDASID]

Hi, many thanks for your help.

I go to make with your recommended and return in here.