workbench setvalue

[Dale_Mendenhall]

setvalue step in workbench process:

I am formatting the body of an email. I have a US mailing address.

Name

AddressLine1

AddressLine2

City State Zip

In the setvalue, how can I move City State Zip up one line to AddressLine2 if AddressLine 2 is blank?

Thanks.

[TundraSteve]

Haven't tried it yet but I suspect it would something like this concat(/process_data/@checkit,string-length(/process_data/@checkit) > 0)

[Dale_Mendenhall]

I tried concat(/process_data/@checkit,string-length(/process_data/@checkit) > 0).

What I ended up with was "addressTRUE" for the value in the address2 field.

I might not be doing what you intended.

I see how to test the string length and get a boolean value, but I need to move the city, state and zip into the address2 field if address2 is null.

Thanks.