Re: strip numeric characters from a text field

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

An inelegant (i.e., 'brute force') might be to use VBA code to step through
the string, one character at a time, looking for digits and modifying the
string to leave each one out.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Prashant Rao" <PrashantRao@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B8E5911A-270D-48B1-A29B-D17CD44BC673@xxxxxxxxxxxxxxxx
How can I build a update query that removes all numeric characters in a
field? I have a field that has data such as "3478 PRG Management", "Asc
Chiti Baa", "54 Oracle DBA"... they have from 0 to 6 leading numeric
characters, using the Left function with " " as the separator will not
work
since some of the fields do not have numeric chars at all. Please help.
Thanks

PR


.

Relevant Pages

  • Re: inputting the ephemerides (SOLUTION!)
    ... Defining the rules for field parsing has to match all the ... these are placed in the character string CWK). ... string stops the parsing and GOs to statement 7. ... Here the string CWK of sign, digits and a decimal point if present are ...
    (comp.lang.fortran)
  • Re: user defined function that converts string to float
    ... > I need user defined function that converts string to float in c. ... initial, possibly empty, sequence of white-space characters (as ... point character, then an optional exponent part as defined in ... then a nonempty sequence of hexadecimal digits ...
    (comp.lang.c)
  • Re: inputting the ephemerides (SOLUTION!)
    ... Defining the rules for field parsing has to match all the ... these are placed in the character string CWK). ... string stops the parsing and GOs to statement 7. ... Here the string CWK of sign, digits and a decimal point if present are ...
    (comp.lang.fortran)
  • Re: test to confirm non-numeric characters
    ... In other words, you are looking for a test to see if your 10 character number string is made up of digits only, right? ... Function IsDigitsOnly(Value As String) As Boolean ... ' At least one character in TenCharString is not a digit ...
    (microsoft.public.excel.programming)
  • Re: Newbie - itoa implementation
    ... Now we need to convert from number of binary digits to number of decimal digits. ... Since we need space for the null character to terminate the string, ...
    (comp.lang.c)