Extracting Account number

Help Studio
1

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?

2

Hi @Seema_Jethe

Please share a sample text for extracting account number.

Thank you.

1 Like
3

@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

image
image1366×768 88.6 KB

4

Hi @Seema_Jethe

Looks like SBI account numbers are 11 digits, so you can use below one.

image

Hope this will help you. Thank you.

5

@Jobin_Joy but will the account number be always of 11 digits?

6

For SBI 11, for ICICI 12 like that.

If you are processing same bank cheque means you can use that.

Thank you.

1 Like
7

@Jobin_Joy yes i am using same cheques and for HDFC it will be 14 digits?

8

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.

9

@Jobin_Joy thanks

10

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