I want to extract account number from cancelled cheque using regex. Can anyone please tell me what should be the regular expression to extract it?
1 Like
@Jobin_Joy I want to extract account number from cheque shown below but when i use \d[9,18] i get telephone number and account number both as output but i need only account number as output from the cheque Could u please help me with this issue?
Below is the screenshot
Hi @Seema_Jethe
Looks like SBI account numbers are 11 digits, so you can use below one.
Hope this will help you. Thank you.
@Jobin_Joy but will the account number be always of 11 digits?
For SBI 11, for ICICI 12 like that.
If you are processing same bank cheque means you can use that.
Thank you.
1 Like
@Jobin_Joy yes i am using same cheques and for HDFC it will be 14 digits?
Yes 13 or 14.
If you have multiple bank cheque means create a master excel file for account number lenght based on below one.
Thank you.
@Jobin_Joy thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.