Extract only the Table from a chain of emails

Help Studio
, , , ,
1

I have an Email chain from which I want to extract only a table. how can I do it?
My email format is as below

Kindly check the following table and extract it to send in

ID Region City In-deended
155 Lahore C-1 2
416 Lahore C-1 2
1 Lahore C-1 2
2 Lahore C-13 2
123 Faisalabad C-12 2

Regards,

Abc sender

and I want to extract only thefollowing table

ID Region City In-deended
155 Lahore C-1 2
416 Lahore C-1 2
1 Lahore C-1 2
2 Lahore C-13 2
123 Faisalabad C-12 2
2

You can read the body in a string variable, and the split the screen with a keyword after which the table is there.

Then split the string containing table data using space, you’ll get an array, just take 4 array elements at a time and add it to a datatable.

3

Hi @faiqaqureshi90,

You can try @rahulsharma method as well, and if you can extract only the datatable using Regex and use generate datatable activity and provide the seperators to extract the table