Getting the right syntax for Replace function

Hello all. Again, I am still very new to Alteryx Designer. I do have a use case where for a given column, I need to replace all instances where the value starts with "F" and replace with this text: "Taking everything into account, what can we do better?".

Example: F32 is replaced with "Taking everything into account, what can we do better?"

Please see screenshot. I know it's a basic question. But, I cannot seem to get the syntax right. I am assuming we also need the Startswith function.

Mike

Replace Issue.PNG

Common Use Cases

Preparation

Expression

Accepted answers

Bren_Spill2

Hi @mshinn9999 - try this: if StartsWith([Interview Question], "F") then Replace([Interview Question], [Interview Question], "Taking everything into account, what can we do better?") else [Interview Question] endif

iracine

Hello @mshinn9999 you can also achieve this by using a regex tool (one of my favorite)

I've attached an image with the configuration but you just add the pattern and the replacement text.

In my opinion it's more explicit and easier to maintain.

Capture d’écran 2024-05-25 à 12.37.10 PM.png

Have a fantastic day!

All comments

Bren_Spill2

iracine

Hello @mshinn9999 you can also achieve this by using a regex tool (one of my favorite)

I've attached an image with the configuration but you just add the pattern and the replacement text.

In my opinion it's more explicit and easier to maintain.

Capture d’écran 2024-05-25 à 12.37.10 PM.png

Have a fantastic day!

mshin

Amazing! I love this community! Thank you for quick turn-around.

Yoshiro_Fujimori

@mshinn9999 ,

Similar to @Bren_Spill2 's solution, this expression in Formula Tool would also work:

Interview Question =

IF StartsWith([Interview Question], "F")
THEN "Taking everything into account, what can we do better?"
ELSE [Interview Question]
ENDIF

fesrimo

if StartsWith([Interview Question], "F")

then Replace([Interview Question], [Interview Question], "Taking everything into account, what can we do better?")

else [Interview Question]

endif

nzp1

You could use REGEX_REPLACE("F\d\d", "Taking everything into account, what can we do better?")

mshin

Thank you all for the quick responses. I have this as future reference.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703