Assuming x000a is required, the following result was found.
Trim in T-SQL and SSIShttps://www.joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html
= Line Feed -- CHAR(13) = Carriage Return And in SSIS: TRIM( LOWER( REPLACE( REPLACE( REPLACE( myString, "\x0009", "" ), "\x000A", "" ), "\x000D", "" ) ) ) -- \x0009 = Tab -- \x000A = Line Feed -- \x000D = Carriage Return -- or split for clarity TRIM(...