How to concat fields when values have commas?

[Bill Mills]

I have a field definition macro where the field type is "Formula" and the expression is:

CONCAT("[entry.field1]", "[entry.field2]", "[entry.field3]") and it generally works as desired.  In the field definition macro "field2" which is a drop-down field, one of the values in the drop down has a comma, eg: "This is the structure, with a comma;"

The problem I'm having is the CONCAT function is duplicating the output only for this selection so the output looks like this:

"This is the structure, with a comma; This is the structure, with a comma"

I've tried adding double "" at the start and end of each field reference in the expression without luck. 

Is there a way to work around this problem without removing the commas from the values?

Thanks!

[Shawn Doyle - ReleaseTEAM]

Hi @Bill Mills 

I'd remove the comma in the dropdown, it's the cleanest fix and more future proof.

However if you can't remove it, add RAW to the troublesome field.

RAW("[entry.field2]")

Something like:

CONCAT("[entry.field1]", RAW("[entry.field2]"), "[entry.field3]")