April 9, 200817 yr Newbies 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.
April 9, 200817 yr 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.
April 9, 200817 yr Author Newbies 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.
April 9, 200817 yr 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"...
April 9, 200817 yr Author Newbies 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.
Create an account or sign in to comment