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 [cid:[email protected]] 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 [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]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/DM6PR06MB5051B52E7C74596B0B6EB7B4AADD0%40DM6PR06MB5051.namprd06.prod.outlook.com.
