December 30, 200619 yr I see a couple of new script possibilities in scriptmaker but have as yet been unsuccessful in getting any of them to work. I have about 300 records where I want to change the text from Upper to title case. TIA
December 30, 200619 yr Use the Proper() function. To replace the contents of a field in the found set, use Records->Replace Field Contents...Calculated result, where the calc is something like Proper(YourField) Be sure to make a backup of your file before trying a Replace, as there's no Undo.
January 1, 200719 yr Author Many thanks that worked like a charm. Funny that is the first time I have used Replace records with a calc. Usually I use it to populate a field with a value from the first record. This opens up a whole new vista for me.
Create an account or sign in to comment