[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

[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