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?
Solved! Go to 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)
Thank you for helping it works👍