Mass Change Issue - All Other

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

Notification

Error

LOGic Forum » LOGic Support » All Other » Mass Change Issue

Mass Change Issue

Options View

Previous Topic Next Topic

N8VZ		#1 Posted : Monday, January 25, 2021 1:18:33 PM(UTC)
Rank: Advanced Member Groups: Registered, Beta Testers Posts: 40 Location: EM89wh Thanks: 2 times Was thanked: 2 time(s) in 2 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
Back to top		WWW

User Profile View All Posts by User View Thanks
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
Back to top

WN4AZY		#2 Posted : Monday, January 25, 2021 10:08:32 PM(UTC)
Rank: Administration Groups: Administrators, Beta Testers Posts: 3,097 Location: Auburn, GA Thanks: 998 times Was thanked: 497 time(s) in 412 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
Back to top		WWW \| Edit by user
1 user thanked WN4AZY for this useful post.		N8VZ on 1/26/2021(UTC)
User Profile View All Posts by User View Thanks

Users browsing this topic
Guest

LOGic Forum » LOGic Support » All Other » Mass Change Issue

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.