REGEX Help needed to extract Invoice Number

[hurmet.noka]

Hello Guys, I need your help:
Input ------------------------------Output
Invoice no. 00067250------------------67250
LX220727233ANI17
01993872209006CB
00067183-----------------------------67183
INV 65739J41840Originalbetr.--------65739

Invoice Number starts with 6 or 7 and is 5 Numbers. Problem is that I dont want to be extracted anything in the records with input like: LX220727233ANI17 or 01993872209006CB
Sometimes Invoice number starts with 000 sometimes not, I don’t need the 000 part.

Can you please build a REGEX to give the output outlined above?

Thank you so much

[hemanth.bhat]

Hi @hurmet.noka ,
“Invoice Number starts with 6 or 7 and is 6 Numbers”
-however your o/p is 5 digits starting with 6 or 7 +4 characters

below regrex will find invoice numbers matching 4 till 5 characters starting from 6 or 7
([6|7][\d]{4,5})
pfb the pattern and test data using regex101
Regex101 pattern
Regards

regex101: build, test, and debug regex

[Rahul_Unnikrishnan]

Hello @hurmet.noka

Is this the static format for all the files? Can you share 2 real files here or a screenshot of both.

Thanks

[THIRU_NANI (NaNi)]

Hey!

Try this:

System.Text.RegularExpressions.Regex.Matches(StrInputVariable,"[6]\d+").ToString

Reference:

regex101: build, test, and debug regex

Regards,
NaNi

[ushu (Usha kiranmai)]

Hello @hurmet.noka How about this expression

System.Text.RegularExpressions.regex.Matches(Input,"(?<=Invoice\s+no.*)[6|7]\d{4}|(?<=INV.*)[6|7]\d{4}|(?<=000)[6|7]\d{4}")

Output

Below workflow for ref

Example.zip (3.2 KB)

[hurmet.noka]

What if it can start also with 7,
In this case i dont want to extract anything from this:
LX220727233ANI17
01993872209006CB
Thank you

[hurmet.noka]

In this case i dont want to extract anything from this:
LX220727233ANI17
01993872209006CB
Thank you

Your example extracts it.

[hurmet.noka]

Very Specific, I have different scenarios where there is no Inv or invoice but just a long text like this:
01993872209006CB
On this case i dont want to extract the bold part

[ppr (Peter Preuss)]

give a try at:

refering to the groups

\b(0*?)((6|7)\d{4})

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

[hurmet.noka]

@ppr

\b(0*?)((6|7)\d{4})

You are fantastic!