Re: [RBASE-L] - Doing a replace in a data field in RBASE

Happy to assist. It’s all there. Bruce On Aug 31, 2021, 21:35 -0700, Larry Haas , wrote: > Thanks so much. Exactly what I need. > > Larry Haas > > > On Tue, Aug 31, 2021 at 9:28 PM Bruce Chitiea > > wrote: > > > Search the Help feature for the ‘SRPL’ function: (SRPL(columnName,’Ln‘, > > >

Re: [RBASE-L] - Doing a replace in a data field in RBASE

Thanks so much. Exactly what I need. Larry Haas On Tue, Aug 31, 2021 at 9:28 PM Bruce Chitiea 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:

Re: [RBASE-L] - Doing a replace in a data field in RBASE

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,

[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