Sometimes, if the parser is having a problem interpreting what is stated, you can substitute a variable which internally has the correct parameter. SET VAR .vMT TEXT = '' (SRPL(FirstName,'.',.vMT,0)) Does this make it work? RRR
----- Original Message ----- From: "Richard Starkey" <[EMAIL PROTECTED]> To: "Rbase-L" <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 12:25 PM Subject: Help with Function > Hello All, > > How would you go about replacing a '.' without using the space ' ' in the > (SRPL(0)) function. > I have Imported Data in the table that looks like this: > > Mr. & Mrs. A. > George C. & Linda V. > > I want it to look like this: > > Mr & Mrs A --- No punctuation and no additional spaces > George C & Linda V --- No punctuation and no additional spaces > > Following is the statement I used: > Update Person set FirstName = (SRPL(FirstName,'.','',0)) Where FirstName > contains '.' > > I receive the following error message " -Error- Argument 3 of function SRPL > cannot be INTEGER. (2153)" Third argument is two single quotes. > > When I use the following statement the function works, however I have an > additional space in the data. Third argument no has a space between the > single quotes. > > Update Person set FirstName = (SRPL(FirstName,'.',' ',0)) Where FirstName > contains '.' There is an extra space between Mr,Mrs and A > I cannot have a double space between the characters. (Mr__& Mrs__ A_) > > > Any help would be appreciated. > > Rich ( RINGO) Starkey > > > > > > > ================================================ > 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/
