Need to convert HTML table in mail body into data table without using DATASCRAPING

Help Activities
, ,
1

Hi everyone,

I need to bring HTML table in mail body into a data table using string manipulations or REGEX without using Data Scraping.

Please help me out on this.it is very urgent and important to do.

Regards,
Roman reigns.

2

Hi @User_98

Can you share the sample input

Regards

3

@User_98

Use cml parser and then use loop on the parsed output and create a table

Deserialize is what will help

Cheers

4

Hi @vrdabberu ,

Thank you for your reply. Here is the sample HTML table please find it.

Regards,
Roma reigns.

Screenshot 2024-01-06 145511
Screenshot 2024-01-06 1455111126×230 8.2 KB

5

Hi @User_98

Please check on below post

Cheers!!

6

Hi @lrtetala ,

I should use only REGEX or string manipulations to extract table from mail body. That is the requirement.

Regards,
Roman reigns.

7

Hi @User_98

Use an assign activity and then use the below regex expression and that might extract the data you required.

RequiredDate = System.Text.RegularExpressions.Regex.Match(CurrentMail.Body.ToString,"(col1([\s\S]*?[A-Z][a-z]+\d+)+)").Value

Hope it works!!

Regards