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

[runningtrumpetm]

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!