Address abbreviations in workflow

[Kinetic_analytics]

Hello:

How can I transform this following workflow?

Thanks

[binuacs · Accepted solution]

@Kinetic_analytics 

[Kinetic_analytics]

Thank you for helping me learn alteryx better. 

[jonnyrask]

@Kinetic_analytics -

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 · Accepted solution]

I used a small RegEx

[Kinetic_analytics]

could you please attach the workflow?

[Kinetic_analytics]

could you please share the workflow with me? 

[Kinetic_analytics]

How about I have to replace 20 different "words"? in that case, do I need to use replace 20 times?

[jonnyrask]

@Kinetic_analytics 

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]

Thank you for accepting my solution!