Exporting to a specific text format

[Vempyre]

Greetings,

I'm trying to export data from FMP5 for importing into an accounting

software via a simple text file(Simple Accounting 7.0 and Fortune1000), and

I have some problems getting the data exported exactly the way I want it

into the text file (into a format the accounting software accepts).

here's the format it must end into (Simple Accounting 7.0) :

10-14-93,"Drafting Service for Ronald B","338"

108,150.00

402,-150.00

etc...

date,"comment","source"

account,amount

account,amount

etc...

where amount must be of form 0.00, date MM-DD-YY

first line for header, others lines for transaction details, one for each.

as of now, the best I could get was (exporting a calculated text field which

had all the data) :

"10-11-2000,""comment"",""source"" 2430,16,1 2510,18,4575 4540,264,56"

the are ascii 11, vertical tab (I need a line change, not a vertical tab)

I need to get rid of the first and last "

I need the " inside to be single quotes, not double

when I display it in FMP5, it looks exactly as I want it, but when exporting

it shows as above

I was thinking of maybe exporting into many files (one for each line) then

merge them into noe using an external dos command?

Any input would be welcome, thank you.

[Kurt Knippel]

quote:

---

Originally posted by Vempyre:

Greetings,

I'm trying to export data from FMP5 for importing into an accounting

software via a simple text file(Simple Accounting 7.0 and Fortune1000), and

I have some problems getting the data exported exactly the way I want it

into the text file (into a format the accounting software accepts).

here's the format it must end into (Simple Accounting 7.0) :

10-14-93,"Drafting Service for Ronald B","338"

108,150.00

402,-150.00

etc...

date,"comment","source"

account,amount

account,amount

etc...

---

What part of the above are seperate records?

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=