Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
rajeshvaswani77
Specialist III
Specialist III

Concatenate values in variable

Hi,

I have a variable called vErrorText

LET vErrorText ='=count({$< Server={"UKVMGAPP011"} ,Status={"ERROR"},[Log Source]={"ICC FS"},LogDate={">=' & chr(36) & '(vTodaysDate)"}>} Status)' & chr(13) & chr(10);

SET vErrorText = $(vErrorText) & ' - xyz';

If I comment out the SET statement, it prints me the exact output of the set statement.

Next I want to concatenate  - xyz to the set expression output.

Could someone help on this?

However this does not work. I am doing Somthing wrong here.

thanks,

Rajesh Vaswani

5 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

Where you are displaying the content of vErrorText?

If you are displaying in text object just give = $(vErrorText) & ' - xyz'

rajeshvaswani77
Specialist III
Specialist III
Author

I have lot of such expressions and have to keep joining them, finally would be declared as a variable for an alert to be emailed.

thanks,

Rajesh Vaswani

swuehl
MVP
MVP

Not sure if I understand what you want to achieve, but try using a LET statement in your second line to actually evaluate the concatenation.

jagannalla
Partner - Specialist III
Partner - Specialist III

can you explain little bit more... What is the input and what is your output with example.

It is not clear for us...

rajeshvaswani77
Specialist III
Specialist III
Author

Hi Jagan,

I wan to declare a heading

h1   h2   h3   h4

this will be assigned to one variable.

next the body will be hardcoded

v1   v2   v3

then set analysis expression e1 evaluated

e1

Finally the variable has to contain text

h1  h2  h3  h4

v1  v2   v3   e1

thanks,

Rajesh Vaswani