[resolved] Data Prep - Missing Replace Regex function ?

[gonzalad]

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

[Anonymous]

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

Regards
Shong

[gonzalad]

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