Hi all,

I just started with Filemaker and have been able to find answers to most of my questions, but I can't seem to find one that quite fits this one.

I'm creating a packing list for order shipments -- I have several fields that may or may not contain data. I want to put these fields on the packing list as just a line of data with a "," in between each piece of data. I can list all the fields on the packing list but if there are fields that are empty, then I have a bunch of spaces and carriage returns. I want to remove any empty spaces and put the "," in betwen each field that does have data - hope that makes sense.

example:

field1 = " labor "

field2 = empty

field3 = " shipping "

field4 = " Antenna "

field5 = empty

so forth and so on......I have 22 fields, so if there is only 2 with data, I could have a bunch of spaces on this list.

I am able to make it show:

labor shippingAntenna

I would like my packing list to show:

labor, shipping, Antenna

Thanks in advance.

Kevin

create a text calculation field for your packing list:

If(not IsEmpty(field1);field1 & ", ";"") & If(not IsEmpty(field2);field2 & ", ";"") & If(not IsEmpty(field3);field3 & ", ";"")

...etc...

IsEmpty(lastfield);lastfield;"")

Hi Kevin, another option would be this calculation:

Substitute ( List ( field1 ; field2 ; field3 ; field4 ; field5 ) ; ¶ ; ", " )

I have 22 fields, so if there is only 2 with data, I could have a bunch of spaces on this list.

That doesn't look like a good arrangement to have. If those 22 fields indicate ordered items, you should replace them with a related table, where each item will be a record.