Jim,
I'm glad.
Stay well, stay healthy, and stay hopeful!
Very Best R:egards,
Razzak
At 08:23 AM 5/8/2020, Jim Belisle wrote:
Razzak,
With a little manipulation of your code, I was able to get the desired result.
Thanks again for having this list.
For someone like myself who has had little training (thankful for
the week spent with you), it has been a great help.
James Belisle
From: [email protected] [mailto:[email protected]] On
Behalf Of Jim Belisle
Sent: Monday, April 13, 2020 5:20 PM
To: [email protected]
Subject: RE: [RBASE-L] - REPLACING INFORMATION
I will try that.
James Belisle
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/0Lcigr-1ioLt23YXv-00k7oP%40mrelay.perfora.net.
