Javier:
I cannot speak for Mr. Haas, but I do appreciate the challenging GIS
context where atomized consistency is king. But Mr. Haas is not alone in
his desire. Working within the culture peculiar to charities and their
donors, there are three contexts to be respected:
(1) garbage formatting of commercially-purchased mailing lists;
(2) soulless USPS formatting for machine-scanned envelopes;
(3) polite and humane formatting for the human reader
(1) must be cleaned up and reformatted into (2) and (3), so both "Ln"
and "Lane" have their place.
The biggest challenge is in "same-paging" of addresses to eliminate
duplication, and establish an environment in which automated format
generation may be undertaken with confidence.
Example
12345 1/2 N ST FRANCIS ST NE ST LOUIS MO 12345
12345 NORTH SAINT FRANCIS STREET NORTHEAST #1/2 SAINT LOUIS MO
12345-6789
...etc.
Not a task for the faint of heart, or for someone without powerful
string-manipulation tools.
Bruce
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
rby...@safesectors.com | +011 (909) 238-9012 c | +011 (909) 912-8678 f
------ Original Message ------
From: javier.valen...@vtgonline.com
To: rbase-l@googlegroups.com
Sent: 9/3/2021 10:09:31 AM
Subject: RE: [RBASE-L] - Doing a replace in a data field in RBASE
I am curious as to why you want to change “Ln” to “Lane”?
In my applications I have done the opposite since it makes it
compatible with most every other application out there that use the
address for GIS location; we don’t even allow a dot (“.”) after the
description. The caveat is that my applications are used by Public
Works agencies that deal with numerous variations of the same name and
need to interface with GIS systems and the address is typically stored
as separate components and a computed column merges them all together.
Javier,
Javier Valencia, PE
913-915-3137
From:rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of
Larry Haas
Sent: Tuesday, August 31, 2021 9:45 PM
To:rbase-l@googlegroups.com
Subject: [RBASE-L] - Doing a replace in a data field in RBASE
Good evening everyone:
I am new to RBASE and was looking at the string manipulation functions
and couldn't find one that would work for me.
I would like to change a database field similar to using the find and
replace function in Excel.
In my street name field I have ("Black Gold Ln", "Mirage Ln", etc.). I
would like to mass blast this field by changing all of my "Ln"s to
"Lane".
Would someone know how I could accomplish that?
Thanks,
Larry Haas
--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/CAB3VSUWEkyyD9D4uBj8FPHbSh3JtyZNJ1XmMx%2BVcL7mceEFA2g%40mail.gmail.com
<https://groups.google.com/d/msgid/rbase-l/CAB3VSUWEkyyD9D4uBj8FPHbSh3JtyZNJ1XmMx%2BVcL7mceEFA2g%40mail.gmail.com?utm_medium=email&utm_source=footer>.
--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAABBgsE7hdM9AmsEzohoCWzEBAAAAAA%3D%3D%40vtgonline.com
<https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAABBgsE7hdM9AmsEzohoCWzEBAAAAAA%3D%3D%40vtgonline.com?utm_medium=email&utm_source=footer>.
--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em7a19a34d-4062-40fb-9eed-ff290f9fee2d%40pathfinder.