Hello my fellow data buddies,
I require some data in the formula tool to extract a combination of letters and numbers from the image attached highlighted in yellow - I have tried it but its not working - i am not surprised as my lack of regex knowledge is below par.
thanks for your help!
I'm a little confused by your question. When you say extract, do you mean you want to parse this out? If so, the RegEx tool itself is an option, like so - assuming it's always <numbers><letters><numbers>:
You can also parse it with the following in formula (which is more dynamic to other combinations i.e. <letter><number>). If you just want a flag if there's a combination (i.e. not just numbers), the following should work:
If not, let me know and I'll take another look!