Separate texts

[Beatriz]

I am reading a txt file and would like to move to the datatable, I would like to know a way to do this by separating rows and columns

[Vivek_Arunagiri]

Hi @Beatriz,

Use generate Datatable activity. This can convert the String to Datatable. You need to provide suitable column and row seperators.

[Beatriz]

Could you explain the steps?

[Vivek_Arunagiri]

You have open the right activity.

• You just need to click on that “Generate Datatable” button.
• Then provide the input in “Sample Input” Field.
• Give column seperator as Comma.
• Row seperator as Newline or “\n”.
• Then click preview to see the output.
• Once you are fine with output you can map the input string.

[Beatriz]

thanky you

a doubt, could I do this by reading from a txt file?

[Vivek_Arunagiri]

Yes ofcourse. What you are doing is correct.

You just need to provide the output of “Read text File” as input in “Generate Datatable”