logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Mass Change Issue
N8VZ
#1 Posted : Monday, January 25, 2021 1:18:33 PM(UTC)
cjdenbow

Rank: Advanced Member

Groups: Registered, Beta Testers
Posts: 30
Man
Location: EM89wh

Thanks: 2 times
Was thanked: 1 time(s) in 1 post(s)
Dennis,

Due to an import from another program I have a number of strange entries in the CQZ and ITUZ fields. The entries are “03/04/05” for the former and “06/07/08” for the latter. There are about 75 of these entries, so I’d like to solve the problem via a mass change not individual edits. However, when I try this I get no matches when I enter one of these strings in a filter. I’ve done this kind of thing with other changes and had no problem, but this one has me stumped. I think it’s because the CQZ and ITUZ fields are incompatible with strings of this length and with the “/” character. Any suggestions about how I can accomplish deleting these entries and just making them blank would be appreciated.

Tnxs & 73,

Carl
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
WN4AZY
#2 Posted : Monday, January 25, 2021 10:08:32 PM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 2,541
Man
Location: Auburn, GA

Thanks: 634 times
Was thanked: 379 time(s) in 303 post(s)
CQZ and ITUZ are user-defined fields. So first of all, open the USERFIELDS log form (Forms/Log). This is a diagnostic log screen to help you deal with issues such as this.

You will see something like

CQZ:03/04/05| in the userfields field.

You can't use the REPLACE USER-DEFINED FIELD CONTENTS of tools/advanced/database commands because CQZ and ITUZ are both numeric, and it won't accept 03/04/05 as the old value. But it is still easy to do.

MAKE A BACKUP!

Go to tools/advanced/database commands. Type

USE LOG
REPLACE ALL USERFIELDS WITH STRTRAN(USERFIELDS, "CQZ:03/04/05|", "")
REPLACE ALL USERFIELDS WITH STRTRAN(USERFIELDS, "ITUZ:06/07/08|", "")

Tnx/73,

WN4AZY
1 user thanked WN4AZY for this useful post.
N8VZ on 1/26/2021(UTC)
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.027 seconds.