Print Text to File

I am using FileMaker Pro to convert a database from one format to another (Dollars and $ense to Quicken). I want to export the DA$ data to FileMaker, process it, and then import it into Quicken. To do this, I need to output a FileMaker report to a text file as opposed to outputting simply the records since I need the formatting. Unfortunately, FileMaker doesn't support this option.

I figure I can use the LaserWriter driver to "Print to a File", but the resulting file has all the PostScript commands in it. What I need is a utility that interprets this file and converts it to it's text equivalent...or an aplication that can do the equivalent, eg MS Word. Then I can use any text editor to manipulate the data into the format I need.

Although my current need is for FileMaker, the same technique could be used for any other application that does not have a "Print to Text" option.

My question is: are you aware of any such application or is there another technique to accomplish the conversion?

Steve Cunningham
ir000178Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

riftyCommented:
Steve:  haven't you answered your own question? If you can generate a postscript file, then you can use Word to read it and convert it to text. Have I missed something here?

Cheers,

Rifty.
0
ir000178Author Commented:
rifty: I may be missing something obvious, but if you open a PostScript file with Word, it reads in the raw data and doesn't interpret it. What you get is all the PostScript commands instead of the output they would generate. For example, use Word to Print to a File the single line "Test File". Then open the resulting PostScript file in Word and you get:

%!PS-Adobe-3.0
%%Title: (Microsoft Word - Document1)
%%Creator: (Microsoft Word: LaserWriter 8 8.4.2)
%%CreationDate: (5:05 AM Thursday, April 24, 1997)
%%For: (S. J. Cunningham)
%%Routing: (mailto:\000ir000178@bigfoot.com)
%%Pages: 1
%%DocumentFonts: Times-Roman
%%DocumentNeededFonts: Times-Roman
....
etc, etc, ad nauseam.

I hope I am being clear.

Steve


0
molivierCommented:
Use FMP's export records command and select the tab-separated-text option, and give it a filename - this will export it to a text-readable file without all the postscript junk. You can then edit it in MS Word - and use the find/replace mechanism in Word to convert tabs selectively to get the formatting you want. If your data has tabs in it, use the export comma separated, or quoted.

0
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

ir000178Author Commented:
moliver writes "Use FMP's export records command and select the tab-separated-text option"

With all due respects, this does *not* give me what I want, as I mentioned in the text of the original question, viz

 "To do this, I need to output a FileMaker report to a text file AS OPPOSED TO OUTPUTTING SIMPLY THE RECORDS since I need the formatting."

If, for example, a FileMaker Report contains Field Labels, exporting to a tab seperated text file will only export the fields, not the labels. I need both and any other textual information that is part of the report.

In addition, even if this would work, it would only solve the problem for FileMaker (which would nevertheless be welcome) and not the general problem as posed.
0
molivierCommented:
Then the only answer is PostScript. Applications like FMP don't have this concept except for via printing. You could use external tools to process the postscript, e.g., postscript -> PDF -> HTML and maybe then pass it thru a utility to strip tags from HTML. Then you'd have the labels and fields w/o the PS.

0
ir000178Author Commented:
While I appreciate moliver's thoughtful response, I beleive it should be regarded as a comment and not as the answer so that the question will remain open.

One thing I plan to try, for example, is using the PowerPrint driver from GDT Softworks. Since it outputs to Daisy Wheel printers and to Dot Matrix printers in draft mode and spools the output, it must generate an intermediate text file someplace.

I hope some of the experts here can come up with something better.
0
helpmepleaseCommented:
trying to print then process the file seems like the long way around the problem. Here's the solution:
create a new calculation field in Filemaker eg:

First Name & "  " & Last Name & "," & Company & "¶"
make sure the result of the calculation is text

This way you preformat the given text the way you want it in Filemaker. Notice how within the quotes you can add punctuation and spaces as required and all items are seperated by the &. I also like to use a return on the end to help in formatting if your going to use a tab in the field but it's not necessary if your not using any tabs to seperate data.

Next export as tab seperated text just the new calculation field you created.

The only formatting you have to do now in a word processer is a find change. Just find all tabs and replace with returns. Now this is where the return in the calculation comes in handy, if there are other tabs in each line just find return+tab and replace with a return.

Oh, by the way the result of the calculation should be text even if some of the fields used in the calculation are numbers.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Apple Software

From novice to tech pro — start learning today.