RXReplace help

[Krista Dobley]

Hello - I'm trying to change a value within a transformation calculate and replace column against my data source.

FROM:["Value 1","Value 2","Value 3"]

TO: Value 1 : Value 2 : Value 3

This particular expression does NOT error, but it's also not fixing my values in the column (column data looks same as before when completed within the transformation, but if added as a calculated column, entire column is null, when next to its parent column which has values). Help!

RXReplace(RXReplace(RXReplace([MyFieldName],'","',':','g'),'["','','g'),'"]','','g')

Thank you!

[Gaia Paolini]

The only issue was that [ and ] are special characters so you needed to prefix them with \

This worked for me:

RXReplace(RXReplace(RXReplace([MyFieldName],'","',':','g'),'\["','','g'),'"\]','','g')