Forum Discussion

EZimmet's avatar
EZimmet
Resolver I
3 years ago
Solved

Merging two fields and adding text between them

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 "

 

Need Help
  • RMDNA's avatar
    RMDNA
    3 years ago

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

     

2 Replies

  • RMDNA's avatar
    RMDNA
    Solution Sage
    3 years ago

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