You're doing something wrong. In my test database, here's an example. The column is "columntext" and I'm replacing "BC" with "zzz". You can see how it inserts it in the correct place. Try the "select" statement to test your data R>select columntext, (srpl(columntext,'BC','zzz',0)) from testklt3 columntext (srpl(columntex ---------- --------------- ABCD 123 AzzzD 123 BC 123 zzz 123 DEF 123 DEF 123
Karen -----Original Message----- From: Jim Belisle <[email protected]> To: [email protected] <[email protected]> Sent: Mon, Apr 13, 2020 4:59 pm Subject: RE: [RBASE-L] - Re: REPLACING INFORMATION #yiv7525343331 #yiv7525343331 -- _filtered {} _filtered {} _filtered {} _filtered {} #yiv7525343331 #yiv7525343331 p.yiv7525343331MsoNormal, #yiv7525343331 li.yiv7525343331MsoNormal, #yiv7525343331 div.yiv7525343331MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;} #yiv7525343331 a:link, #yiv7525343331 span.yiv7525343331MsoHyperlink {color:blue;text-decoration:underline;} #yiv7525343331 a:visited, #yiv7525343331 span.yiv7525343331MsoHyperlinkFollowed {color:purple;text-decoration:underline;} #yiv7525343331 p {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;} #yiv7525343331 p.yiv7525343331MsoAcetate, #yiv7525343331 li.yiv7525343331MsoAcetate, #yiv7525343331 div.yiv7525343331MsoAcetate {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;} #yiv7525343331 p.yiv7525343331msonormal, #yiv7525343331 li.yiv7525343331msonormal, #yiv7525343331 div.yiv7525343331msonormal {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;} #yiv7525343331 p.yiv7525343331msoacetate, #yiv7525343331 li.yiv7525343331msoacetate, #yiv7525343331 div.yiv7525343331msoacetate {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;} #yiv7525343331 p.yiv7525343331msochpdefault, #yiv7525343331 li.yiv7525343331msochpdefault, #yiv7525343331 div.yiv7525343331msochpdefault {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;} #yiv7525343331 span.yiv7525343331msohyperlink {} #yiv7525343331 span.yiv7525343331msohyperlinkfollowed {} #yiv7525343331 span.yiv7525343331emailstyle17 {} #yiv7525343331 span.yiv7525343331emailstyle19 {} #yiv7525343331 p.yiv7525343331msonormal1, #yiv7525343331 li.yiv7525343331msonormal1, #yiv7525343331 div.yiv7525343331msonormal1 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;} #yiv7525343331 span.yiv7525343331msohyperlink1 {color:blue;text-decoration:underline;} #yiv7525343331 span.yiv7525343331msohyperlinkfollowed1 {color:purple;text-decoration:underline;} #yiv7525343331 p.yiv7525343331msoacetate1, #yiv7525343331 li.yiv7525343331msoacetate1, #yiv7525343331 div.yiv7525343331msoacetate1 {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;} #yiv7525343331 span.yiv7525343331emailstyle171 {color:windowtext;} #yiv7525343331 span.yiv7525343331emailstyle191 {color:#1F497D;font-weight:normal;font-style:normal;} #yiv7525343331 p.yiv7525343331msochpdefault1, #yiv7525343331 li.yiv7525343331msochpdefault1, #yiv7525343331 div.yiv7525343331msochpdefault1 {margin-right:0in;margin-left:0in;font-size:10.0pt;} #yiv7525343331 span.yiv7525343331EmailStyle32 {font-family:New;color:#1F497D;font-weight:normal;font-style:normal;} #yiv7525343331 span.yiv7525343331BalloonTextChar {} #yiv7525343331 .yiv7525343331MsoChpDefault {font-size:10.0pt;} _filtered {} #yiv7525343331 div.yiv7525343331WordSection1 {} #yiv7525343331 I did it with using the 0 and the 1 and neither does what I want. They both wipe out the other wording in the field. You can see below. Maybe I have to capture the remainder of the wording with another FUNCTION and combine the two? James Belisle Making Information Systems People Friendly Since 1990 From: 'Karen Tellef' via RBASE-L [mailto:[email protected]] Sent: Monday, April 13, 2020 4:47 PM To: [email protected] Subject: Re: [RBASE-L] - Re: REPLACING INFORMATION And BTW Jim: You can also do a 'select' statement first to test what you would get. So you could do: selectPARTNAMEPC,(srpL(partnamepc,'2x10 8','2x10x96',0)) from tpartinfo Karen -----Original Message----- From: Karen Tellef <[email protected]> To: rbase-l <[email protected]> Sent: Mon, Apr 13, 2020 4:46 pm Subject: Re: [RBASE-L] - Re: REPLACING INFORMATION Yes, you want ZERO in the update, not the 1 Karen -----Original Message----- From: Dan Goldberg <[email protected]> To: [email protected] <[email protected]> Sent: Mon, Apr 13, 2020 4:35 pm Subject: [RBASE-L] - Re: REPLACING INFORMATION Did u use the 0 in the sprl? Dan Goldberg MIS Manager Lance Campers From: [email protected] <[email protected]> on behalf of Jim Belisle <[email protected]> Sent: Monday, April 13, 2020 2:31:08 PM To: [email protected] <[email protected]> Subject: [RBASE-L] - RE: REPLACING INFORMATION I am glad I practiced this on a copy of the table because it did work in replacing the specific words BUT it did not keep the rest of the wording in the field PARTNAMEPC. UPDATE tPARTINFO SET PARTNAMEPC = (srpL(partnamepc,'2x10 8','2x10x96',1)) where PARTNUM CONTAINS 'RP%-7' So I ended up with JUST the 2x10x96 in the field for each row. What I want to do is JUST replace the 2x10 8 with 2x10x96 and leave the remainder of the words. James Belisle Making Information Systems People Friendly Since 1990 From: [email protected] [mailto:[email protected]]On Behalf Of Dan Goldberg Sent: Monday, April 13, 2020 4:20 PM To: [email protected] Subject: [RBASE-L] - RE: REPLACING INFORMATION Think you need to use the column name in the srpl UPDATE PARTINFO SET PARTNAMEPC = (SRPL(PARTNAMEPC,'2x10 8','2x10x96',0)) where PARTNUM CONTAINS 'RP%-7' Dan Goldberg From: [email protected] <[email protected]>On Behalf Of Jim Belisle Sent: Monday, April 13, 2020 2:04 PM To: [email protected] Subject: [RBASE-L] - REPLACING INFORMATION I am wanting to replace ONLY specific wording in a specific column leaving the rest of the wording in the field. I have looked at the SRPL function and tried this code but it does not update the column for those rows meeting the filter. I have also tried it using the 0 for the last argument with no success. UPDATE PARTINFO SET PARTNAMEPC = (SRPL('2x10 8','2x10 8','2x10x96',1)) where PARTNUM CONTAINS 'RP%-7' Any blues clues? James Belisle Making Information Systems People Friendly Since 1990 -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CH2PR02MB7047AC604D49A5046F61F382A0DD0%40CH2PR02MB7047.namprd02.prod.outlook.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CH2PR02MB7047BB875FF165A55CDB3B10A0DD0%40CH2PR02MB7047.namprd02.prod.outlook.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/DM6PR06MB5051B52E7C74596B0B6EB7B4AADD0%40DM6PR06MB5051.namprd06.prod.outlook.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/273672265.5123985.1586814445812%40mail.yahoo.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CH2PR02MB70474BE713A4341B79E96B4FA0DD0%40CH2PR02MB7047.namprd02.prod.outlook.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/696459894.5197379.1586815722466%40mail.yahoo.com.
