I would like to check an attribute field to make sure the text is all in lower case and not upper case. If the text is found to have any uppercase text I want to change this all to lower case.
This is for my marketing database and the email attribute. We import files rather than enter data direct so I would like to check the text after import. Is this possible?
Just search on TO_LOWER_CASE in the User Guide. You can either do the verification at import time as described in the Import section of the User Guide or run a process on the imported items any time thereafter.