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]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E4A6D45%40EXCHANGE10.
