Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

workbench setvalue

Avatar

Level 1

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.

2 Replies

Avatar

Level 8

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

Avatar

Level 1

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.