Exporting ASCII text from Filemaker Pro

Thread View: comp.sys.mac.databases

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Tim Myers Fri, 08 Jan 1993 03:20

#585

Author: Tim Myers
Date: Fri, 08 Jan 1993 03:20

25 lines
1586 bytes

I have a question about exporting ascii-only text from FileMaker Pro
2.0 that I hope someone can help me with.

One of the databases I use frequently has information that I also like
to upload to online services as ascii text.  I have been able to develop
a script to locate and export only the text from a particular field, but
the text contains extra ascii characters that foul my upload. This is
text from a scrolling field that can be lengthy, and FMPro adds ascii
characters at each carriage return. I thought that tab-separated text
would be the best export format, but when I try "merge" or some of the
others, I get additional information, field names, quotation marks, etc.

Obviously I could manually copy and past the text from the field into
a word processor.  I can even send an Apple event to open my word 
processor and copy the field text, so all I have to do is paste it
into the word processor.  That saves a little time, but I'd rather just
export the text to a file and upload it later.

Am I missing something easy here?  I'd appreciate any advice.

Tim

-- 
Tim Myers                      
Ohio University             tmyers@oucsace.cs.ohiou.edu

Re: Exporting ASCII text from Filemaker Pro

#601

Author: Nick B Triantos
Date: Sun, 10 Jan 1993 01:15

18 lines
1308 bytes

Tim Myers recently asks about exporting to tab-separated text from FileMaker
Pro.

Actually, Tim, FileMaker Pro seems to export everything as it claims it
will.  The snag that you may be getting caught on, though, is that FileMaker
will export a Vertical Tab (ASCII 11), for any returns within a field.  So,
if you have one field that may have several lines of information which you
have manually added in carriage returns to, you will get these VT
characters.  The standard carriage return is used to signal the
end-of-record marker.

Good luck, and Happy FileMaking!
-Nick

Nick Triantos                     Avoid bus errors... Take the train!

I may work in Claris Technical Support, but not when I'm logged in on
the Internet...

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads