BTW, if you want clean up Field 1 and remove the 4 character unit number
from the end of the field, try this after you've updated Col2:
UPDATE TableName SET +
Col1 = (SGET(Col1,( (SLEN(Col1)) - 4),1))
In a test db, of course.
Doug
On 4/28/2024 4:56 PM, Doug Hamilton wrote:
OK, this will
Thank you Doug. I will be able to test tomorrow.
Thanks,
Larry
On Sun, Apr 28, 2024 at 2:56 PM Doug Hamilton wrote:
> OK, this will untested code should get the last 4 characters of the 1st
> col and concatenate "UNIT" and those 4 characters to col 2.
>
> UPDATE TableName SET +
> Col2 =
OK, this will untested code should get the last 4 characters of the 1st
col and concatenate "UNIT" and those 4 characters to col 2.
UPDATE TableName SET +
Col2 = (Col2 & 'UNIT' & (SGET(Col1,4,((SLEN(Col1)) - 4))) )
The only thing I'm sure of is the parenthesis are balanced. :)
Doug
On
Just a quick shot. IF ... IF there's only one in field1, the
SSUBCD function can see it as the "custom delimiter":
SET VAR vfield_1_entire TEXT = 'Smith a.4503'
SET VAR vfield_1_last4 TEXT = (SSUBCD(.vfield_1_entire,2,'.'))
Result:
SHOW VAR vfield_1_last4 = 4503
The length of the field after
Yes, but it is not a numeric field.
Larry
On Sun, Apr 28, 2024 at 2:34 PM Doug Hamilton wrote:
> Do all rows have numeric 4 last characters?
> If not, then after extracting them, they have to be tested.
> Otherwise you'd end up with "13566 Jones Road UNIT h a."
> Doable with functions, I
Do all rows have numeric 4 last characters?
If not, then after extracting them, they have to be tested.
Otherwise you'd end up with "13566 Jones Road UNIT h a."
Doable with functions, I think; just need more info.
Doug
On 4/28/2024 3:56 PM, Larry Haas wrote:
Good afternoon everyone:
I am
Good afternoon everyone:
I am working with Myron at the Sun City West Posse in Sun City West,
Arizona. I am trying to update a field in my table using that field and
concatenating something to it.
In Excel, it would look like this:
Field 1 Field 2
Smith a.4503 13566 Jones Road 13566
My version is just 6.5, no ++.
On Sun, Apr 28, 2024 at 12:17 AM 'R Hopkins' via RBASE-L <
rbase-l@googlegroups.com> wrote:
> Greg,
> I also have RBase 6.5++ for Windows running on Windows 10. I do not
> recall doing anything special when I installed it. Its been a few years,
> but I believe
8 matches
Mail list logo