johnlyons Posted February 18, 2006 Posted February 18, 2006 I have entered all my data in lower case and now would like to chane to upper case in all layouts. I can do this manually but when I export the data even though in all alyouts it is now uppercase it still exports as lower case.
Genx Posted February 18, 2006 Posted February 18, 2006 how many fields do you have? assuming you have a few you could just loop through your records using a step that converts the field to uppercase i.e. setfield[table::field; uppercase(table::field)] ... or you could specify seperate calculation fields that would equal uppercase(table::field)... other than that, i cant think of anything... ~genx
Lee Smith Posted February 19, 2006 Posted February 19, 2006 Beginning with v7, there are two functions called, TextStyleAdd and TextStyleRemove, and depending upon what you need to do, will determine a lot of how you will use them. Changing lower to upper, isn't all that hard, you can use a second calculation field for each field involve, your can use a script and change the fields either one record at a time, or a found set of records using a Replace through the menu, or a Loop script. You can also use the Auto Enter Function when importing, creating a new record or modifying an existing record. You didn't mention the number of fields involved and records. So I'll just suggest that you use a loop scrip and the set field, with a calculation of TextStyleAdd (YourField; uppercase). BTW, there is an Online Help that can explain this a little better, but if you need more help, let us know. HTH Lee
Recommended Posts
This topic is 6871 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 accountSign in
Already have an account? Sign in here.
Sign In Now