Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

bigblue00
5 - Atom

Example:

 

Column Name: CollegeWhat I need
Texas State UniversityTexas State Univ.
University of TexasUniv. of Texas

 

How would I go about accomplishing this? Thanks

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@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.PNG

bigblue00
5 - Atom

Awesome, thank you

Qiu
21 - Polaris
21 - Polaris

@bigblue00 
Glad to help.

Labels
Top Solution Authors