Tab Character for copying.

[JoelK]

I am trying to copy some numbers in Filemaker from a single text field and have it paste horizontally in Excell. IE: Each number goes into a separate cell. I cannot locate a tab character to insert between the numbers. Also, is it possible to copy something to the clipboard without first placing it into a field? Thanks in advance.

[comment]

I cannot locate a tab character to insert between the numbers.

Try Option-Tab. However, if these numbers are supposed to go into separate cells in Excel - shouldn't they also be in separate fields in Filemaker?

Also, is it possible to copy something to the clipboard without first placing it into a field?

Yes, no, maybe - depends on what is "something". On a Mac at least, you can use AppleScript to set the clipboard to a calculated result.

[JoelK]

I am running queries that put numbers in several different global number fields. My thought was to write a script that puts them into a text field where they could be copied and pasted into excell. If I make a field for each outcome of the query then I would have +64 extra fields in my database. Do you know how to put an Option-tab into a calculation part of the Set Field? Oh, and the something I wanted to copy to the clipboard was just a text field.

Thank You.

[comment]

Do you know how to put an Option-tab into a calculation part of the Set Field?

Type it into a field. Copy it. Paste it into a calculation (in between quotes).

Oh, and the something I wanted to copy to the clipboard was just a text field.

: But you asked if it's possible "to copy something to the clipboard without first placing it into a field"...

[JoelK]

Sorry, there were two thoughts in my head. One was to copy information from a text field and the other was to copy information by way of a calculation to the clipboard. Thank you for your help. The way you suggested works great. Thank you very much for your time and trouble.