community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Replace Function

Asteroid

I have a of words - "release prpd; Blue Ash ended" that I want to replace with "Blue Ash, OH"  Seems like it should be simple, but I cannot figure it out.  Possibly has something to do with the data type?  Thanks!

Alteryx Certified Partner
Alteryx Certified Partner
Let's try:

Replace([Field],"release prpd; Blue Ash ended" , "Blue Ash, OH")

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Asteroid

Thanks, that worked.  I just thought there might be a better way, rather than typing out all the text that I wanted to replace.

Alteryx Certified Partner
Alteryx Certified Partner
Regex_Replace([Field],"(.*Blue Ash.*)" , "Blue Ash, OH")


Replaces anything that includes Blue Ash with the Blue Ash, OH.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels