Split specific word from column with RegEx

Question

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 Answer

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)

binu_acs · Accepted Answer

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