Yes, you want ZERO in the update, not the 1
Karen
-----Original Message-----
From: Dan Goldberg <[email protected]>
To: [email protected] <[email protected]>
Sent: Mon, Apr 13, 2020 4:35 pm
Subject: [RBASE-L] - Re: REPLACING INFORMATION
#yiv3716570670 #yiv3716570670 _filtered {} _filtered {} _filtered {}
#yiv3716570670 p.yiv3716570670MsoNormal, #yiv3716570670
li.yiv3716570670MsoNormal, #yiv3716570670 div.yiv3716570670MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;} #yiv3716570670 a:link,
#yiv3716570670 span.yiv3716570670MsoHyperlink
{color:blue;text-decoration:underline;} #yiv3716570670 a:visited,
#yiv3716570670 span.yiv3716570670MsoHyperlinkFollowed
{color:purple;text-decoration:underline;} #yiv3716570670 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}
#yiv3716570670 p.yiv3716570670MsoAcetate, #yiv3716570670
li.yiv3716570670MsoAcetate, #yiv3716570670 div.yiv3716570670MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;} #yiv3716570670
span.yiv3716570670EmailStyle17 {color:windowtext;} #yiv3716570670
span.yiv3716570670EmailStyle19
{font-family:New;color:#1F497D;font-weight:normal;font-style:normal;}
#yiv3716570670 span.yiv3716570670BalloonTextChar {} #yiv3716570670
.yiv3716570670MsoChpDefault {font-size:10.0pt;} _filtered {} #yiv3716570670
div.yiv3716570670WordSection1 {} #yiv3716570670 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
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 --
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
[email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/CH2PR02MB7047AC604D49A5046F61F382A0DD0%40CH2PR02MB7047.namprd02.prod.outlook.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
[email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/CH2PR02MB7047BB875FF165A55CDB3B10A0DD0%40CH2PR02MB7047.namprd02.prod.outlook.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/DM6PR06MB5051B52E7C74596B0B6EB7B4AADD0%40DM6PR06MB5051.namprd06.prod.outlook.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/1682502465.5180593.1586814360500%40mail.yahoo.com.
