Forum Discussion

ChristianW's avatar
ChristianW
Icon for OneStream Employee rankOneStream Employee
4 years ago
Solved

Avoid "&&" in string operations?

Hi all How can I avoid the ampersand in string operations? I need to concatenate a pov for a calculation, but with all the ampersands, it looks complicated: "A#" & accountName & ":F#" & flowName ...
Admin
Connectors
cubeview
dashboards
Extenders
Finance
Parsing
Spreadsheet
System
XFBR
  • ChristianW's avatar
    ChristianW
    4 years ago

    If you use the $" you can avoid all ampersands and ease the reading of calculation strings.

    instead of

    "A#" & accountName & ":F#" & flowName & ":UD2#" & ud2Name & ":UD4#" & ud4Name

    you can simply write

    $"A#{accountName}:F#{flowName}:UD2#{ud2Name}:UD4#{ud4Name}"

     

ericbegg's avatar
ericbegg
Icon for OneStream Employee rankOneStream Employee
4 years ago

Note that the variable is bracketed by the curly braces {}, they are hard to discern on the web page.  If you copy and paste Christian's example you will see that the character is not a parentheses or square bracket. 

  • ChristianW's avatar
    ChristianW
    Icon for OneStream Employee rankOneStream Employee
    4 years ago

    Thank you Erik, I changed the samples to code samples mode, maybe it is now easier to copy.