Re: Text File Output

In article
<dc3556d5-3dc4-4d70-9510-4cd551c9b22e@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
d-42 <db.porsche@xxxxxxxxx> wrote:

On Mar 21, 4:53 pm, Helpful Harry <helpful_ha...@xxxxxxxxxxxxxxxx>
wrote:
In article
<c632a7b6-d19e-4409-bde6-8e3cd62c9...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,

Since you already have to post-process the file to replace the commas
with semi-colons, you may as well also add in some Return characters
too.

Export these fields instead of the original ones. Then once you've got
the text file you can use a word processor to find / replace the ","
with ";" and then find / replace "*-*" with a Return. You may need to
copy a Return from another file by selecting from just after the last
character of one line to the just before first character of the next
line. In Microsoft Word you can simply type "^p" without the quotes for
a Return character. Other word processors may have a similar tag, some
use "/p" or "\p".

I'd just create a one field utility table and generate the exact data
I want in each row and put it in the one field.

e.g. The loop through the jobdetails records to export, and generate n
records in the utility file setting the fields exactly as below, the
way you want it, with the semi-colons, etc..

"123";"1";"C01"
"123";"1";"C02"
"123";"2";"D17"
...
and then create n more records for the 2nd job, etc.

And then at the end, just export the utility table records as a TAB
file, which because there is only one field will output the contents
of each row 'as is', and give you the exact output format you need,
without fiddling around with a word processor after the fact.

Really, what is the point of scripting a solution and then manually
adjusting the results by hand when you can get exactly what you want
right out of filemaker?

This is another way, but it's a lot more work to set-up. It would
really depend on how often the task nneds to be done and how many
records there are to process. There's no point in over-complicating a
process just for the sake of it.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
.

Relevant Pages

  • Re: Text File Output
    ... character of one line to the just before first character of the next ... way you want it, with the semi-colons, etc.. ... of each row 'as is', and give you the exact output format you need, ... without fiddling around with a word processor after the fact. ...
    (comp.databases.filemaker)
  • Re: Text File Output
    ... database all the information for one job is stored in one record so it ... Since you already have to post-process the file to replace the commas ... the text file you can use a word processor to find / replace the "," ... character of one line to the just before first character of the next ...
    (comp.databases.filemaker)