is there a quick way to remove non numeric chars

From: chris (someone_at_here.com)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 23:54:46 +0800

is there a quick and easy way to check a string for non numeric characters ?

i have thought of making a routine to check each character to confirm it is
0 - 9 but was wondering if there was a quicker way???

Relevant Pages

  • Re: Need some help with a text manipulation macro (longish)
    ... removed all non numeric characters in the string, ... If you are left with a 16 digit field you can format it by putting ... >entry phase no one has followed the guide lines and now I am ...
    (microsoft.public.office.developer.vba)
  • Re: Help with MID Function?
    ... just use the last formula I posted back in your first thread on this problem; ... Change all the A1 references to whatever cell you have your text in. ... I'm trying to capture / extract specific data within a string of text ... I need to capture a string of numeric characters plus only ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Concatenating and copying columns data
    ... I am a newbee to Oracle SQL programming. ... Column B will always contain numeric characters. ... ASCII and leave the numeric characters as it is. ... and how to convert it to a string and to concatenate ...
    (comp.databases.oracle.misc)
  • Help with MID Function?
    ... I'm trying to capture / extract specific data within a string of text ... I need to capture a string of numeric characters plus only ... So my cells ...
    (microsoft.public.excel.worksheet.functions)
  • Re: String Generation using Mask Parsing
    ... to get some hands-on practise! ... string generator, ... followed by a sequence of 10 numeric characters. ... ten alternating alphanumeric/ numeric characters. ...
    (comp.lang.c)