Need regex expression to scrape particular data from e mail body

[90s_Developer (Murli Manohar K)]

@Aleem_Khan ,

Follow these steps,

Use Matches activity, and select RegEx as Email.

This will fetch all the email addresses present in that string.

kindly mark it as a solution that would be helpful to others for further reference, and also the query will get closed.

Regards,
@90s_Developer

[90s_Developer (Murli Manohar K)]

Hi @Aleem_Khan,

Can you update me regarding this query?

If your issue is solved, kindly mark it as a solution that would be helpful to others for further reference, and also the query will get closed.

Regards,
@90s_Developer

[Sudharsan_Ka]

HI @Aleem_Khan

For Example 1:
regex101: build, test, and debug regex

For Example 2:
regex101: build, test, and debug regex

You need to use split(RegexVarible,Environment.NewLine) to store all the emails in the array and you can use them by looping or incrementing.

For Example 3:

Can you send any constant word that is right below the table?
I will send you the expression

Hope this helps

Regards
Sudharsan

[Sudharsan_Ka]

An also send the example 3 table as text format with the exact format of space by setting preserve format as true in read PDF text and use write test file and copy the table part and send here

Regards
Sudharsan

[Sudharsan_Ka]

First try to separate the whole table as separate string like this

regex101: build, test, and debug regex

And use the following regex to get the table values

regex101: build, test, and debug regex

Note: You need to choose regex option as insensitive in matches activity if you use matches activity

if you use expression you need to give " ,Regexoption.insensitive "after the pattern

For splitting and saving in excel follow the steps or workflow in this thread

Need help for Invoice extraction using Reg Ex

Hi All, [MicrosoftTeams-image (7)] [MicrosoftTeams-image (6)] Please help me with the pdf data extraction using regex, in the attached pdf the header is in 2 rows and (line items is also in 2 rows for single line) I want to extract the data into excel as per given example below… please help PRODUCT ID.pdf (53.3 KB)

Hope this Helps

Regards
Sudharsan

[Aleem_Khan (crazy bot)]

Thank you so much for your effort I really appreciate I use email extraction to fetch email id from email body

[90s_Developer (Murli Manohar K)]

Hi @Aleem_Khan,

If your issue is solved based on the solutions which were given in the above replies by us, kindly mark it as a solution to close this query else it would be in the active state until it mark as a solution to any one of the replies.

Regards,
@90s_Developer