Subject: | |
From: | |
Reply To: | |
Date: | Fri, 5 Jun 2020 12:25:42 -0400 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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]
|
|
|