How do you remove a carriage return from a string value in Looker?

  • 24 November 2021
  • 0 replies

I am editing a Look for a customer and I am trying to understand how you would remove a carriage return character (‘\r’) from a string in Looker. I do not have access to edit the LookML, so I am hoping for a solution using a custom dimension. Also, I’ve tried using the replace function, but it is escaping the ‘\r’ character as ‘\\r’:


We are trying to do this since one of our customer’s systems cannot properly interpret these characters. Does anyone have a workaround?

Thanks in advance!

This topic has been closed for comments