long text fields with carriage returns, tabs, and spaces

We can use regex function to convert the line breaks \n to <br> as part of data transformation strategy. In the below example I am using this function as custom import query which ideally should be done directly on snowflake as part of their ETL process or views. By using this function I was able to preview the result directly in the pivot.

PS. This function might need some changes depending on the raw data as it may not be dynamic enough to pass all edge cases.