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’:
replace(tbl_expensereportlineitem.businesspurpose,”\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!
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 |