×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hi Alan -
On Fri, 18 Jan 2008 16:24:20 -0500, Alan Shore <AlanShore@xxxxxxxx>
wrote:
My head is stuck on using %replace - is this correct, or should I be using
something else?
You're on the right track. You would want to use %scan to find "" and
%replace to replace "" with ". Continue looping until not found.
BUT ... you need to be careful if there could be more than two double
quotes together. If that circumstance can occur, you'll need to write
the code carefully to make sure that the result is what you want.
For example, if you always start the scan at the beginning of the
field, or any point in the string at the replacement point or earlier,
any number of consecutive "s will always be collapsed to just one ".
Ken
Opinions expressed are my own and do not necessarily represent the views
of my employer or anyone in their right mind.
As an Amazon Associate we earn from qualifying purchases.