How to get particular text from outlook mail body

[manjusree_R_N_manju (Manjusree R N)]

Hi All, Please help me in getting text from the body of the mail. Below is the attached email i want to get only the highlighted value into a variables to pass into database.

It is giving me entire body of the mail i want only two values.

[vrdabberu (Varunraj Dabberu)]

Hi @manjusree_R_N_manju

Use this:

Input = item.Body.ToString

VCApplied = System.Text.RegularExpressions.Regex.Match(Input,"(?<=Period of VC Applied\:\s+).*").Value.Trim()

Input = item.Body.ToString

AmendmentValue =  System.Text.RegularExpressions.Regex.Match(Input,"(?<=Amendment Value\:\s+).*").Value.Trim()

Regards

[lrtetala (Lakshman Reddy)]

Hi @manjusree_R_N_manju

Try this

(?<=Amendment Value: ).*

(?<=Period of VC Applied: ).*

[sidbhatt2016 (Siddharth)]

If Regex serves the purpose for static fixed pattern based content, then good, or else for too much dynamic emails, you may need Communications Mining, which can cost additional AI units. Another alternative approach could be using GenAI prompt with input mail message as data via integration service which also cost GenAI tokens.

[manjusree_R_N_manju (Manjusree R N)]

Thank you, I am able to get the data.

[vrdabberu (Varunraj Dabberu)]

You’re Welcome @manjusree_R_N_manju

Happy Automation!!