In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Find and replace

Kjaer
8 - Asteroid

Hi

I have a simple dataset, where I want to replace "PR" with "01" so PR-07-2021 becomes 01-07-2021. But how? I have tried "Find and replace" but no. The column is set as a v-string. 

2 REPLIES 2
messi007
15 - Aurora
15 - Aurora

@Kjaer,

 

You can do that with a formula :

 

messi007_0-1659340652277.png

 

Attached the workflow,

Regards

 

Kjaer
8 - Asteroid

Thanks, it works :-)

Labels
Top Solution Authors