tkiran
(Kiran T)
March 22, 2022, 1:29pm
1
Hello,
Can anyone please help me on this Regex part…
How to check using Regex whether dollar amount listed after line that reads “2nd Loan Amount :”
Sometimes the dollar amount may not be available. In my workflow if it is available then it will proceed or if it is not available then it should log message as dollar amount not exits
[If Applicable] 2nd Loan Amount: 100,000.00
Yoichi
(Yoichi)
March 22, 2022, 1:41pm
2
Hi,
How about the following expression?
System.Text.RegularExpressions.Regex.IsMatch(yourString,"(?<=2nd Loan Amount:\s*)\d[.,\d]*")
Regards,
arivu96
(Arivazhagan A)
March 22, 2022, 2:11pm
3
Hi @tkiran ,
Try below Regex pattern
(?<=2nd Loan Amount: )[0-9][0-9,\.]+
Refer below path
Regular expression tester with syntax highlighting, explanation, cheat sheet for PHP/PCRE, Python, GO, JavaScript, Java, C#/.NET.
Regards,
Arivu
Gokul001
(Gokul Balaji)
March 22, 2022, 2:16pm
4
Hi @tkiran
Another pattern look into this
System.Text.RegularExpressions.Regex.Match(inputString,"(?<=2nd Loan Amount: )[\d,\.]*").Tostring.Trim
Regards
Gokul
tkiran
(Kiran T)
March 22, 2022, 2:36pm
5
Hi Yoichi,
Its work perfectly !!!.. Thank you so much
one more thing if dollar amount exits then how to replace [If Applicable]
1 Like
Yoichi
(Yoichi)
March 22, 2022, 11:43pm
6
Hi,
Glad to seem your problem has been solved.
Hello all,
Can anyone please help me…
I want to remove [If Applicable] and my Output should be
[image]
Output:
[image]
Regards,
system
(system)
Closed
March 25, 2022, 11:43pm
7
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.