Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Find number in a string
#4
Solved: 10 Years, 9 Months, 4 Weeks ago
Thanks. Looking the string, it has several numbers, but the number i need is next to the word "código" (code in English), it can be done with regular expressions? Or I have to add some lines to the code below.

I will think the solution, if it works i will post it.
Solved

Code:
l_String=Datatable("o_DescRechazo", dtLocalSheet)
l_num=""
    For j=1 to len(l_String)
       y=mid(l_String,j,6)
       If ( y="Código") Then
         For i=j to len(l_String)
           y=mid(l_String,i,1)
           If ( isnumeric(y)=True) Then
              l_num= l_num & y
            End If
          Next
          j=len(l_string)                        
       End If
     Next
  
    msgbox l_num

Thanks to all
Reply


Messages In This Thread
Find number in a string - by pjeigenn - 07-17-2010, 12:19 AM
RE: Find number in a string - by MVChowdary - 07-19-2010, 10:40 AM
RE: Find number in a string - by Arun Prakash - 07-19-2010, 12:32 PM
RE: Find number in a string - by pjeigenn - 07-21-2010, 12:07 AM
RE: Find number in a string - by basanth27 - 07-22-2010, 08:39 AM
RE: Find number in a string - by pjeigenn - 07-26-2010, 09:16 PM
RE: Find number in a string - by supputuri - 07-26-2010, 10:04 PM
RE: Find number in a string - by ngocvo3103 - 12-02-2010, 12:40 PM
RE: Find number in a string - by cdesserich - 12-02-2010, 01:32 PM
RE: Find number in a string - by bfakruddin - 12-03-2010, 04:26 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  VB Script:number of times a character appears in a string with position Jyobtech 1 11,797 08-07-2013, 01:03 PM
Last Post: anil2u
  Find capital letter in a string Arul 2 8,385 12-27-2011, 11:11 PM
Last Post: Arul
  How to have a variable that has a string comma string .. shareq1310 5 4,810 11-09-2011, 03:33 PM
Last Post: parminderdhiman84
  How to count a repeated number in number in particular range gollsrin 1 3,441 04-28-2011, 11:41 AM
Last Post: Saket
  Removing commas from a string and changing it to number indranilgoswamimcb 3 8,404 12-31-2010, 10:40 AM
Last Post: rajeshwar

Forum Jump:


Users browsing this thread: 1 Guest(s)