dbTalk Databases Forums  

copying data

comp.databases.filemaker comp.databases.filemaker


Discuss copying data in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Frank
 
Posts: n/a

Default copying data - 12-10-2009 , 06:25 AM






each record in my data base contains numerous number fields and one
text field which is the name for that record. How do I copy only the
list of names to paste in another text file?

Reply With Quote
  #2  
Old   
Lynn Allen
 
Posts: n/a

Default Re: copying data - 12-10-2009 , 12:11 PM






On 2009-12-10 04:25:31 -0800, Frank <gno52 (AT) windstream (DOT) net> said:

Quote:
each record in my data base contains numerous number fields and one
text field which is the name for that record. How do I copy only the
list of names to paste in another text file?
There is a script command to "Copy All Records". If you're on a layout
containing only the field(s) you want, it will copy all found records
into your buffer. You can then paste them into another file.

Or you can export records in a text format, which will give you a list
of your found records.
--
Lynn Allen
--
www.semiotics.com
Member FBA
FM 10 Certified Developer

Reply With Quote
  #3  
Old   
Christoph Kaufmann
 
Posts: n/a

Default Re: copying data - 12-10-2009 , 02:12 PM



Frank <gno52 (AT) windstream (DOT) net> wrote:

Quote:
each record in my data base contains numerous number fields and one
text field which is the name for that record. How do I copy only the
list of names to paste in another text file?
The quickest way is to find and sort the records and then export the
text field to a tab delimited file.

In FMP 9 and later, you can use the list function on the text field if
you're viewing the table via a relation that get's you all the records
you need.

In any version, you can write a script that loops through the records
and concatenates the values of the text field in a global field.
--
http://clk.ch

Reply With Quote
  #4  
Old   
Your Name
 
Posts: n/a

Default Re: copying data - 12-10-2009 , 02:34 PM



"Christoph Kaufmann" <clk (AT) tele2 (DOT) ch> wrote

Quote:
Frank <gno52 (AT) windstream (DOT) net> wrote:

each record in my data base contains numerous number fields and one
text field which is the name for that record. How do I copy only the
list of names to paste in another text file?

The quickest way is to find and sort the records and then export the
text field to a tab delimited file.
Yep. Exporting the Field would be the easiest way - since you're only
exporting one field, you could use any of the text file export formats.



Quote:
In FMP 9 and later, you can use the list function on the text field if
you're viewing the table via a relation that get's you all the records
you need.
In older versions you can create a workaround to achieve the same result
using a Value List to retrieve the Text Field data ... although duplicate
Text Field data will only appear once in the list.


Helpfull Harry )

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.