SOLVED
alteryx find startwith and replace
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ryanzhang487
8 - Asteroid
‎03-09-2023
12:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
2 REPLIES 2
alexnajm
17 - Castor
‎03-09-2023
12:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Try a Formula: IF StartsWith([field],"IK) THEN ReplaceFirst([field],"IK","IKA" ELSE [field] ENDIF
BS_THE_ANALYST
14 - Magnetar
‎03-09-2023
12:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator