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