Thank you everyone, for all the fine suggestions. They will undoubtedly help me get the job done.
Rich (Ringo) Starkey -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Albert Berry Sent: Tuesday, May 21, 2002 6:10 PM To: [EMAIL PROTECTED] Subject: RE: Help with Function Richard, make one pass replacing the "." with a space, then a second pass replacing double spaces with single. "Richard Starkey" <[EMAIL PROTECTED]> wrote: >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/ > __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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/
