[Logic] database commands

[Frank Ayers]

Hi
There may be a way to do this. However, anybody playing with this do so at
your own risk! You would probably have to use the AT() function along with
the SUBSTR() function. Say your comment field has this in it -

DXCC:POSS DXCC:IOTA:WPX:

The AT("POSS DXCC",COMMENTS) command would give the starting position for
POSS DXCC as 6. The string POSS DXCC is 9 characters long. So, the first
part of the string you want would be SUBSTR(COMMENTS,1,AT("POSS
DXCC",COMMENTS) ). That would give you "DXCC:" Then you would do a
SUBSTR(COMMENTS,AT("POSS DXCC",COMMENTS)+9,40) and that would give you
"IOTA:WPX:" Then you concatenate the two strings. It may also be possible
with LEFT() and RIGHT() commands.
If there is actually any interest in this, I'll give it a try in a day or
two.

Frank
W2FCA

> However, this will delete the ENTIRE Comments field content.  For
> instance, you might also have text in the Comments field other than
> "POSS DXCC" that you do not want to get rid of.  I'm not sure of a way
> to use Database Commands to selectively delete only that portion of
> the Comments field containing "POSS DXCC" and leaving the rest of the
> text (if any) intact.  There probably is a dBase command to do it.
> Ask Dennis.  (If you do find out the command, I'd sure like to learn
> it.)