Merging two fields and adding text between them

[EZimmet]

Good day and thank you all for your help

When adding text and merging two fields this would be the standard code format:

        each " Department_ID " & " : " &  [Field1] &" , " & " Cost_Code " & " : " &  [Field2]

I need this to be the output format and it must include the " is there another character to use in the code format to allow for this to be in the output value or a trick someone knows - TY

         " Department_ID " : "X4550", " Cost_Code " : "  CC-US123 "

[RMDNA · Accepted solution]

Hi @EZimmet - the escape character for quotes in a string is just two quotes. The formula you're looking for is:

[Measure name] = """Department_ID""" & " : " & """X4550""" & "," & """Cost_Code""" & " : " & """CC-US123"""

[RMDNA · Accepted solution]

Hi @EZimmet - the escape character for quotes in a string is just two quotes. The formula you're looking for is:

[Measure name] = """Department_ID""" & " : " & """X4550""" & "," & """Cost_Code""" & " : " & """CC-US123"""

[EZimmet · Accepted solution]

That worked - TY