Removing null values in script

Followers

August 29, 200817 yr

Newbies

I have a list of 30 fields that is generated from a database. However, there are not always 30 fields, usually around 15. When I print it for a label, I only want the fields in use to print, not all 30. How do I do this with the script manager? Thanks.

August 29, 200817 yr

See if this doesn't help.

Link

BTW, this is a Layout Feature, not a ScriptMaker.

HTH

Lee

Edited August 29, 200817 yr by Guest

August 29, 200817 yr

If you want a more custom approach you could create Calculation field to assemble the list for you. And display that on the label.

Example:

Field1 = John Doe

Field2 = CEO

Field3 =

Field4 = CyberNet


If (IsEmpty (Field1); "" ; Field1) &

If (IsEmpty (Field1); "" ; ¶ ) &

If (IsEmpty (Field2); "" ; Field2) &

If (IsEmpty (Field2); "" ; ¶ ) &

If (IsEmpty (Field2); "" ; Field3) &

If (IsEmpty (Field3); "" ; ¶ ) &

If (IsEmpty (Field4); "" ; Field4

Result:

John Doe

CEO

Cybernet

I use sometimes when I need to be able to control what lines data appears on...like if you wanted to combine lines of data.

You could also achieve a similar result using a custom function or like Lee said, depending on exactly what you are doing.