I will try that. James Belisle
Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Monday, April 13, 2020 5:15 PM To: [email protected] Subject: Re: [RBASE-L] - REPLACING INFORMATION Jim, A DECLARE CURSOR may be needed to update those specific records. -- Start of Code -- Update Part Information Contents CLEAR ALL VAR SET VAR vPARTNAMEPC TEXT = NULL SET VAR vSrchReplDesc TEXT = NULL SET VAR vSearchString TEXT = '2x10 8' SET VAR vReplaceString TEXT = '2x10x96' SET VAR vCheckCursor INTEGER = (CHKCUR('c1')) IF vCheckCursor = 1 THEN DROP CURSOR c1 ENDIF DECLARE c1 CURSOR FOR SELECT PARTNAMEPC FROM PARTINFO + WHERE PARTNAMEPC CONTAINS 'RP%-7' OPEN c1 FETCH c1 INTO vPARTNAMEPC INDICATOR iv1 WHILE SQLCODE <> 100 THEN SET VAR vSrchReplDesc = (SRPL(.vPARTNAMEPC,.vSearchString,.vReplaceString,0)) UPDATE PARTINFO SET PARTNAMEPC = .vSrchReplDesc WHERE CURRENT OF c1 FETCH c1 INTO vPARTNAMEPC INDICATOR iv1 ENDWHILE DROP CURSOR c1 PAUSE 2 USING 'Done.' RETURN Hope it helps! Very Best R:egards, Razzak At 05:03 PM 4/13/2020, Jim Belisle wrote: >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 -- 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/202004132215.03DMFCNn010025%40atl4mhob15.registeredsite.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/CH2PR02MB70474D43FDA4D4BF13F912E1A0DD0%40CH2PR02MB7047.namprd02.prod.outlook.com.
