topic [resolved] Data Prep - Missing Replace Regex function ? in Data Quality

[resolved] Data Prep - Missing Replace Regex function ?

gonzalad — Sat, 16 Nov 2024 10:43:32 GMT

Hello,
I just tried Data Prep application - it's a really nice and easy to use app.
Just a little question : is there a replace regex function ? (perhaps I've missed it - sorry in this case ).
For instance replace '(\d+)/(\d+)/(\d+)' with '\2/\1/\3'
From what I understand I can do that with 'Extract String parts' and afterwards 'Concatenate with...', but this seems awkward.
Thanks,
Adrian

Re: [resolved] Data Prep - Missing Replace Regex function ?

Anonymous — Fri, 25 Mar 2016 02:47:36 GMT

Hi
You can select 'Replace the cells that match...' function and Regex operator. see

Regards
Shong

Re: [resolved] Data Prep - Missing Replace Regex function ?

gonzalad — Fri, 25 Mar 2016 09:42:35 GMT

Hi Shong,
Oups, missed this icon, sorry !
Everything works fine now :
I use pattern '^(\d+)/(\d+)/(\d+)' and replacement value '$2/$1/$3'.
Thanks for your help