In monarch is there a way to convert all the data that is in upper case to title case?
Example: MARY JONES 123 MAIN STREET
to Mary Jones 123 Main Street
I need to do this as an automatic process. I know you can do it in excel with vb code.
The output of the file is in excel.
Try the proper() function
Do you mean in Monarch? Can you show ax example?
Yes, Monarch has a Proper() function.
Your calculated field will be:
Then hide MyField.
Thank you for the clarification, I will try it out tomorrow.:p
Thank you it worked great!:)
Retrieving data ...