Hello,
I am tryting to replace multiple strings with NULL. while doing this exercise I am facing challange like when I am trying to replace specific string the other non-matching strings are also getting replaced. can some one please help me how to achieve this. I have already reviewed many threads before posting this question but I am still not able to acheive this.
for example my string containts XXACB. or GL. or AP. or AR. etc I need to replace them with NULL.
With my current REGEXP_REPLACE( text, 'XXACB.|GL. |AP.|AR., '') this is not working and its replacing in other places also. could some one please help me with this?