How to capture specific sales number from email text?

[yangyq10 (IvanY)]

Dear Experts

Previously I can use below Regular Expression to capture the sales number(伝票番号) from email text

System.Text.RegularExpressions.Regex.Match(mail.Body.ToString,“(?<=伝票番号\D+)[\d,]+”).value

But now business changes and we will have another sales number(伝票番号) form which start with “G” plus 9 number

However, the above Regular Expression can only capture 9 number(900002875) under this scenario

May I know how to modify the current Regular Expression to capture both 10 number form(4646160055) and “G”+ 9 number form(G900002875)?

Thank you for your help in advance

[Yoichi]

Hi,

How about the following expression?

System.Text.RegularExpressions.Regex.Match(mail.Body.ToString,"(?<=伝票番号\s+[:：]\s+)\w+").Value

Regards,

[yangyq10 (IvanY)]

@Yoichi

Thanks for the quick feedback. I try just now but it capture nothing as result

And below is more detail for your reference

Thanks

[Yoichi]

HI,

Can you share your string as file if possible?

Or can you try the following?

System.Text.RegularExpressions.Regex.Match(mail.Body.ToString,"(?<=伝票番号\W)\w+").Value

Regards,

[yangyq10 (IvanY)]

@Yoichi

I try with the following RE but still not working. Same result as above

System.Text.RegularExpressions.Regex.Match(mail.Body.ToString,“(?<=伝票番号\W)\w+”).Value

Pls check the xaml file in the attachment
JACCS.xaml (25.6 KB)
JACCS.xaml.json (142 字节)

And below is the email form for your reference

Thanks

[Yoichi]

Hi,

First, can you set BreakPoint at the following point. Next, debug run, and workflow will stop there, then check content of currentSO at Locals panel?

If currentSo is empty, can you share text of mail body as file if possible? (WriteTextFile activity will help you)

Regards,

[yangyq10 (IvanY)]

@Yoichi

Test as you advise and its still empty
Pls check the email text in the attachment for your reference

Email Content.txt (1001 字节)

Thanks

[Yoichi]

HI,

It’s my bad.(Missing + sign) Can you try the following expression?

System.Text.RegularExpressions.Regex.Match(mail.Body.ToString,"(?<=伝票番号\W+)\w+").Value

Regards,

[yangyq10 (IvanY)]

@Yoichi Thank you for the patience. It should be ok now. There is another run in 3 hours. I will click solution closed if nothing wrong after that

Thank you again