Just loop through what my code returns and add it to a variable until you hit IsNumeric(characterYouAreOn). Then stop the looping and take what's left for the right side. The left side will be in the variable. Let me know if you want me to actually do it. There are tons of examples of looping through words, character by character.
--- e_throckmorton <[EMAIL PROTECTED]> wrote: > I thought I could just pull the data with a regex > and run some page > code to get what I needed. The number letter combo > will not always > be the same, but It will be no longer than (4) > digits for the number. > It will be things like 65L or 1722P or 827R_H, The > place it comes > from will always begin with "For:" and the digits > needing retrieved > will always be seperated by commas. > Wish me luck. > Eric > > > --- In [email protected], Karen > Kungowski > <[EMAIL PROTECTED]> wrote: > > > > Well. . . . . > > I did this in an Access module (VBA) but it isn't > > regex and to finish it off one needs to loop > through > > what's left until running into a alpha and then > > makeing the split. Will the "1249V_S" always be > the > > same length for each part? If that is the case, > take > > the left side x number and take the right side x > > number. Going back to my regularly programmed day, > > now. cheers. > > > > Function x() > > Dim strThis As String > > strThis = "For: Name-Location-40940, 1249V_S, 4120 > > City" > > > > strThis = Right(strThis, (Len(strThis) - InStr(1, > > strThis, ","))) > > strThis = Left(strThis, InStr(1, strThis, ",") - > 1) > > MsgBox strThis > > > > End Function > > > > > > --- Eric Throckmorton <[EMAIL PROTECTED]> > > wrote: > > > > > OK, > > > What i have so far is: > > > (For:)(.*[\w]+\b,) -that pulls the line > up > > > to: > > > For: Name-Location-40940, 1249V_S, (the > second > > > comma) > > > > > > I have been trying through code and through > the > > > regex to get this split and cannot. > > > Some help would be appreciated. > > > > > > Thank-you, > > > Eric > > > > > > > > > "Falls, Travis D (HTSC, CASD)" > > > <[EMAIL PROTECTED]> wrote: > > > Capture each item leading up to the "," in a > back > > > reference and then I would process the back > > > reference you need with another reg exp to split > it; > > > tokenize it. If you get stuck send me your exp > so > > > far and I will take a stab at it. I won't be > able > > > to do this until tomorrow afternoon though. HTH > > > > > > Travis D. Falls | Consultant RAFT.Net IT | > > > 860.547.4070 | [EMAIL PROTECTED] > > > > > > > > > -----Original Message----- > > > From: [email protected] > > > [mailto:[EMAIL PROTECTED] > > > Behalf Of > > > e_throckmorton > > > Sent: Wednesday, December 07, 2005 2:57 PM > > > To: [email protected] > > > Subject: [AspNetAnyQuestionIsOk] Regular > Expression > > > -- retrieving a > > > number > > > > > > > > > Working with regular expressions, I can get the > > > following line from a > > > text document: > > > For: Name-Location-40940, 1249V_S, 4120 City > > > > > > What I need to grab out of there is: > > > 1249V_S > > > > > > And then disect that into: > > > 1249 > > > and > > > V_S > > > > > > How can I do those things using regular > expressions? > > > > > > > > > Thank-you, > > > E > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ********************************************************************* > **** > > > This communication, including attachments, is > > > for the exclusive use of addressee and may > contain > > > proprietary, > > > confidential and/or privileged information. If > you > > > are not the intended > > > recipient, any use, copying, disclosure, > > > dissemination or distribution is > > > strictly prohibited. If you are not the > intended > > > recipient, please notify > > > the sender immediately by return e-mail, delete > this > > > communication and > > > destroy all copies. > > > > > > ********************************************************************* > **** > > > > > > > > > > > > SPONSORED LINKS > > > Basic programming language Computer > > > programming languages Programming languages > > > > Java programming language > > > > > > --------------------------------- > > > YAHOO! GROUPS LINKS > > > > > > > > > Visit your group "AspNetAnyQuestionIsOk" on > the > > > web. > > > > > > To unsubscribe from this group, send an > email > > > to: > > > > [EMAIL PROTECTED] > > > > > > Your use of Yahoo! Groups is subject to the > > > Yahoo! Terms of Service. > > > > > > > > > --------------------------------- > > > > > > > > > > > > > > > > > > > > > --------------------------------- > > > Yahoo! Shopping > > > Find Great Deals on Gifts at Yahoo! Shopping > > > > > > [Non-text portions of this message have been > > > removed] > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor > > > --------------------~--> > > > Most low income households are not online. Help > > > bridge the digital divide today! > > > > > > http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/saFolB/TM > > > > > > ------------------------------------------------------------------- > -~-> > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ > > > > > > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor > --------------------~--> > Most low income households are not online. Help > bridge the digital divide today! > http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/saFolB/TM > --------------------------------------------------------------------~-> > > > > Yahoo! Groups Links > > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ > > > [EMAIL PROTECTED] > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
