creating a packing list for shipments
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.
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:
I would like my packing list to show:
labor, shipping, Antenna
Thanks in advance.