long text fields with carriage returns, tabs, and spaces

[bminehart]

Live data model connected to Snowflake. We have some long text columns containing carriage returns and tabs. If we display these values in a table or pivot table in Sisense, the text is missing the carriage returns and tabs. Is it possible to have text displayed with the carriage returns and tabs properly?

[DRay]

Hello @bminehart,

Thank you for reaching out. I see your question hasn't gotten a response yet, so I'm asking internally to try and get you an answer. 

[DRay]

Hi @bminehart,

Are you able to extract that text from Snowflake with the formatting intact using another tool? I'm trying to figure out if this is a Sisense or Snowflake limitation.

[bminehart]

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.

[DRay]

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?

[bminehart]

Yup, please do.

[DRay]

Alright, I have reached out to your account team to get that started. I would love to hear how it gets resolved.

[DRay]

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.

[DRay]

@bminehart, Is this a possible solution for you?