3 Replies Latest reply on Feb 10, 2010 6:15 PM by Marx

    creating a packing list for shipments

    krberb

      Title

      creating a packing list for shipments

      Post

      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