Basic text replace
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi i would like to conduct basic text replace where some of the felds = "Com" and some "Commodore"
I'd like to replace "Com" with "Commodore"
What would be the easiest way?
Thanks,
Ben
Solved! Go to Solution.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @beadyeyesbb,
In a formula tool you could use the Replace() function:
REPLACE([FIeldToPerformOn], "Com", "Commodore")
Input:
Output:
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
Regards,
Jonathan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @beadyeyesbb ,
if it's only this specific text, you can use a Formula tool. The more flexible option would be the FindReplace tool, espeically, if there is more than one text to replace. See attached workflow.
Let me know ifit works for you.
Best,
Roland
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you!