And BTW Jim: You can also do a 'select' statement first to test what you would get. So you could do: select PARTNAMEPC, (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 #yiv7547220535 filtered {}#yiv7547220535 filtered {}#yiv7547220535 filtered {}#yiv7547220535 p.yiv7547220535MsoNormal, #yiv7547220535 li.yiv7547220535MsoNormal, #yiv7547220535 div.yiv7547220535MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv7547220535 a:link, #yiv7547220535 span.yiv7547220535MsoHyperlink {color:blue;text-decoration:underline;}#yiv7547220535 a:visited, #yiv7547220535 span.yiv7547220535MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv7547220535 p {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv7547220535 p.yiv7547220535MsoAcetate, #yiv7547220535 li.yiv7547220535MsoAcetate, #yiv7547220535 div.yiv7547220535MsoAcetate {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}#yiv7547220535 span.yiv7547220535EmailStyle17 {color:windowtext;}#yiv7547220535 span.yiv7547220535EmailStyle19 {font-family:New;color:#1F497D;font-weight:normal;font-style:normal;}#yiv7547220535 span.yiv7547220535BalloonTextChar {}#yiv7547220535 .yiv7547220535MsoChpDefault {font-size:10.0pt;}#yiv7547220535 filtered {}#yiv7547220535 div.yiv7547220535WordSection1 {}#yiv7547220535 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 to [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 to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/273672265.5123985.1586814445812%40mail.yahoo.com.
