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.