Extracting invoice number (regex)

#1

Capture4

how can i extract invoice number from above using regular expression

#2

Hello @asiv.balan,
Please use write text file activity to see the structure of pdf.
And then find the patterns before and after the invoice number, ie, 13882 and apply regex accordingly.

1 Like
#3

Capture5

ya i am getting text file like this, please explain me the reg ex for getting invoice number

#4

Try using this expression - ā€œ\d{1,2}/\d{1,2}/\d{2,4}\n\d+\nā€

1 Like
#5

@sakshik thank you sakshi i will check it

#6

@asiv.balan Check if the Invoices you have will always be in the Same format or not.

1 Like
#7

ya @supermanPunch same format only

#8

@asiv.balan Then What @sakshik suggested Should work :sweat_smile:

1 Like
#9

Whether the length of the Invoice number will be constant( For example 5 digits)??

#11

5 digits

#12

Then use this below code,
System.Text.RegularExpressions.Regex.Matches(InputString,"\d{5}")(0).ToString

2 Likes