Karen:
All my error.
That's EXACTLY what I wanted to do (per the WHERE clause. )
I had run your syntax earlier, and failed. Then ran my fatal syntax
without understanding WHY it failed.
I reviewed the command history only after I posted. My syntax failed
because I muffed the WHERE clause in that first run. Instead of
[ WHERE trxnum LIKE 'V0%' ]
... I had typed
[ WHERE trxnum = 'V0' ]
... a stand-alone value which does not exist in the column.
But that leaves the question: "Why would it replace the entire string [
V00xxxxxx | v00xxxxxx ] with 'v0' ?"
Thanks again, Karen
Bruce
------ Original Message ------
From: "karentellef via RBASE-L" <[email protected]>
To: [email protected]
Sent: 1/14/2018 12:06:38 PM
Subject: Re: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question
Maybe I'm reading your statement wrong, but no I don't think that's what
you wanted to do. Did you want to do this?
UPDATE transx SET trxnum = (SRPL(trxnum, 'V0', 'v0', 0))
Karen
-----Original Message-----
From: Bruce Chitiea <[email protected]>
To: rbase-l <[email protected]>
Sent: Sun, Jan 14, 2018 12:11 pm
Subject: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question
Happy New Year to all!
Might this be the correct SRPL syntax for replacing a substring within a
text column? If not, what?
SET VAR vTargetColumn TEXT = NULL
SET VAR vTargetColumn = 'ColumnNAME'
UPDATE TableNAME SET &vTargetColumn =
(SRPL(&vTargetColumn,'SearchString','ReplaceString',0))
I ask because I attempted a SRPL on a column using a literal string in
place of '&vTargetColumn', with an ugly result (Fortunately I had a
backup. )
Target column 'transx' contained several thousand values [ V00xxxxxx |
v00xxxxxx ] where 'x' might be any digit. For visual
clarity-in-reporting's sake, I decided to replace the legacy capital 'V'
with lower case 'v'.
UPDATE transx SET trxnum = (SRPL('V0','V','v',0)) WHERE trxnum LIKE
'V0%'
This produced a uniform value of 'v0'. No trailing digits. Disaster.
Restore from backup.
???
Thanks very much,
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 m
--
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].
For more options, visit https://groups.google.com/d/optout.
--
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].
For more options, visit https://groups.google.com/d/optout.
--
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].
For more options, visit https://groups.google.com/d/optout.
