Alteryx Designer Discussions

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

Adding signs like '' in a string field

nidah
5 - Atom

i have a column ACCOUNTS, with data 

AC_123,AC_456,AC_676

 

I need to format it in this order

-['AC_123','AC_456','AC_676']

4 REPLIES 4
AngelosPachis
15 - Aurora

Hi @nidah ,

 

The following formula should give you the desired output:

 

"-['"+Replace([Your_Input_Field],",","','")+"']"

 

AngelosPachis_0-1634673721495.png

 

 

Hope that helps,

Angelos

nidah
5 - Atom

thanks a lot, 

its working for the first row, but for the rest of the rows the (,) & ('') is missing

e.g: 

-['AC_200AC_205','AC_2006','AC_207','AC_208']
AngelosPachis
15 - Aurora

@nidah Is there a comma originally between 200 and AC?

Christina_H
11 - Bolide

Assuming the problem is a missing comma between account numbers, you could instead use RegEx to tokenize all valid account numbers then use a summarize tool to concatenate.

Christina_Hurrell_0-1634722476748.png

 

Labels