I am using snowflake and I am parsing an email message for a certain field. I found that only 2 records have a whitespace in the front. I have used trim, tried various types of char replace (9,10,13,14,11, some more but i forgot however it is still presistent.

The reason why I think this might be a special Character is if I do a like ‘% DYING GASP%’ it won’t return. But ‘%DYING GASP%’ will.

I have tried using this article from Snowflake’s community to find whether or not it has a special character, but the odd row isn’t appearing here.

This is the current code, the first 3 replace; 9,10,13 is necessary the other 2 is just me trying out different character types.

REPLACE( REPLACE( REPLACE( REPLACE( REPLACE(REGEXP_SUBSTR(UPPER(c.description), 'ROOTCAUSE :s*([^:n]+)', 1, 1, 'e', 1) , CHAR(13), '') , CHAR(10), '') , char(9), '') , char(14), '') , char(11), '')

Part of the original message:
“…..
Rootcause :    DYING GASP
Action :    No Action 
…..”

I also will attach the image of the cell in question.Example

Any help is greatly appreciated. Thank you!

Stated in the text above.