MySQL Forums
Forum List  »  Newbie

Regexp, replace ??? what do I need to use
Posted by: Sandra Rascheli
Date: January 30, 2007 10:37AM

Hello everybody, I am new to regular expressions and I need to know if they can help in solving this problem, I have a field in a table called "identification" which is a text field that includes dots (.), commas (,), hyphens (-) and letters, plus numeric characters. What I want to do is to extract ONLY the numeric characters from the field. Example of the field identification:
V-1.234.567, I would like as a result to obtain just 1234567. Any ideas on how to do this??? Help will be greatly appreciated.



Edited 1 time(s). Last edit at 01/30/2007 12:38PM by Sandra Rascheli.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.