Variable within Text

Lingwisyer — Fri, 04 May 2018 03:30:34 GMT

Hi all,
Figured this would similar to how it is in excel and basic but I can't figure out how to do it...

1. How do you insert a variable into a text string? eg. "1:variable_x @ A1"
2. How can you insert a text string at the end of a calculation? eg. variable_y=variable_x*5 "outlets"

Ling.

Re: Variable within Text

Barry Kelly — Fri, 04 May 2018 03:59:11 GMT

Lingwisyer wrote:
1. How do you insert a variable into a text string? eg. "1:variable_x @ A1"

If variable_x is a string value then you can just concatenate (add) them together.

"1:" + variable_x + "@ A1"

If variable_x is a numeric value then you have to convert it to a string.

"1: " + STR(variable_x,2,0) + " @ A1"

Lingwisyer wrote:
2. How can you insert a text string at the end of a calculation? eg. variable_y=variable_x*5 "outlets"

variable_y must be a string variable of course.
Then same as before if variable_x is a string value then you can just concatenate (add) them together.

variable_y = variable_x + "*5 outlets"

If variable_x is a numeric value then you have to convert it to a string.

variable_y = STR(variable_x,2,0) + "*5 outlets"

Or if you actually want to multiplt variable_x * 5 then

variable_y = STR(variable_x*5,2,0) + " outlets"

Barry.

topic Variable within Text in Libraries & objects

Variable within Text

Re: Variable within Text