FileMaker Pro 10 question

I have a large found set of records. Each of these records has an “URL” field. In each of these records the URL in the URL field ends with “open/”. I need to get rid of the “open/” while retaining the rest of the text in the field, without having to manually delete it from each individual record.

Is there a way to mass delete that specific text from the field across all of the records in the set?


Replace field Contents

click in YourField;

replace with calculation results:

Left (YourField, Length (YourField) - 5) ]

Excellent. Thank you! You just saved me a couple of weeks of tedium!