Hi Gurus,
I am new to regexp and trying to understand the condition here.
Does this expression replace anything that is not a number (0-9) and some characters .,\,- (associated with amounts) with null ?
I see this expression on some code , basically to clean the garbage, however still trying to understand what it does.
select REGEXP_REPLACE(value , '[^0-9.\-]+', '')) from my_table;
If this expression replaces or lets ignore possible alphanumeric or signs associated with amount, how can we extract the fields that is other than number, +,. and \ ?
Thanks