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.
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.
