Create Datatable from unstructured text file

#1

Hello guys,

I have a requirement where i have to create datatable from a unstructured text file.
Example of dummy data is shown in attache image.

I need to extract data from column 1 upto comments column , and delete rest of data (initial few columns and row)

we can use programming also and use asisgn and invoke method activity. If you guys has any idea how to do it. Please suggest me.

image
image.png1417x600 14.1 KB

I have tried generate table activity, but that dosent help

#2

You will need to read the text into a string and then split the string by then new line.
You will need to then get the extract the data by splitting it again on double space to differentiate columns.
This will be in a list format, so will then need to put back into a datatable by using add datarow.

Hopefully that helps