How to concat fields when values have commas?

Question

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!

Bill Mills · Answer

No problem, I appreciate the replies.  Unfortunately TEXT didn't work either.

Shawn Doyle - ReleaseTEAM · Answer

Try TEXT instead of RAW.  Sorry I don't have a Data Center version handy to test on.

Bill Mills · Answer

Thanks for the suggestion.  I'll remove commas if absolutely necessary, but the actual values are based on Business Unit names that have them in multiple instances.

I tried the approach of adding RAW() but unfortunately it didn't work.

I tried with one of the fields:

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

With all of the fields separately:

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

And with all fields as one:

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