Results 1 to 3 of 3

Thread: Extracting numerical content from alpha/numerical string****Resolved

Threaded View

  1. Jul 24th, 2003, 04:03 AM #1
    JFK
    JFK is offline

    Thread Starter
    Lively Member
    Join Date
    Oct 2002
    Posts
    112

    Extracting numerical content from alpha/numerical string****Resolved

    I need to extract the numerical content of an alpha numerical string and find the highest value.

    The strings are either 6 or 7 characters in length with the first five characters always being alpha e.g(elect1 or elect15).

    I've tried using Val(fieldname) but this doesn't work it returns a zero everytime even though the numeric content of the string is between 1 and 99.

    I've also tried to use the CdBl function but this returns an error all the time.

    Is there an easy way to do this?

    thanks

    JFK
    Last edited by JFK; Jul 24th, 2003 at 06:11 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width