I'm really interested in the answer to this too. It would be really helpful.
Chris
______________________________________________________________________________________________________
Christopher N. Fox | Catalog Librarian | David O. McKay Library, Brigham Young University Idaho | 525 S. Center St. - 0405,
Rexburg, ID 83460-0405 | Tel: (208) 496-9525 | Email: [log in to unmask]
-----Original Message-----
From: MarcEdit support in technical and instructional matters [mailto:[log in to unmask]] On Behalf Of Yu Chun Hsieh
Sent: Thursday, June 9, 2016 12:38 AM
To: [log in to unmask]
Subject: [MARCEDIT-L] Converting formatted content notes (505) to unformatted - Regular Expressions help
Hi Terry & MarcEdit expert,
May I ask for help for converting formatted content notes to unformatted.
An example is:
=505 00$tYour love$g(4:17) --$tThe driver /$r(featuring Dierks Bentley and Eric Pasley)$g(4:34) --$tDancing around it$g(4:38) --$tSouthern accents /$r(featuring Stevie Nicks)$g(4:15) --$tLonely girl$g(2:59) --$tThe only one who gets me$g(3:46) --$tRound in circles$g(4:17) --$tI wish you were here /$r(featuring Miranda Lambert)$g(3:48) --$tLeaving Nashville$g(3:29).
To turn to
=505 0\$aYour love -- The driver / featuring Dierks Bentley and Eric Pasley -- Dancing around it -- Southern accents / featuring Stevie Nicks -- Lonely girl -- The only one who gets me -- Round in circles -- I wish you were here / featuring Miranda Lambert -- Leaving Nashville.
=505 0\$a[Contents]
1) By changing 2nd indicator to from 0 to "\"
2) Removing all subfields ($t, $r, $g)
3) Removing the time in parentheses, for example (4:17), (4:34), (4:38)
4) Removing the parentheses ( ) after /$r but keep featuring bla bla bla , for example /$r(featuring Miranda Lambert) turn to / featuring Miranda Lambert
5) Turning the first subfield into $a
Another example:
=505 00$tReasons for the tears I cry$g(3:54) --$tDown to my last bad habit$g(4:40) --$tMe and my girl$g(3:17) --$tLike my daddy did$g(3:09) --$tMake you feel real good$g(4:11) --$tI can't do this$g(3:27) --$tMy favorite movie$g(3:55) --$tOne more mistake I made /$r(featuring Chris Botti)$g(3:23) --$tTake me down /$r(featuring Little Big Town)$g(5:01) --$tI'll be waiting for you /$r(featuring Cam)$g(3:25) --$tWhen it's love$g(3:46) --$tSad one comin' on (a song for George Jones)$g(3:52).
Any help and suggestions would be greatly appreciated.
Thank you so much.
Regards,
Connie Hsieh
________________________________________________________________________
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]
|