Adding signs like '' in a string field

[nidah]

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']

[AngelosPachis]

Hi @nidah ,

The following formula should give you the desired output:

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

Hope that helps,

Angelos

[nidah]

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]

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

[Christina_H]

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.