Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6538 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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.

Posted

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.

This topic is 6538 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.