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
<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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAABBgsE7hdM9AmsEzohoCWzEBAAAAAA%3D%3D%40vtgonline.com.
