Adding signs like '' in a string field

Question

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

Christina_H · Answer

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.

Quotes in strings.yxmd

AngelosPachis · Answer

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

nidah · Answer

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