2 Replies Latest reply on Aug 9, 2011 1:14 PM by NicoleHartman1367

    Creating a formatted text file that includes records of data

    NicoleHartman1367

      Title

      Creating a formatted text file that includes records of data

      Post

      Hi, 

      I have the need to create a text file from my filemaker database that looks like the following:

      ---

      Distributor Number: D1

      Effective-date: 7/15/2011

      Currency: USD

       

      Prices:

      - {sku: xxx-10-ABC, price: 111.22}

      - {sku: xxx-11-ABC, price: 222.22}

      - {sku: xxx-12-ABC, price: 333.22}

      - {sku: xxx-13-ABC, price: 444.22}


      The top two pieces of information are constant for a given block of records and then the prices are individual per a record that is related by the top pieces of information. Each of the bolded items are formatting or titles and the unbolded are pieces of data that have been stored. 

      This block then needs to repeat in the text file for 30 different distributors. 

      Is it possible to write a script that could accomplish this?

       

      Thanks,

      Nicole