If you have long complex strings you can use regex to return an array refering to each number in the string or each text block.
But the other suggestions are easiest if the string is always as simple as you just described. Blair On Fri, Nov 21, 2008 at 11:24 AM, Scott Thornton < [EMAIL PROTECTED]> wrote: > > needs scope: > > text = REReplaceNoCase(string, "[[:digit:]]", "", "All"); > > >>> "Steve Onnis" <[EMAIL PROTECTED]> 21/11/2008 11:11 am >>> > > text = REReplaceNoCase(string, "[[:digit:]]", ""); > numbers = REReplaceNoCase(string, "[^[:digit:]]", ""); > > Simple enough? > > -----Original Message----- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On > Behalf > Of Scott Thornton > Sent: Friday, 21 November 2008 11:03 AM > To: cfaussie@googlegroups.com > Subject: [cfaussie] parsing as string into a text and numeric portion > > > Hi, > > Given a string like acb123, is there a simple method of parsing into the > text portion and the numeric portion. > > I have thought about looping of each character of the string and checking > to > see if it was IsNumeric. > > Any better ideas? > > Scott Thornton, Programmer > Billing Unit, Hunter-New England Area Health Service > ext: 51762 p: +61 02 491 51762 m: 0413 800 242 > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---