Split specific word from column with RegEx

[Khalisaaliyeva]

 I want to extract 4 and 2 uppercase words  and the 6-digit number (HB 256895  or EGBJ 125486 like this) next to it. I used ([A-Z]+\s+(\d{6})) RegEx expression in order to apply for salution. But i doesn't work 

Does there have another expression to get this output?

[DataNath · Accepted solution]

Hey @Khalisaaliyeva, I doubt it's the most succinct expression here but this looks to work for your example. Let me know if there's any issues when you apply it to a larger dataset:

(\b[A-Z]{4}\s[0-9]{6}\b|\b[A-Z]{2}\s[0-9]{6}\b)

[binuacs · Accepted solution]

@Khalisaaliyeva One way of doing this with the Regex Tokenize method

[Khalisaaliyeva]

Thank you for helping it works👍