Regex alue after net amount]

Help
1

I need to extract the after the net amount]
i need the value 40463 its may be vary 7 or 10 digit numbers
[Invoice Number Customer Account/ Comment PO Number Date Due Date Amount Discount Net Amount]
40463 10350 8/20/2019 8/20/2019 $999.00 $0.00 $999.00

2

Hello @veera_g
Try this Pattern
(?<=Net Amount])\n\d+
Check this workflow for better understanding
Regexx.xaml (5.4 KB)

Check this website to learn more about Regex
https://regexone.com/

4

Untitled1
Untitled13360×1080 360 KB

could u please try this as string file

6

Accounts Receivable Department:
I THIS IS A CONFIRMATION OF OUR CARD PAYMENT I
[Invoice Number Customer Account/ Comment PO Number Date Due Date Amount Discount Net Amount]
40463 10350 8/20/2019 8/20/2019 $999.00 $0.00 $999.00
Total: $999.00
Please charge a total of $999.00 to MasterCard
Card Number: 5567660670830905 Expires: 10/ 2019
CCV: 571
Cardholder Name: NVoicePay, Card Holder Company
Name: NVoicePay
Billing Address: 8905 SW Nimbus Avenue Suite 240,
Beaverton, OR 97008

  • IMPORTANT:
    C) nvomepay , . ’
    If you require the security code, please contact the customer directly.
    If you have other questions please call Vendor Services at 877.626.6332.
    If you are changing your payment email address or bank account, please email
7

i convert to this its not coming

8

@veera_g

System.Text.RegularExpressions.Regex.Match(yourStringVariable," (?<=Net Amount])\n\d+").ToString in Assign Activity

Your stringvariable which is get from notepad

9

could send xaml i tried a not

10

Hello @veera_g
Check this workflow
Regexx.xaml (7.6 KB)

11

Thanks a lot

12

Sent By: El - -
. . ectronlc Pa ment Advnce
Findlay Bunck GMC Prescott y
1006 Commerce Drive F -
nda , Au ust 23, 2019
Prescott, AZ 86305 y 9
Contact: Roxanne Eikenberry roxie@findlayauto.com
Paid To:
EDMUNDS.COM
E000043
PO BOX 783531
PHILADELPHIA, PA 19178-3531
Accounts Receivable Department:
I THIS IS A CONFIRMATION OF OUR CARD PAYMENT I
[Invoice Number Customer Account/ Comment PO Number Date Due Date Amount Discount Net Amount]
BS3966 8/11/2019 8/30/2019 $1,500.00 $0.00 $1,500.00
Total: $1,500.00
Please charge a total of $1,500.00 to MasterCard
Card Number: 5567660670850846 Expires: 10/ 2019

same again am not getting this workflow
could u please help me out

13

Hello @veera_g
Check this second Method
RegexSecond Method.xaml (8.2 KB)
The previous pattern was used to get only digits this will get the Letters as well

1 Like
14

thanks alot a quick help

15

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