1 of 1 people found this helpful
I don't have access to Tableau at the moment, so I can't test anything. But if you need separate groups, you can create multiple calcs. So for example to extract numbers:
REGEXP_EXTRACT([Your String], 'Código Viejo CNE:(\d+)')
REGEXP_EXTRACT([Your String], 'Latitud:(\d+)') etc..
For the text part, I believe this should work:
REGEXP_EXTRACT([Your String], 'Dirección:(.+)Código Viejo CNE:')
Let me know if it doesn't!
I almost worked for all the conditions, I just needed to adjust it a little bit is it bring me the digits after the dot. I did this:
REGEXP_EXTRACT([Center], 'Latitud: (\d+\.\d+)')
Awesome! Glad that helped