Get Invoice Number from starting or end

[Binod_Kumar_Biswal]

Hi I need to extract the invoice number from the email subject which is generally at the end of the email subject.
For example: “Settlement Invoice: Xyz company 2023 final deal 653457”
Or
“ 653457 Settlement Invoice: Xyz company 2023 final deal ”

From above how do I need to extract the"653457" number only.

Thanks in Advance

[yikwen.goo]

If the invoice number’s always 6-digits you could use regular expressions to fetch the 6-digit number from the text [0-9]{6}

[arjunshenoy]

Hi @Binod_Kumar_Biswal

You can try using this RegEx pattern:

\b(\d+)$

UiPath Syntax:

extractedValue = System.Text.RegularExpressions.Regex.Match(yourString,"\b(\d+)$").ToString

Hope this helps,
Best Regards.

[Binod_Kumar_Biswal]

It’s not mandatory that invoice number will be 6 digits, it will be number followed by email subject or email subject followed by number

[Binod_Kumar_Biswal]

Hi Arjun,

Thanks for the help
But this expression is only working if the invoice number is in the end of email subject not at the first. Can you please share what changes need to be done if the invoice number will be in the starting of the email subject also ?

[yikwen.goo]

Hm if there’s no fixed pattern to the invoice number, regular expressions won’t work. If you’re certain that the invoice number will always be the first word or the last word, perhaps splitting the email subject and fetching the first and / or the last word can be done. But you’ll still need to verify afterwards whether the word you’ve fetched is an invoice number or not.

Strings.Split("653457 Settlement Invoice: Xyz company 2023 final deal", " ").First or Strings.Split(“Settlement Invoice: Xyz company 2023 final deal 653457”).Last

[arjunshenoy]

@Binod_Kumar_Biswal

Well, in that case, you can the following pattern:

\b(\d{6})\b

You can also take a group of data & get the number, just in case the string contains any other combination of 6 digits.

Hope this helps,
Best Regards.

[Binod_Kumar_Biswal]

Invoice number can be anything ranging from 2 digit to 8 digit then only this is gix either the invoice number will came at starting or at the end of the email subject.

[Anil_G (Anil Gorthi)]

@Binod_Kumar_Biswal

Please try this

(^\d{2,8}|\d{2,8}$)

This will check for 2 to 8 digits at the start or end

Cheers