One Star

[resolved] Data Prep - Missing Replace Regex function ?

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 Smiley Wink).
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

  • Dataprep
2 REPLIES
Community Manager

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

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

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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