cancel
Showing results for 
Search instead for 
Did you mean: 

long text fields with carriage returns, tabs, and spaces

bminehart
10 - ETL
10 - ETL

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?

6 REPLIES 6

DRay
Community Team Leader
Community Team Leader

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. 

David Raynor (DRay)

DRay
Community Team Leader
Community Team Leader

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.

David Raynor (DRay)

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
Community Team Leader
Community Team Leader

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?

David Raynor (DRay)

Yup, please do.

DRay
Community Team Leader
Community Team Leader

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

David Raynor (DRay)