function to ignore case of the value

Follow

Rahul Dhond

• December 16, 2015 19:08

Hello,
Is there any function which I can use in my workbook that will ignore the case; meaning it will consider 'rahul' and 'Rahul' the same?
Also, how does CORRECT_SPELLING function work exactly? No online documentation is available.
thanks & regards,
Rahul

0

• 

  Sujay Mahajan

  • December 16, 2015 19:18

  Hi Rahul,
  CONTAINS_IC performs an operation that is not case sensitive. It will compare/match strings and return a boolean. Documentation link below -

  https://documentation.datameer.com/documentation/display/DAS50/CONTAINS_IC

  0

  Comment actions Permalink
• 

  Frances Angulo

  • December 16, 2015 19:20

  At the source data, you could also apply a LOWER or UPPER to normalize- that might simplify your work later in the pipeline.

  0

  Comment actions Permalink
• 

  Rahul Dhond

  • December 16, 2015 19:24

  Thanks Sujay and Frances.
  Yes, I could do it at the source data; just wanted to check if there was a way once it was in the workbook.
  I used function PROPER and that solved my problem..
  thanks,
  Rahul

  0

  Comment actions Permalink
• 

  Frances Angulo

  • December 16, 2015 19:24

  FYI I have escalated to docs that this function is not documented- thanks for your feedback!

  0

  Comment actions Permalink

Please sign in to leave a comment.