Forum Discussion
8 Replies
Hi DRay -- we've queried Snowflake directly to see what the data look like, and Snowflake is retaining the desired carriage returns/tabs/spaces. It seems to be a problem at the presentation/dashboard layer.
- DRayAdmin
Thank you, that's interesting. I'm not able to find any resources that discuss this, so if you like I can work on finding a technical resource to work with you directly on this. Would you like me to get the ball rolling on that?
- DRayAdmin
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.