cant do everything for you -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Friday, 21 November 2008 11:24 AM To: cfaussie@googlegroups.com Subject: [cfaussie] parsing as string into a text and numeric portion
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 -~----------~----~----~----~------~----~------~--~---