Search the Help feature for the ‘SRPL’ function: (SRPL(columnName,’Ln‘,
‘Lane’,1))
Note, the “1” forces a whole-word search so that ‘Kiln House’ remains untouched.
Whole command:
UPDATE tableName +
SET columnName = +
(SRPL(columnName,’Ln’,’Lane’,1))
Cheers,
Bruce
On Aug 31, 2021, 19:46 -0700, Larry Haas <larwii...@gmail.com>, wrote:
> 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.
--
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/98fbf6f3-53a6-410d-a92c-e3a603e78472%40Spark.
