AnsweredAssumed Answered

Creating a formatted text file that includes records of data

Question asked by NicoleHartman1367 on Aug 9, 2011
Latest reply on Aug 9, 2011 by 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

 

Outcomes