How I can replace A, B, C, D, with A only? Can I use Formula tool? if so, what is the syntax
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
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