Bruce, Karen, I just finished segmenting 2,500 miles of streets for one of the larger cities in the Mid West and, when you have that many streets, the change of repetition is great so many have not only a prefix but a suffix as well in addition to the street type. For the prefix we can have N, S, E, W, NE, NW, SE and SW For the suffix we can have N, S, E and W And for the street type we have: AV, BL. CI, CT,DR, EX, HW, LN, PK, PL, RD, ST, TE, TR, VI,WA and XI For everything we just use the initial with no period/dot at the end. All the correspondence I receive from the Federal and local Government including IRS, SSA, Medicare, various states, Corps of Engineer and so on, they all use only the abbreviations with no periods/dots at the end; the Assessor’s office for my city/county uses only abbreviation. My address is printed as: xxxxx S Twilight LN I just received packages from Amazon and they also have the address with initials and no periods/dots at the end. I have attended a few seminars in the recent past that dealt at some point with addresses and the consensus is to use the plain abbreviations; this is related to the type of work I do. I agree that the extended format is easier to read but most of the people at the receiving end do not really care what is says, only that they receive it and the great majority of mail sent uses automated processes to generate the addresses and for the USPS to process it and it generally works better with the abbreviations. Again, this is now pretty much standard for the type of work I do and the agencies and vendors I deal with and I am sure other application have other requirements. Javier, Javier Valencia, PE 913-915-3137 From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Bruce Chitiea Sent: Friday, September 3, 2021 1:22 PM To: rbase-l@googlegroups.com Subject: Re[2]: [RBASE-L] - Doing a replace in a data field in RBASE 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 <mailto:rby...@safesectors.com> | +011 (909) 238-9012 c | +011 (909) 912-8678 f ------ Original Message ------ From: javier.valen...@vtgonline.com <mailto:javier.valen...@vtgonline.com> To: rbase-l@googlegroups.com <mailto: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 <mailto:rbase-l@googlegroups.com> <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > On Behalf Of Larry Haas Sent: Tuesday, August 31, 2021 9:45 PM To: rbase-l@googlegroups.com <mailto: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 <mailto: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 <mailto: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 <mailto: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 <https://groups.google.com/d/msgid/rbase-l/em7a19a34d-4062-40fb-9eed-ff290f9fee2d%40pathfinder?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%2BA71stIig71BAFnx9iihQAAEAAAAE/BSTdZqBhMr9/CzHphKlsBAAAAAA%3D%3D%40vtgonline.com.