Get the table from text file

I need to get the table from this text file using string manipulation the table starts after RPASCDV
copy.txt (1.9 KB)

I would create a regex, then each match insert it in a data table, for each match, group 1 is the entity, group 2 the entity description and group 3 the creation date.

You need to use an Activity call Generate Data Table, but you need to filter your text to obtein useful information

In your case you need to use Regex or other thing to filter your Text

Once you have your Text use the activity and give the that text as an Input

and you will get this

@sathish_kumar3, Check this below zip file of workflow, (12.7 KB)

Hope this may help you :slight_smile: