And to add to the discussion, Maryland Department of Taxation property identifiers spells out Saint, as in Saint Paul St, but abbreviates street name suffixes, ST, LN, PL, AVE. It also abbreviates direction, 11 East Franklin Street becomes 11 Franklin E ST, which probably does not meet USPS addressing standards, which would be typically 11 E Franklin St. Go figure!
So, it all depends on what state/ locale and data one is working with. Hope all is well, Steve J From: [email protected] [mailto:[email protected]] Sent: Saturday, September 04, 2021 9:14 AM To: Digest recipients Subject: [RBASE-L] - Digest for [email protected] - 3 updates in 1 topic [email protected] <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> Google Groups <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> Topic digest View all topics · Doing a replace in a data field in RBASE - 3 Updates <http://groups.google.com/group/rbase-l/t/87853968637ed375?utm_source=digest&utm_medium=email> Doing a replace in a data field in RBASE <[email protected]>: Sep 03 12:09PM -0500 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: [email protected] <[email protected]> On Behalf Of Larry Haas Sent: Tuesday, August 31, 2021 9:45 PM To: [email protected] 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 [email protected] <mailto:[email protected]> . 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 <https://groups.google.com/d/msgid/rbase-l/CAB3VSUWEkyyD9D4uBj8FPHbSh3JtyZNJ1XmMx%2BVcL7mceEFA2g%40mail.gmail.com?utm_medium=email&utm_source=footer> &utm_source=footer> . Karen Tellef <[email protected]>: Sep 03 05:20PM Hmmm... my experience is the exact opposite, Javier. If I'm doing something "official" online and I put my street as Beckwith Ln (which is what I usually do), I get the automatic response of "do you want to replace it with official address Beckwith Lane" Karen -----Original Message----- From: [email protected] To: [email protected] Sent: Fri, Sep 3, 2021 12:09 pm Subject: RE: [RBASE-L] - Doing a replace in a data field in RBASE <!--#yiv2336744003 _filtered {} _filtered {}#yiv2336744003 #yiv2336744003 p.yiv2336744003MsoNormal, #yiv2336744003 li.yiv2336744003MsoNormal, #yiv2336744003 div.yiv2336744003MsoNormal {margin:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv2336744003 a:link, #yiv2336744003 span.yiv2336744003MsoHyperlink {color:blue;text-decoration:underline;}#yiv2336744003 span.yiv2336744003EmailStyle19 {font-family:"Calibri", sans-serif;color:windowtext;}#yiv2336744003 .yiv2336744003MsoChpDefault {font-family:"Calibri", sans-serif;} _filtered {}#yiv2336744003 div.yiv2336744003WordSection1 {}-->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, PE913-915-3137 From: [email protected] <[email protected]> On Behalf Of Larry Haas Sent: Tuesday, August 31, 2021 9:45 PM To: [email protected] 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CAB3VSUWEkyyD9D4uBj8FPHbSh3JtyZNJ1XmMx%2BVcL7mceEFA2g%40mail.gmail.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/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAABBgsE7hdM9AmsEzohoCWzEBAAAAAA%3D%3D%40vtgonline.com. "Bruce Chitiea" <[email protected]>: Sep 03 06:22PM 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 [email protected] | +011 (909) 238-9012 c | +011 (909) 912-8678 f ------ Original Message ------ From: [email protected] To: [email protected] Sent: 9/3/2021 10:09:31 AM Subject: RE: [RBASE-L] - Doing a replace in a data field in RBASE >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 > ><https://groups.google.com/d/msgid/rbase-l/CAB3VSUWEkyyD9D4uBj8FPHbSh3JtyZNJ1XmMx%2BVcL7mceEFA2g%40mail.gmail.com?utm_medium=email&utm_source=footer> > &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 [email protected]. 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 <https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAABBgsE7hdM9AmsEzohoCWzEBAAAAAA%3D%3D%40vtgonline.com?utm_medium=email&utm_source=footer> &utm_source=footer>. Back to top You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page. To unsubscribe from this group and stop receiving emails from it send an email to [email protected]. -- 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/038701d7a459%24b844cc00%2428ce6400%24%40sprintmail.com.
