Happy to assist. It’s all there. Bruce On Aug 31, 2021, 21:35 -0700, Larry Haas <[email protected]>, wrote: > Thanks so much. Exactly what I need. > > Larry Haas > > > On Tue, Aug 31, 2021 at 9:28 PM Bruce Chitiea <[email protected]> > > wrote: > > > 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 <[email protected]>, 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 [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/98fbf6f3-53a6-410d-a92c-e3a603e78472%40Spark. > -- > 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/CAB3VSUV0eRC11Qeb_pGoKVXFOC5eNmmvzWfUH7DgoaH_1TpecQ%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/1e8441db-5b2a-485f-9f23-63d01a0664f0%40Spark.
