How to pull a one value into a variable from multiple Regex lines returned

Help
, , , ,
1

Hi all,

I am using a Regex on the body of an email to pull a certain value into Excel. I am able to split the many numbers from the body and produce a list of them using the ‘Write Line’. The value I need to put into a variable will always be the 4th number in the body of the email. Is there a better way to single out this value since it, and the strings before/after it, change daily?

Thanks in advance for any help.

Capture

1 Like
2

Hi
once after using MATCHES METHOD and get the output witth a variable named out_matches
use this expression in a writeline activity
out_matches(3).ToString

Cheers @Ltanksley

1 Like
3

This worked perfectly. Thank you for the assistance.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.