alteryx find startwith and replace

[ryanzhang487]

Hi community, I have a column with some data like "IK-400", "IK-323" or "IK-XAS", i would want to replace it to IKA-XXXX",

anything startswith IK- and i would like to replace it to IKA-, 

how can I do that please?

Thank you

[alexnajm · Accepted solution]

Try a Formula: IF StartsWith([field],"IK) THEN ReplaceFirst([field],"IK","IKA" ELSE [field] ENDIF

[BS_THE_ANALYST · Accepted solution]

@ryanzhang487  One way:

Using RegEx. Workflow attached