on 12-07-2009 7:44 PM
I am unable to get the upper expression function to work. Is this a 'bug' in the software?
Running MDM version 7.1 SP03
UPPER("Short Description") did not work - still receiving the same error.
Short Description is the name of the free-form text field. The actual value of the field will change per record (e.g., fire blanket, finger cots). We want them to be stored in upper case (e.g., FIRE BLANKET, FINGER COTS).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for clarifying on this.
Please ignore usage of quotes.
We can achieve this by 2ways:
1.Set Assignment in Dat amanager > UPPER(Short Description). Select 'Short description' from Fields menu in expressions window.Set Assigned field = Short Description .
Execute assignment on main table record to transform text into uppercase.
2.If you are creating records through import using import manager - During Import > Set value conversion > Change case - UPPER CASE.
Regards,
Vinay M.S
UPPER works fine with MDM 7.1.3.XX; I too agree with the point " Do not type the field name, but select it from the window. Otherwise the field won't be recognized."
Stand expression function should be in color BLUE
Fields and attributes should be in color PINK
and any custom values should be in color BLACK
thanks,
Alexander
Both assignment and change case in Import Manager worked perfectly! Thank you for your assistnace - it was greatly appreciated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
UPPER(Short Description) is the exact expression I am using. I want to make sure the short description, which is a free-form text field, is upper case, thought this expression would do that. But it doesn't seem to be working. I receive the following error when I execute the validation.
One or more records cannot be savbed because of tye following validation errors:
*Upper [Upper]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rein,
Upper expression should work in MDM7.1 also. Can you please mention the expression you are trying to execute ?
Normally syntax would be : UPPER("hi") will return "HI" .
Regards,
Vinay M.S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.