Can I add text to return value of eval/case?

[castle1126]

I'm writing a search that performs a simple eval:

eval changed = case (NOT address="-",address,NOT city="-",city,NOT state="-",state)

One thing I want to do is add some text value to the returned value of the case, based on which boolean worked. For instance, if the address <> "-" I want to return "Address changed to", followed by the value of the field "address", to the new field named "changed".

Is there a way to get the case statement to return that sort of result?

[Ron_Naken]

You can concatenate your strings right in the case statement. Assuming your EVAL expression is correct, you could do it like this to get the address as you wish:

... | eval changed = case(NOT address="-", "Address changed to " + address, NOT city="-", city, NOT state="-", state)

[jrodman]

Sounds like you need to build up more complex logic using if() and so on.

[castle1126]

OK. But not knowing too much on the "if" logic, could you add the text as I am looking for? If so could you give me an example?