String Replace in Alteryx

[rohit782192]

Hello Team,

Can anyone help me as how the Replace function work.

First Name : Rohit

Last Name : Gupta

Expected Output:

First Name : Rohit

Last Name : Wright

[NeilParrott · Accepted solution]

Hi @rohit782192 ,

The replace function is a way that you can search (case sensitive) for any character, word, or variable and replace it with a variable that you define.

For the example that you provided, the following image shows a quick workflow that specifically states to find the word "Gupta" in the Last Name column and replace it with "Wright".

I hope this gives you a little bit of a head start on working with the replace function. I also suggest searching the help/documentation section to find more details from Alteryx directly.

Neil

-

[atcodedog05 · Accepted solution]

Hi @rohit782192 

Here is the resource page on it and how it works https://help.alteryx.com/20214/designer/string-functions 

Hope this helps : )

[binuacs · Accepted solution]

@rohit782192 you can also check the available functions in the formula tool (fx - function)

[atcodedog05]

Happy to help : ) @rohit782192 

Cheers and have a nice day!

[JTSJr]

How about when using the IN DB formula tool? the above solution does not work.