Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
OTBI formula to remove all the special characters from a column value
Summary
OTBI formula to remove all the special characters from a column valueContent
Hi,
I am trying to remove all the special characters from a column value in OTBI analysis. For this, I am using nested REPLACE command which is working for majority of the special characters. However, there is one special character '\' (Backslash) for which it does not work and this particular special character does not get stripped off from the column value. I used different variations of the syntax like:
1) REPLACE(col_val ,'\','') - syntax error
2)REPLACE (col_val,'\\','') - no syntax error, but does not remove \ either
Tagged:
0