Need help with REGEXP_REPLACE
        Posted  
        
            by 
                Randy
            
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Randy
        
        
        
        Published on 2011-01-05T22:30:32Z
        Indexed on 
            2011/01/05
            23:54 UTC
        
        
        Read the original article
        Hit count: 310
        
hey regex guru's
I have a data column that contains a substring similar to this:
'This is a string with ID=123 contained inside'
i need to replace the ID=123 with another fixed string say ID=1
i have a working REPLACE call that swaps out the values correctly, but this only works on a known original id number. I can extend to make it work when the number of digits are known by using some substr magic, however, the id number may have an arbitrary number of digits, so i'm thinking regex.
any help with the regex magix to grab the entire ID=999 substring no matter how many digits would be very helpful.
thanks
© Stack Overflow or respective owner