jollyreaper
Technical User
I need to change the way a formula is working. Right now it's taking variables and making them look like this: "variable 1, variable 2, variable3"
I need to make it look like:
"Variable 1
Variable 2
Variable 3"
I'm using logic to remove variables that are blank.
dim text as string
if {COLORC.CHOICE1} <> "" THEN
Text = Text + {COLORC.CHOICE1}
end if
if {COLORC.CHOICE2} <> "" THEN
Text = Text + ", " + {COLORC.CHOICE2}
end if
if {COLORC.CHOICE3} <> "" THEN
Text = Text + ", " + {COLORC.CHOICE3}
I saw mention of using chr(13) but I think that's just for ASP. I know this has gotta be an easy one. Help! Thanks.
I need to make it look like:
"Variable 1
Variable 2
Variable 3"
I'm using logic to remove variables that are blank.
dim text as string
if {COLORC.CHOICE1} <> "" THEN
Text = Text + {COLORC.CHOICE1}
end if
if {COLORC.CHOICE2} <> "" THEN
Text = Text + ", " + {COLORC.CHOICE2}
end if
if {COLORC.CHOICE3} <> "" THEN
Text = Text + ", " + {COLORC.CHOICE3}
I saw mention of using chr(13) but I think that's just for ASP. I know this has gotta be an easy one. Help! Thanks.