Two absolutely simple questions

[rex]

I have many fields with copy and paste commands in the scripts. How can I cancel the contents of the clipboard after one paste to avoid multiple pasting of clipboard into other fields?

Making a macro to put an English pound sign instead of a $ sign into a field is simple?

[LiveOak]

I would get rid of the copy and pastes and use Set Field(). What are you doing that you need to do this? -bd

[rex]

Hi bd, thanks for the reply.

The 'set field' is OK but it over-writes the content in the field it is transferring data to. I need to retain the data and add to it as it is an archive field. (hence the copy & paste , which works well) My problem is not with Filemaker, but with windows retaining a paste in memory after it has been pasted. The problem only occurs when an empty field is selected and when the copy & paste command is in the script (there are 12 of these fields)and it then pastes the previous paste that is still held in windows memory. I have overcome it now by re-scriping the copy & paste files (which do the job OK) and adding another copy & paste command in the script from a dummy field with only (.) in it. It then only pastes the dot, and I can cope with this..Rex

[Ocean West]

If YOUR_FIELD contains: "The lazy dog"

and you wanted to append to it you can use Set Field

Set Field: YOUR_FIELD, YOUR_FIELD&" jumped over the brown fox."

or

Set Field: YOUR_FIELD, YOUR_FIELD&SOME_OTHER_FIELD

[BobWeaver]

Regarding the English pound sign, are you trying to search for $ and replace with

[rex]

Bob, All I looking for is an easy way to insert a 'pound' sign in a field, not replace it. This crops up occasionally when entering old archive records, and as various people input our records and they may not all be regular computer users, an easy way to key it is sought for them. We,in Australia, used pounds, shillings and pence until about 35 years ago.

Regarding the copy & paste query, the only problem is when a paste command in a script is encountered and the last field it copies & pastes from is empty. It then pastes the previous paste still held by windows, resulting in multiple pastes of the same data. But no big deal, the (.) field does the job. I will try the 'set field&' solution. Rex