Regex to extract IBAN ignoring colon

Asked Mar 18 '19 at 13:03

Active Mar 18 '19 at 13:10

Viewed 72 times

I want to improve regex that works with the following string:

Uw BTW nummer NL80

IBAN NL 11abna0317164300asdfasf234

(SPACE)iBAN NL21ABNA0417134300 22

Iban: NL 29 ABNA 401422366f sdf

IBAN :NL 39 ABNA 0822416395s

And created regex failed to extract IBAN Mask on the 4th line. I want to improve it by allowing zero or one occurrence of colon (:) after IBAN and zero or one space after colon character.

(?<=[Ii][Bb][Aa][Nn]\s).*[Nn][Ll]\s?\d{2}\s?[a-zA-Z]{4}[0 ]\s?\d{9,10})

Regex demo:

https://regex101.com/r/zGDXa2/7

Much appreciated!

edited Mar 18 '19 at 13:10

Allan

11,650
3
27
49

asked Mar 18 '19 at 13:03

Ian Kuzin

Try replacing `\s` with `[\s:]`, see https://regex101.com/r/zGDXa2/8 – Wiktor Stribiżew Mar 18 '19 at 13:06
Is `NL 29 ABNA 401422366f` IBAN correct? It has an `f` at the end. – Asunez Mar 18 '19 at 13:19
U already asked this question, people already helped you, u didn't reply and created new one. – Dmitrii Mar 18 '19 at 13:20
It was 2 different approaches how to ignor : – Dmitrii Mar 18 '19 at 13:21
Maybe something like this? https://regex101.com/r/zGDXa2/10 – Asunez Mar 18 '19 at 13:22
I have answered your question in the duplicate! Have a look ;-) – Allan Mar 18 '19 at 13:31
@WiktorStribiżew Much appreciated, it work! have to only adjust splitting colon on the fifth line. – Ian Kuzin Mar 18 '19 at 13:53
@Asunez Thanks, yes it was appended just for testing ) – Ian Kuzin Mar 18 '19 at 13:54
@Dmitrii pardon, sir i am a rookie to local SO interface will be more accurate from now on – Ian Kuzin Mar 18 '19 at 13:56
@Asunez Much appreciated, it works in case one wants to split string including IBAN as well. – Ian Kuzin Mar 18 '19 at 13:59
@Allan Much appreciated! – Ian Kuzin Mar 18 '19 at 14:00

Regex to extract IBAN ignoring colon

0 Answers0