Not a good solution on a large scale SRPL... Each time the udf is called it has to be loaded and released from memory... I would use SGET 2 times like:
update sometable set PhNO = ((Sget(Phno,3,1))+(Sget(Phno,4,5))) ----- Original Message ----- From: "William Cook" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, June 20, 2003 9:20 AM Subject: [RBASE-L] - Re: SRPL > Perhaps a UDF coded in C? > > ----- Original Message ----- > From: "Troy Sosamon" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > Sent: Friday, June 20, 2003 7:14 AM > Subject: [RBASE-L] - SRPL > > > > Has anyone figured out how to use SRPL to not only remove a > character, but > > the spact too. > > I need a function that will strip the dashes out of phone numbers. > > > > 123-4567 needs to come back 1234567. > > > > I can loop through and process on character at a time, but I would > really > > like to be able to get the results in a select w/o having to do > that. > > > > Thanks, > > > > Troy > > > >
