delete text from one field in every record?

[FritzOK]

I accidentally wrote a script that added text to the end of a field of every record that I really wanted inserted in front of the fields existing text.

How do I undo this?

And do it properly?

[BobWeaver]

To undo it:

Set Field [theFieldToBeFixed, Substitute(theFieldToBeFixed,"texttoberemoved","")]

to add text to the beginning of the field:

Set Field[theFieldToBeFixed, "New Text" & theFieldToBeFixed]

***** NOTE: ALWAYS DO A BACKUP BEFORE YOU DO MASS CHANGES *****

[FritzOK]

Bob,

Thanks. It took some doing (my brain), but I made them work.

In a related problem, I need to add a comma after text in a particular field of every record. I

[FritzOK]

you said:

In a related problem, I need to add a comma after text in a particular field of every record. I