Example: Column Name: CollegeWhat I needTexas State UniversityTexas State Univ.University of TexasUniv. of Texas How would I go about accomplishing this? Thanks

Alteryx Academy
MyAlteryx
Knowledge
Help Docs

Home
Participate
Discussions
Alteryx One

I have a column that sometimes includes a word that I need abbreviated

Example:

Column Name: College	What I need
Texas State University	Texas State Univ.
University of Texas	Univ. of Texas

How would I go about accomplishing this? Thanks

Workflow

Fuzzy Match

Accepted answers

Qiu

@bigblue00
If you only have one word to replace, a Replace function should do it.
If you have multiple instances, then Find and Replace should be good.

0815-bigblue00.yxmd

All comments

Qiu

@bigblue00
If you only have one word to replace, a Replace function should do it.
If you have multiple instances, then Find and Replace should be good.

0815-bigblue00.yxmd

bigblue00

Awesome, thank you

Qiu

@bigblue00
Glad to help.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703