MARCEDIT-L Archives

June 2020

MARCEDIT-L@LISTSERV.GMU.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Kent A. Eyre" <[log in to unmask]>
Reply To:
MarcEdit support in technical and instructional matters <[log in to unmask]>
Date:
Fri, 5 Jun 2020 12:25:42 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (87 lines)
Hi,

Can someone help me out with the AND NOT OR conditions in the find/replace window.

I know of only two requirements for this function to work (correct me if I am wrong) - 

1. that any NOT condition must be at the beginning, and
2. each condition needs to be in brackets and the conditions capitalised i.e. (...) AND (...) AND (...)

Is there an order in which they are prioritised to get the conditions to work, and is there a limit to how many can be used?

I'm experiencing an issue where three or more AND conditions are not working. I am assuming that all conditions must be met for the replace to occur, but this is not happening for me - in a query of three AND conditions, if only two are met, the replace is performed.

In the following - 

LDR  01670cam a2200325 i 4500
=001  TEST
=003  
=005  
=008  

LDR  01670cam a2200325 i 4500
=001  TEST
=002  
=005  
=008  

LDR  01670cam a2200325 i 4500
=001  TEST
=002
=003  
=005  
=008  

LDR  01670cam a2200325 i 4500
=001  TEST
=003  
=008  


If I use the following replace - 

FIND: TEST
REPLACE: CORRECT
IF (=003) AND (=005) AND (=008)       REGEX


This is the result - 

LDR  01670cam a2200325 i 4500
=001  CORRECT
=003  
=005  
=008  

LDR  01670cam a2200325 i 4500
=001  TEST
=002  
=005  
=008  

LDR  01670cam a2200325 i 4500
=001  CORRECT
=002
=003  
=005  
=008  

LDR  01670cam a2200325 i 4500
=001  CORRECT
=003  
=008  


Why did the fourth record change when it satisfied only two of the criteria (the 003 and the 008) but the second record didn't (while also having two of the criteria, the 005 and the 008)? I am assuming that only the first and the third record should have changed. This unexpected change has led me to think that I am incorrectly using this function.

The ability to perform these sorts of changes is a great addition to MarcEdit and I can see it having a huge impact in reducing the amount of tasks run in my workflows.


Many thanks for any assistance.
Kent Eyre
Resource Librarian.

________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]

ATOM RSS1 RSS2