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]")

[Bill Mills]

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]"))

[Shawn Doyle - ReleaseTEAM]

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

[Bill Mills]

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