set var vnote note = +
('Now is the time for all good men to come to the aid of their country.')set var vreplace note = + (srpl(.vnote,'men','men, women and children',1)) RESULT: Now is the time for all good men, women and children to come to the aid of their country. Brad Davidson CIO/CFO Aero-Craft Hydraulics, Inc. [email protected]<mailto:[email protected]> 951.736.4690 From: [email protected] <[email protected]> On Behalf Of Jim Belisle Sent: Monday, April 13, 2020 2:53 PM To: [email protected] Subject: RE: [RBASE-L] - Re: REPLACING INFORMATION 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. [cid:[email protected]] 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 [cid:[email protected]] From: 'Karen Tellef' via RBASE-L [mailto:[email protected]] Sent: Monday, April 13, 2020 4:47 PM To: [email protected]<mailto:[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: select PARTNAMEPC, (srpL(partnamepc,'2x10 8','2x10x96',0)) from tpartinfo Karen -----Original Message----- From: Karen Tellef <[email protected]<mailto:[email protected]>> To: rbase-l <[email protected]<mailto:[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]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> <[email protected]<mailto:[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]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> on behalf of Jim Belisle <[email protected]<mailto:[email protected]>> Sent: Monday, April 13, 2020 2:31:08 PM To: [email protected]<mailto:[email protected]> <[email protected]<mailto:[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 [cid:[email protected]] From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Monday, April 13, 2020 4:20 PM To: [email protected]<mailto:[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]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> On Behalf Of Jim Belisle Sent: Monday, April 13, 2020 2:04 PM To: [email protected]<mailto:[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 [cid:[email protected]] -- 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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CH2PR02MB7047AC604D49A5046F61F382A0DD0%40CH2PR02MB7047.namprd02.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/CH2PR02MB7047AC604D49A5046F61F382A0DD0%40CH2PR02MB7047.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>. -- 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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CH2PR02MB7047BB875FF165A55CDB3B10A0DD0%40CH2PR02MB7047.namprd02.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/CH2PR02MB7047BB875FF165A55CDB3B10A0DD0%40CH2PR02MB7047.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>. -- 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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/DM6PR06MB5051B52E7C74596B0B6EB7B4AADD0%40DM6PR06MB5051.namprd06.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/DM6PR06MB5051B52E7C74596B0B6EB7B4AADD0%40DM6PR06MB5051.namprd06.prod.outlook.com?utm_medium=email&utm_source=footer>. -- 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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/273672265.5123985.1586814445812%40mail.yahoo.com<https://groups.google.com/d/msgid/rbase-l/273672265.5123985.1586814445812%40mail.yahoo.com?utm_medium=email&utm_source=footer>. -- 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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CH2PR02MB70474BE713A4341B79E96B4FA0DD0%40CH2PR02MB7047.namprd02.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/CH2PR02MB70474BE713A4341B79E96B4FA0DD0%40CH2PR02MB7047.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>. -- 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/MWHPR2201MB1167D5803D0CC8140D798AC2D4DD0%40MWHPR2201MB1167.namprd22.prod.outlook.com.
