Regex help need

[A_Learner]

Hi, Trying the following regex just to get amount. It is also getting mm from month. Can you help? Thanks a lot,

(?<=Current Charges\s*(\d{1,2}/\d{1,2}/\d{4}\s+)?)\s?$?[\s?\d.,]+

Please find data below.
Current Charges 03/21/2020 12,389.53
Total Current Charges $126.83

[vrdabberu (Varunraj)]

@A_Learner

Use below regex

System.Text.RegularExpressions.Regex.Matches(yourinputvariable.ToString,"((\d+\,?\d+\.\d+)")

Or Use the below if the dollar symbol also required

System.Text.RegularExpressions.Regex.Matches(yourinputvariable.ToString,"((((?<=Current Charges\s+(\d+\/\d+\/\d+\s+)?)\$?\d+\,?\d+\.?\d+))")

[lrtetala (Lakshman Reddy)]

Hi @A_Learner

Please try this

(?<=Current Charges\s*\d{1,2}/\d{1,2}/\d{4}\s+).*?([\d,.]+)

Regards,

[mkankatala (Mahesh Kankatala)]

Hi @A_Learner

Use the below regex expression

To extract the current charge only

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=Charges\s+\d+\/\d+\/+\d+\s+).*)”)

To extract the Total current charges with $

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=Charges\s+)\$.*)”)

To extract the Total Current Charges with out $

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=Charges\s+\$).*)”)

To extract the both values

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=Charges\s+\d+\/\d+\/\d+\s+).*|(?<=Charges\s+)\$.*)”)

Hope it helps!!

[Ritaman_Baral]

1. (?<=Total).*
2. .*(?=Total Current Charges)

Both of this approach should work

[A_Learner]

Thanks a lot. It fits my requirement @mkankatala

Thanks every one for your help.

[mkankatala (Mahesh Kankatala)]

Thank you @Ritaman_Baral

Happy Automation!!