I get "--ERROR-- Argument 3 of SRPL function cannot be integer".
If I SET ZERO OFF, I get "--ERROR-- Argument 3 of SRPL function cannot be 0". But it seemed like a good idea ... Sami ----- Original Message ----- From: "Ron Rose" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 6:07 PM Subject: Re: Removing blank from data > Did you try : > SET VAR vSpace TEXT = CHAR(32) > (SRPL((FORMAT(.ftest,'99999999999999999999'))),.vSpace,'',1)) > RRR > > ----- Original Message ----- > From: "Sami Aaron" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, June 11, 2002 8:50 AM > Subject: Removing blank from data > > > > I am trying to compare data entered into a new record with existing data > in > > the table. > > > > The data could be entered as: > > > > 00-051-334944 > > 00051334944 > > 00 051 334944 > > 00-051-334944CZA > > Y 00 051-334944 > > > > I want to compare JUST the NUMBERS entered into the field, so in this > case, > > I want to get the value to: > > > > 00051334944 > > > > then see if that value exists in the table, in any of the above formats. > > > > I can use the FORMAT function to strip out all non-numeric characters: > > SET VAR vtest TEXT = (FORMAT(.ftest,'99999999999999999999')) > > > > However, this function leaves a blank (CHAR(32))? anywhere there are > > non-numeric values. So, if the user entered, 00-051-334944, this function > > would give me 00 051 334944. > > > > Does anyone know a function or one-step SET VAR command to eliminate the > > remaining spaces within the field? I've tried the SRPL with the (CHAR(0)) > > and with the (CHAR(8)) (backspace) but to no avail. > > > > I want to be able to issue the command: > > > > SELECT COUNT(*) INTO vcount FROM table WHERE (format(columnname,something, > > something)) = .vtest. > > > > example: SELECT COUNT(*) INTO vcount FROM table WHERE 00051334944 = > > 00051334944 > > > > Thanks, > > Sami > > > > ----------------------------------------------------------- > > Sami Aaron > > Software Management Specialists > > 19312 W 63rd Terr > > Shawnee KS 66218 > > 913-915-1971 > > http://www.softwaremgmt.com > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
