Welcome To Support Community

Pipeline Pilot

Advanced Search
Ask Search:
Sumeet SalaniwalSumeet Salaniwal 

how to enforce checking for text case when using rlike

How do I enforce text case (uppercase or lower case) to be checked when using rlike.
For example, I have a column called Species in delimited text file that has values as human, HUMAN, Human. How do i sperate them out using a custom filter with rlike. Using Species rlike '^h' matches all the records. 
NamadevNamadev (BIOVIA) 
Hi Sumeet,
   You could use 'CASE' with 'RLIKE' to be case sensitive.
For eg: Species CASE RLIKE '^h' will pass human but not HUMAN or Human.

Best Regards,
Baskaran