Replace

[kimvaldez]

How I can replace A, B, C, D, with A only? Can I use Formula tool? if so, what is the syntax

[Luke_C]

Hi @kimvaldez 

You can use a replace (either normal or regex) formula or a find and replace tool. Your example is a bit unclear, but if your data is literally "A, B, C, D," then you could do:

Replace([Field Name],"A, B, C, D,","A")

Hopefully this helps, otherwise provide additional sample data. 

Additional Resources

Find and Replace | Alteryx Help

String Functions | Alteryx Help

[afv2688]

Hello @kimvaldez ,

would recommend for this case using the “contains” formula.

IIF(Contains([Field1], “A”), “A” , [Field1]) 

that way to doesn’t matter if it goes A,B,C,D or A,B,C for example 

regards