AnsweredAssumed Answered

Separating Fields in a record into multiple records

Question asked by shellas on Feb 9, 2010
Latest reply on Feb 9, 2010 by 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.

 

Outcomes