DELIMITING TXT FILE

[dunkindonut7777]

Hi how can I delimit properly this text file I have. I want to fix it and aligned accordingly.

Expected output

CODES	SCRRR	PATERM	DTAAA	RYOKDO
300	D	0001	00
300	D	0002	00

Attached file for your reference. Hope you could help me with this one pls

[Luke_C]

Hi @dunkindonut7777 

Here's one way you could do this:

1. Read the data in with no delimiters/column names
2. Skip the header records
3. Parse the fields based on the | delimiter
4. Select/rename the fields
5. Trim the extra spaces

[ArtApa]

Hi @dunkindonut7777 - Here is a more dynamic solution in case your actual dataset structure is different to the sample: