I have two fields, application and servletName. I'd like to have them as column names in a chart. I'm currently trying to use eval to make a new variable named fullName, and concatenate the values for application and servletName with a dash(-) in the middle. How do I do this?
This is a question that has many hits. I just wanted to point out that there is another possibility
<basesearch> | strcat field1 " some text: " field2 " more text: " field3 newField
This will concatenate fields and text to the new field 'newField'
strcat has the advantage that it will still create the new field if one of the fields that are concatenated are empty/missing
'strcat' works great for more than two fields as well. The 'allrequired=f' flag also allows you to concatenate the fields that exist and ignore those that don't.
| strcat allrequired=f email "|" uname "|" secondaryuname identity
The above will combine the three fields, 'email', 'uname', and 'secondaryuname' into the single field 'identity', delimitating by the pipe character.