How to generate datatable with line vertical "|" as separator

[Gerardo_Jesus_Ignacio_Vil (Gerardo Jesus Ignacio Villacorta)]

Hello!

How can I generate a datatable from a text file that has vertical lines as separator “|”.

Currently I use the “Read Text File” activity to get all the data in a string variable and then the “Generate Data Table” activity but this activity in the Column Separators option does not have a vertical line “|”, and if I manually put "| " in Column Separators when I run it fails to do the column separation.

Thank you in advance for your support.

[ppr (Peter Preuss)]

@Gerardo_Jesus_Ignacio_Vil
had you tried following?

[Gerardo_Jesus_Ignacio_Vil (Gerardo Jesus Ignacio Villacorta)]

Hi! Peter, in my case the file is a .txt and not a csv, is for that reason that i use the activity “read text file”

[ppr (Peter Preuss)]

• you can rename the extension,
• you can assign the path manually

Maybe you can share the txt file or some sample data with us?

BTW:

@Gerardo_Jesus_Ignacio_Vil

but this activity in the Column Separators option does not have a vertical line “|”,

it is accepting:

[Gerardo_Jesus_Ignacio_Vil (Gerardo Jesus Ignacio Villacorta)]

Thanks! Peter, my error was put “|” with quotation mark, now this work!