How can I change a field to Upper/Lower Case in my rating matrix?

Follow

Permanently deleted user

02 April 2012 16:33

Is there a command within the matrix to convert the answer to a question into Upper or Lower case. I have a alpha/Numeric field (Driving Licence No), that I want to compare to a list but the potential variable ways of answering is immense. Therefore converting to either Upper or Lower makes the process far more controllable.

.

4

• 

  Mark Williams 02 April 2012 16:49

  Brian,

   

  Try this:

  [QuestionName_Value].ToUpper().Replace(' ', '')

  This will convert lower case alphanumeric characters to upper case and remove spaces. Just remove the .Replace(' ', '') if you just want to do the ToUpper

  Cheers.

  Mark

  0

  Comment actions Permalink
• 

  Permanently deleted user 04 April 2012 14:30

  Mark

  Once again, i am in your debt (just don't send a bill)

  cheers

  Brian

  0

  Comment actions Permalink
• 

  Mark Williams 04 April 2012 14:54

  I'll save em up Brian :)

  0

  Comment actions Permalink

Please sign in to leave a comment.