Results 1 to 1 of 1

Thread: [RESOLVED] How to scan text line for a numeric value

  1. Aug 29th, 2012, 03:25 PM #1
    jmsrickland
    jmsrickland is offline

    Thread Starter
    PowerPoster
    Join Date
    Jan 2008
    Posts
    11,074

    Resolved [RESOLVED] How to scan text line for a numeric value

    I have a text line that has text in it and somewhere in the middle there is going to be a number, like for example:

    "This is a sample of one of the many text lines and this is text line 233 but there are many more lines to follow"

    How to I find the number or at least the 1st digit?


    EDIT:

    Never mind I got it

    Code:
      '
  '
 For n = 1 To Len(TextLine)
   If IsNumeric(Mid(TextLine, n, 1)) Then
     '
     '
    Last edited by jmsrickland; Aug 29th, 2012 at 05:10 PM.


    Anything I post is an example only and is not intended to be the only solution, the total solution nor the final solution to your request nor do I claim that it is. If you find it useful then it is entirely up to you to make whatever changes necessary you feel are adequate for your purposes.
    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