4 Replies Latest reply on Feb 9, 2010 2:45 PM by shellas

    Separating Fields in a record into multiple records

    shellas

      Title

      Separating Fields in a record into multiple records

      Post

      I have over 37,000 records with the following fields in each record:

       

      description

      upc

      wholesale price 1

      wholesale price 1 qualifier

      wholesale price 1 unit of measure

      wholesale price 2

      wholesale price 2 qualifier

      wholesale price 2 unit of measure

      wholesale price 3

      wholesale price 3 qualifier

      wholesale price 3 unit of measure

       

      An example would be:

       

      description: Candles

       upc: 1254632541

       

      wholesale price 1: 15.00

      wholesale price 1 qualifier: 1

      wholesale price 1 unit of measure: case

       

      wholesale price 2: 12.00

      wholesale price 2 qualifier: 5

      wholesale price 2 unit of measure: case

       

      wholesale price 3: 10.00

      wholesale price 3 qualifier: 10

      wholesale price 3 unit of measure: case

       

       

      I want to separate this record into 3 separate records (since there are 3 prices).   

       

      The first record holding this info: decription, upc, wholesale price 1, wholesale price 1 qualifier, wholesale price 1 unit of measure.  The secrond record holding description, upc, wholesale price 2, wholesale price 2 qualifier, & wholesale price2 unit of measure...

       

      Can this be done automatically in Filemaker 8.5?  Any help would be appreciated.