Replace - Newby warning!

[MaryCann]

Hello everyone.  Warning:  I am super new at Alteryx, so, if you reply, I kinda need detailed how-to stuff.  Okay, so, I have this column called "person hist baseline", unfortunately in this column "Caridovascular" is listed, not "Cardiovascular".  I'm guessing I need a Formula, with the Output Column on "person hist baseline" but, my Replace formula did not work.  Like I said, I'm new to this, so, probably did something wrong.  And, of course, I don't want to bug my boss for help - just call me stubborn.  How should the Replace formula be structured?

Thank you in advance!!  :)

[atcodedog05]

Hi @MaryCann 

Both words look same to me 🤔 Also can you show what you are doing.

Happy to help : )

[MaryCann]

Wow!  Superfast response!  Here's what I'm trying to do... (cool, I also just figured out how to paste a snip too!)

[binuacs · Accepted solution]

@MaryCann IF you have more words to replace please go with the Find and Replace tool

Formula for replacing the string

[atcodedog05]

Hi @MaryCann 

You need to provide input column name first like below

Hope this helps : )

[MaryCann]

WAHOO!!!!  You folks are awesome!!!

[atcodedog05]

Happy to help : ) @MaryCann 

If my response helps please don't forget to mark it as solution.

Also here are some great resources to get started https://community.alteryx.com/t5/Learning-Paths/tkb-p/learning-path 

All the best in the journey 🙂

Cheers and have a nice day!

[alteryxnewby]

.