Get the table from text file

Help Studio
1

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

2

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.

image
image900×686 43.9 KB

3

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
image

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

image
image906×629 54.6 KB

and you will get this

4

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

Hope this may help you :slight_smile:

1 Like