Wow, Thanks Mike. I didn't know you could use negative numbers. This is really valuable when cleaning up other's data snafus. It's a keeper in the private help files.... Bob C
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB Sent: Saturday, March 08, 2008 7:29 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: MORE FUNCTION QUESTIONS ----- Original Message ----- From: "Castanaro, Bob" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Saturday, March 08, 2008 12:22 AM Subject: [RBASE-L] - RE: MORE FUNCTION QUESTIONS List friends, Figured it all out using the ifeq, slen and sget functions from back in the cobwebs of my late night brain. But still wondering if there isn't a function to het the last xx characters from any string without a long expression. I just can't keep up with all the innovations these days... BC > If you want just the LAST six chars it's just: update tableName set columnName = (sget(columnName, 6, ((slen(columnName)) - 6))) > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Castanaro, Bob Sent: Saturday, March 08, 2008 12:03 AM To: RBASE-L Mailing List Subject: [RBASE-L] - MORE FUNCTION QUESTIONS Now that I am thoroughly happy with the TRIM function, I have another issue. One downloaded field has catalog numbers. Unfortunately some are 18 char long with leading zeroes, and some are 10 char long with leading zeros. I just need the last six characters. I have this a s a text field, and need to convert this for easy reading for the staff. Editorial comment: This idiotic program was written in Oracle, is online, and I have no control over the downloads. The "gurus" that I have had contact with have no sense of user friendly applications. Thank Razzak for R:base - at least we have a tool to clean up other's garbage and make it useful. BC Robert M. Castanaro Director, Surgical Services, Clinic and Pain Services Summa Health System Barberton Hospital 155 Fifth Street N.E. Barberton, Ohio 44203 Phone 330-615-3627 [EMAIL PROTECTED] [cid:[email protected]]
