Extract Invoice Number Excel Records

Hi guys.

For incomings we have these descriptions:

INVOICE GAG 22065 DOWN PAYMENT INITIAL TYPE RATING C510 FLIGHT SAFETY FARNBOROUGH UK
JET22.0501 BALA INV 00064213 OF 03 MAY 2022
00062057/ZTD744-002 Daniel Kohle vom 2.2.2022
INVOICE 00061672
2nd down payment Invoice No.: GAC-22066
UQV129 I9V1J0
HQU766 N4V1V7
ABJ302 Y6R9Q8
TLY666 X6Z2C6
UGK916 S0L6G3
TLY666 U1N4C5
TDN566 I5N2U0
00063903
JetCard
Konto bei IhNr.00063927/21.4.2022
Catering Invoice INv 00064101J41273

These are some rows.
Now I want to Extract Invoice Number which can be 00063930 or 63930
It alwys starts with 6 until i goes to 70000 Invoices.
So if the row is: Konto bei IhNr.00063927/21.4.2022
I need to Extract 63927

Only when its present.
Can you help me with the regex ?

This regular expression will extract invoice numbers starting with 6 or 7:

(?<=Konto bei IhNr\.0*)[6-7]\d+

image

Thank You
I want to extract invoice number in every record where is present regardless of the text before or after the number.

Thank You

Catering Invoice INv 00064101J41273
For instance here the output should be 64101

Would this do?

(?<=0+)[6-7]\d{4}

image

1 Like

@hurmet.noka ,

Will the invoice number always starts with 6? or in future that can also change?

1 Like

Always with 6, in the future will be 7 i can change it myself, i need the example for the starting with 6 scenario…

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