Set Field ( my field, new contents )?
Thanks Beverly- it works a treat!
(my previous effort with Replace wiped the data from the field in every record - fortunatley I had a back up!!)
riggers wrote, in part: Replace wiped the data from the field in every record…!
That's a reminder of why I disable/remove that Replace option in the pulldown menu for users via a Custom Menu. If it's left available, someone will try it to see what it does, and…
Set Field is one of the most commonly used script steps. I hardly ever use the other steps like INSERT, PASTE etc. Set field is my method of choice because you can specify the the exact field you want to set and you can set it to literal text , numbers, or calculations.
An additional benefit is that the field doesn't have to actually appear on the current layout unlike PASTE for instance.
You can even set a field to itself. For instance if my field currently held the value of "Blue" I could make it "Red, White and Blue" with this command:
Set Field ( YourField ; "Red, White, and " & YourField )
You should also be aware that Set Field works in Find mode too. For instance If I wanted to find the word "White" I could write a script like this:
Enter Find Mode
Set Field ( YourField ; "White" )