There really isn't away to do the kind of math functions you are asking. This kind of processing would be great as a regex, but regex only does string processing, so there isn't really away to add the kind of logic you are looking for into a search). About the best you could do is drop the seconds from your 300 field -- in which case, that isn't that difficult. Assuming data is regular, you could use an expression that looks something like this in the replace function
Find: (=300.*\$a)(\([0-9]* min)(.*sec\))(.*)
Replace: $1$2)$3
Check regular expression
I'm not somewhere where I can test this, but this should work (with maybe some minor changes).
--tr
-----Original Message-----
From: MarcEdit support in technical and instructional matters [mailto:[log in to unmask]] On Behalf Of Jean Pierre Lupien
Sent: Monday, February 19, 2018 12:07 PM
To: [log in to unmask]
Subject: [MARCEDIT-L] minutes and seconds for music or videos in field 300
Hi,
I don't know if it is possible with MarcEdit 7, but I want to convert minutes and seconds into minutes only in field 300.
For exemple : I have =300 \\$a1 fichier vidéo (05 min 57 sec):$bsonore and I want it to be changed into : =300 \\$a1 fichier vidéo (06 min):$bsonore
Is that feasible ? At least, if it is not possible to change 05 min 57 sec into 6 min is it possible to change it into plain 05 min?
Am I being clear?
Thanks for your help,
Jean Pierre Lupien
Technicien en documentation
Collège Montmorency
Bibliothèque - Catalogage
475, boul. de l'Avenir, Laval (Québec) H7N 5H9 [log in to unmask]
450 975-6280
________________________________________________________________________
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]
________________________________________________________________________
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]
|