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

     

  • EZimmet's avatar
    EZimmet
    3 years ago

    That worked - TY 

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

 

EZimmet's avatar
EZimmet
Resolver I
3 years ago

That worked - TY