SOLVED
Address abbreviations in workflow
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
Kinetic_analytics
11 - Bolide
‎03-24-2022
08:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
9 REPLIES 9
binuacs
21 - Polaris
‎03-24-2022
09:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎03-24-2022
09:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for helping me learn alteryx better.
jonnyrask
8 - Asteroid
‎03-24-2022
09:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Probably the easiest way to do this would be with a formula tool with this formula
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE([Old],"Street","St"),"Road","Rd"),"Avenue","Av"),"Lane","Ln"),"Boulevard","Blvd")
oliverd
7 - Meteor
‎03-24-2022
09:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎03-24-2022
09:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
could you please attach the workflow?
‎03-24-2022
11:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
could you please share the workflow with me?
‎03-24-2022
01:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How about I have to replace 20 different "words"? in that case, do I need to use replace 20 times?
jonnyrask
8 - Asteroid
‎03-24-2022
01:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes, with this method you would have to use the Replace for as many words as you have.
Did the other solution above provided by @oliverd not solve your issue? If so, please reassign the solution tag accordingly
oliverd
7 - Meteor
‎03-25-2022
07:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for accepting my solution!
