Skip to main content
ChristianW
Employee - Advisor
Oct 18, 2021 12:01 PM UTC

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

 

5 replies

ChristianW
Employee - Advisor
ChristianWEmployee - AdvisorAuthorAnswer
Employee - Advisor
Oct 18, 2021 12:01 PM UTC

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

 

ChristianW
Employee - Advisor
Employee - Advisor
Nov 17, 2021 1:18 PM UTC

You can also format the variables like this:

$"Don't mess with Debit and Credit the difference {deltaDC:N2} is larger than 100"

 

DeltaDC is a decimal and will be used in the N2 number format.

OneStream Employee
Dec 10, 2021 5:04 AM UTC

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
Employee - Advisor
Employee - Advisor
Dec 10, 2021 10:21 AM UTC

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

OneStream Employee
Dec 14, 2021 6:24 PM UTC

When you create a string, and require Carriage Returns be inserted for formatting purposes (e.g. creating an email) you can include .net newlines. 

 

Dim messageBody As String = $"Type - {SRType} {vbCrLf}Description - {SRDescription}"

 

vbCrLf or environment.newline both will work, and will create a carriage return into the message body. 

ericbegg_0-1639506231497.png