Regex two lines

[A_Learner]

Total Charges / Activities:
Miscellaneous Charges … 100,123.40

Hi, I am trying to get the amount from the above using RegEx
(?<=Total Charges\s/\sActivities:\s*.\s)[\d+,.]+

But it is also giving me the dotted line. Can you help please?

[lrtetala (Lakshman Reddy)]

Hi @A_Learner

Try this

\d+,\d+\.\d+

[Parvathy (PS Parvathy)]

Hi @A_Learner

Try this (Modified regex expression):

System.Text.RegularExpressions.Regex.Matches(strinput,"(?<=Total Charges\s\/\sActivities:\n*.|\s)[\d,.]+")

Or use this regex expression:

System.Text.RegularExpressions.Regex.Matches(strinput,"[\d].*")

Datatype: IEnumerable(System.Text.RegularExpressions.Match)

Hope it helps!!

[Yoichi]

HI,

Can you try to add (?=\r?\n|$) as the following?

(?<=Total Charges\s/\sActivities:\s*.*\s*)[\d+,.]+(?=\r?\n|$)

Regards,

[A_Learner]

@lrtetala

\d+,\d+.\d+

Thank you. Need a generic one amount can vary like for example 123.45 and also 123,456,789.01?

Regards,

[A_Learner]

@Yoichi

(?<=Total Charges\s/\sActivities:\s*.*\s*)[\d+,.]+(?=\r?\n|$)

Thank you, @Yoichi
It works great!!
Why do I need to have $ at the end?

Thanks a lot,

[mkankatala (Mahesh Kankatala)]

Hi @A_Learner

You can use the data manipulations to extract the output data

- Assign -> strvar = "Total Charges / Activities:
                      Miscellaneous Charges … 100,123.40"
- Assign -> output = strvar.Split("…")(1).Trim.ToString

Check the below workflow for your reference

Hope it helps!!

[Yoichi]

Hi,

@A_Learner

Why do I need to have $ at the end?

Because if there is numeric character before the target, it will be matched. To prevent it, it’s necessary to set pattern the target exists at the end of the line or string (\r?\n|$).

Regards,

[A_Learner]

Thank you, @Yoichi for explaining.

[A_Learner]

Thank you @mkankatala

[mkankatala (Mahesh Kankatala)]

Thank you @A_Learner

Happy Automation!!!