Automatically modify existing records

[jch]

Hi all. First time poster, new to FileMaker.

I have a table containing 350 records. One of the fields—let's call it "Bar Code"—contains data that is displayed as either five numbers (e.g. 01234) or ten numbers (e.g. 0123456789).

What I would like to do is automatically insert a string (such as "ABC") before all the 5-number bar codes, excluding the 10-number bar codes in the process. For instance, "01234" becomes "ABC 01234" but "0123456789" is left alone.

How can I apply these changes to existing records? Thanks.

[comment]

One way would be to find the 5-number bar codes first, then replace field contents with a calculation =

"ABC" & BarCode

To find by length, search for exactly 5 consecutive digits ==#####.

Make sure you have a backup before using Replace Field Contents.