[Logic] database commands

[Frank Ayers]

> From EI6HB <ei6hb@eircom.net> on Aug 04, 2003:
>
> > I put 'POSS DXCC' in the comment field on the log file to try and
> > monitor DXCC cards. I am now using DXCC YES user field and marking
> > it with a 'Y' when I have the card for the QSO.  I now want to
> > delete POSS DXCC from the comment field from 'Advanced', DATABASE
> > COMMANDS, typing USE LOG, then MASS CHANGES, REPLACE FIELD
> > CONTENTS. I have typed several commands here but no joy.

Here is the command I tried and it worked. The description is from the help
file -

*************************************************
STRTRAN() is used to change text within a string expression.  The first
parameter is the string to be searched.  The second parameter is the text to
be searched for.  The third parameter is the replacement value.
For example -

STRTRAN("ABCDE", "CD", "XY") returns ABXYE.
Every occurance of "CD" is changed to "XY."

STRTRAN("ABCDE", "CD", "") returns ABE.
"CD" is changed to "."

I put 'POSS DXCC' in a few comment fields, then did the mass change with
this expression -

REPLACE COMMENT WITH STRTRAN(log.comment, "POSS DXCC", "")

It got rid of them. One of my problems in life is using too many languages.
ORACLE, dBase, etc all have ways to do this but it's a bit different in each
language so it took me a bit to find the right one. In Oracle it's
"REPLACE", dBase it's STRTRAN. Oh well, it's like when my wife, who knows
French, took Spanish a while back. "there's the dog" sometimes came out
"voici el perro".

By the way - make a bakup before you try this!

Frank
W2FCA