Assuming that you are 'stuck' with the existing export
file, this really begs for the use of generic text-editing
tools. You could use such tools (say, a text editor or
scripting language like perl or python) to convert the file
to marc-breaker text format and then use marcedit, or you
could simply use the tools directly.
This, for example, is a bare-bones-simple perl script that
if applied to your file(s) and redirected to an output file,
should extract the fields you want in tab-delimited format:
$/ = " FMT " ;
while (<>) {
while (s,([0-9]+) 24500 +L (.+),,) { print "\n$1\tMARC245::$2" ; }
while (s,([0-9]+) 690FC +L (.+),,) { print "\tMARC690FC::$2" ; }
while (s,([0-9]+) 909A +L (.+),,) { print "\tMARC909A::$2" ; }
}
(save as "extract_fields.pl" ; run as perl .\extract_fields.pl marcfile.txt > outputfile.txt)
(Perl specialists please pardon.)
I added explicit labels to the output fields ("MARC690FC" etc., but you can
of course remove those. And it should be easy enough to convert to CSV if
you prefer. I just tried this on your two sample records, and it
produced this result:
006658043 MARC245::$$aDialogue$$bmagazine de la Banque cantonale de Genève MARC690FC::$$aKantonalbank$$vFortlaufende Publikationen$$2SWA MARC909A::$$fSachdokDigi MARC909A::$$fdoksF
002444903 MARC245::$$a[Freiwillige Prediger-Witwen- und Waisenkasse - Basel$$pDokumentensammlung] MARC690FC::$$aBetriebliche Altersversorgung$$2SWA MARC690FC::$$aGeistliche$$2SWA MARC909A::$$fdoksF
pfs
--
Paul Schaffner | [log in to unmask] | http://secure-web.cisco.com/1KrHDXevqWNCm6-_Jbt6VXOieAr_WNbw_VU7CPl0ykyZ8ldZw0BlQLTqgGi_cLj425t4PBGwDyc9pd7z1_IZj18aqYh59QAbWteY1rwQvpoUKBMEWY0plsTSSlshQYInaVntXBkqwbqLUPvosz37yrbsvT2FsiXLdX0uWrcJ8E-UvUlmyeuwKTg-6HeDVFgxp5eMXa4J9yq4ZXm3C0mT80A88e94B9Dz1HZViuT5t-KnXP1UTj29VtIVQSP-KEnyo5vzFXXNrl3uYGHNTTJ1dcip1X2aA8I8aXNTi77US9GZc-QRW1tstlrE1seoHTzwLl3LCzd-RdcsBLYtrYpPxuMZxxjIlQGi4ehkhhCR-w0W5ZoHPGZB3RqO84IEC8egxUBMdGjjZ3TN7KCQdsp3fcg/http%3A%2F%2Fwww.umich.edu%2F%7Epfs%2F
Digital Content & Collections, University of Michigan Library
On Thu, Apr 12, 2018, at 08:20, Linda Seguin wrote:
> That file is in "Aleph Sequential Format" not MARC format. If it were MARC
> and you opened it with a text reader it would not be nearly so readable.
> The whole file would be one continuous line and all of the tag numbers
> would be separated from the field contents.
>
> Records can be downloaded from Aleph using the print-03 service but the
> format, MARC, must be selected. Aleph Sequential format is the
> default. Alternatively,
> you could use the MarcEdit Z39.50/SRU Client to retrieve MARC records from
> your Aleph system.
>
>
> Linda Seguin, Systems Librarian
> Consortial Library Applications Support
> University of Maryland Libraries
> McKeldin Library, Room B0235
> 7649 Library Ln., College Park, MD 20742
> phone: 301-314-9541 | fax: 301-314-8100 | email: [log in to unmask]
>
> On Thu, Apr 12, 2018 at 5:51 AM, Sorin Marti <[log in to unmask]> wrote:
>
> > Hi,
> >
> > I am very new to MARC and everything connected to it and the following may
> > be a beginner question. I have not found a solution to my problem online,
> > so I hope one of you may help me.
> >
> > What I have:
> > - I received a text file which represents an export of a number of entries
> > from an Aleph system.
> > - It is (as far as I can tell) in the MARC format. Following is the
> > beginning of the file. I understand these are the first two entries:
> >
> > 006658043 FMT L SE
> > 006658043 LDR L 00677nas--22001938c-4500
> > 006658043 001 L 006658043
> > 006658043 007 L cr------------
> > 006658043 008 L 950424c20uu9999sz----p-------0-----fre-d
> > 006658043 040 L $$aSzZuIDS BS/BE A125$$bger$$ekids
> > 006658043 072 7 L $$awi$$2SzZuIDS BS/BE
> > 006658043 24500 L $$aDialogue$$bmagazine de la Banque cantonale de Genève
> > 006658043 24613 L $$aBCGE dialogue$$iZitiertitel
> > 006658043 264 1 L $$aGenève$$bBCG
> > 006658043 300 L $$aOnline-Ressource
> > 006658043 310 L $$a2-3x par an
> > 006658043 336 L $$aText$$btxt$$2rdacontent
> > 006658043 337 L $$aComputermedien$$bc$$2rdamedia
> > 006658043 338 L $$aOnline-Ressource$$bcr$$2rdacarrier
> > 006658043 655 7 L $$aZeitschrift$$2gnd-content
> > 006658043 690FC L $$aKantonalbank$$vFortlaufende Publikationen$$2SWA
> > 006658043 7102 L $$aBanque cantonale de Genève$$1(DE-588)5248596-1
> > 006658043 7300 L $$aDialogue (Banque cantonale de Genève)
> > 006658043 77608 L $$iDruck-Ausgabe$$tDialogue$$w002442129
> > 006658043 906 L $$bZeitschrift = Revue
> > 006658043 907 L $$gCF Elektron. Daten Fernzugriff=Fichier online
> > 006658043 909A L $$fSachdokDigi
> > 006658043 909A L $$fdoksF
> > 006658043 CAT L $$aB-FUE$$b40$$c20161227$$lDSV01$$h1147
> > 006658043 CAT L $$aBATCH-UPD$$b40$$c20170220$$lDSV01$$h1700
> > 006658043 CAT L $$ap-load-18$$b$$c20171226$$lDSV01$$h1722
> > 006658043 856 L $$uhttp://secure-web.cisco.com/1c-cH9ugP4IDRHfj-8O9R-hsE_PsNOq1bOe0qtPyZuv6kBbvR94I9OF2qPBXkc-vzhQX8Z0IoJ-jqBKh6cdqzYw1ZWe1MmQLHyG5_0UbgqutNoZXa8MC8fKE26gJPQCuQrLNvB33NLCIZYnyQZFl_GUNV1ZC3mjaBZzQvMi6S-z0OIXrexTPOd4DiksXfV82LvcfAtCZDr4Os5pV9Xrwoc465VqH6vY0rYcxM8wrt2jv0JLVKFXMn0wNvppbeg8yaKfWFO-g7EFjDt71-ZDOhfx0YDbkemsKfSPROM7Wc3MdfL4wBD3Xl0zKX925m7QWJtUtLLm0ThvLMvSHDQj2MxS4_c8bYu5rIK1jeTWkDB0idEr0YGChdVWa7bvKk2Sexha-KKDmxkRDPuv380BYm7q4hi9o1coT-RmF33oj98aDUIMensvO8tZiDovm6LUkkcA1ftpALw92XCqYi_YNdFA/http%3A%2F%2Fwww.ub.unibas.ch%2Fub-wirtschaft-swa%2Fswadok%2F
> > 002442129$$zOnlinezugriff
> > <http://secure-web.cisco.com/1jEjChmDG3mLwecugF-C6kMIYKNTRey1D72RQQnt-wZbtIM8T4LfAZPZOgUWaaq_1nWHSOIllVy-wsrizKtAgvhu5bPVh-RiNwAywrT9kZyDyhcLwQ1Ucd89uibNMw3pRQclAoiULgJT0KqgmAg5_T7vvCz-fj9wHOqWQLT3tP7sgGpKq3wfzoSUYva-Wic-kpOahPr5wkARZeW88SpxCqqod95V6MYGluRGn9_OUQ3cdnB5qMT4djk09K_TxsaoI5NW87YvTgrBcJLdbzowGQlEXDbJahENwZ4u5cpSvQRFBUIZHGwZxfY_2nW5ZKvMhRWgSjSpmV-56z_q8oTvzgKBVPcYZUVxnd2ZAZZ5jEE3tHECj-MOMA72SFgxeYVk05UKhkkzhl40B0Z9Lvq5UWn18lQ32YrJc8SGuvyIActUFTIWlWcG5cUh5T6Eg27jBsbfIuMV7s9zkfBoezScBdA/http%3A%2F%2Fwww.ub.unibas.ch%2Fub-wirtschaft-swa%2Fswadok%2F002442129%24%24zOnlinezugriff>
> > auf Volltext, archiviert von Basel UB Wirtschaft - SWA
> > (2015-)$$x21.07.2015/A125/fue
> > 006658043 856 L $$uhttp://secure-web.cisco.com/1pfuL3CpJQnwL4nf74e-ptCMqiOfA4UJ4Rn8y3oUtKY01KYec5mH_Lag1yBuVjUmxn0JhnfDoW7Z0FDn45JmFAZpufp2NlwCoT4EtoCKxG6f4psp5jniRvB68r3WZ8aBtDevhc3IJtucncZuClzLCaBIAlN73Eq2tUqhGSYyQt2VoXOCK65jRbKO0UF1L8qyno12u84NdDTET9ehlslAZ1dX0tUXfuN-JMgUlqXmyj515iFJlRiRFSC6nk7ggUe4WTBISvmmardkoO7gDEvyQRSlQVRW0QygrO-BQeH0HvH9CovWyVJonReM82GLQNaXR1TXDleJSovcMv6RJ-GL3uDFBdFP1qbeZNUTQ8o8olEZPHnchgrnpTJOrFoG5BYHmpaJDwl62ednts3b8vadGUs6JI-W07AAB_F4-ylILNRSYSgZkiM30WlWy-E1h39Ojp2d8GEk8_gmh_6LPMeyXDw/http%3A%2F%2Fwww.bcge.ch%2Findex.php%3FSubMenu%3Dapropos%26
> > SubSubMenu=publications&SubSubSubMenu=actuelles&label_
> > x=txtpublicationbcgenew&lang=fr&commun=1$$zVolltext$$x13.12.2010/A125/fue
> > <http://secure-web.cisco.com/1dmMNUUiwSczLIiZYAnYewxSxKrIZLDE_v1O8jwiwowYWvn7xJvClT9Z1AX1UZOqDDPSqGclI33fxlkwSwUV5hub7-TdFKlLBVYfRjMKC8RO5cDCrNUaquzdQHNrltihkIvg1wOXmiC2sAQJISKDVPKFnUwSLBqyUTOCJclDQdvBvx-PWEXmWujkKrjw6dQWca4Mg8JK7Ssz3j1mvgGLK5Zq6JWeNux-6IxhesGA59rJE5I_JY0qEdLeZunSiKveolvSIPd-wLjj7KvsacYKwXeAFR54sDtp-LIwwCu66i7r2H7DIq4kTSyl2hGolgzFTaPC9tq6cvLFehEh2twS-O0Ht6fE-VFGg41v-A1nP3JjgK0ptL4rep9Wm4BOlq7xwkSU960pqolA9R_I0VE0fEkhcmdjee1SuWLkJBB0qMoCx-25pPWlo-l4vxPOZFU2XzhokRW5iCqxZBQsB45o9Jw/http%3A%2F%2Fwww.bcge.ch%2Findex.php%3FSubMenu%3Dapropos%26SubSubMenu%3Dpublications%26SubSubSubMenu%3Dactuelles%26label_x%3Dtxtpublicationbcgenew%26lang%3Dfr%26commun%3D1%24%24zVolltext%24%24x13.12.2010%2FA125%2Ffue>
> > 002444903 FMT L BK
> > 002444903 LDR L -----nac--22-----4c-4500
> > 002444903 008 L 020114m17771942sz------------00----ger--
> > 002444903 040 L $$aSzZuIDS BS/BE A125$$ekids
> > 002444903 072 7 L $$a-$$2SzZuIDS BS/BE
> > 002444903 24500 L $$a[Freiwillige Prediger-Witwen- und Waisenkasse -
> > Basel$$pDokumentensammlung]
> > 002444903 264 1 L $$a[Var.loc.]$$c1777-1942
> > 002444903 300 L $$a1 Schachtel (0,06 m)
> > 002444903 336 L $$aText$$btxt$$2rdacontent
> > 002444903 337 L $$aohne Hilfsmittel zu benutzen$$bn$$2rdamedia
> > 002444903 338 L $$aBand$$bnc$$2rdacarrier
> > 002444903 520 L $$aStatuten, Geschäftsordnung (1838-1942); Jahres- sowie
> > Geschäftsberichte (1777-1927) [unvollst.] [Finanzwesen, Bilanzen];
> > Werbezirkulare, Suscriptionsscheine (1777-1820) [Versicherungswesen/
> > Versicherungswirtschaft/Versicherungen/Versicherung/Sozialversicherungen/
> > Sozialversicherung/Pensionskasse/Pensionsversicherung/
> > Hinterbliebenenversicherung/Witwen/Witwe/Waisen/Waise/Soziale
> > Situation/Sozialverhältnisse/Arbeits- und Personalverhältnisse/Pfarrer/Kirche/Betriebliche
> > Vorsorge/Betriebliche Fürsorge/Betriebliche Wohlfahrt/Berufliche Vorsorge
> > Schweiz (Basel-Stadt/Kanton)]$$514.01.2002/bs-swa/op
> > 002444903 690FC L $$aBetriebliche Altersversorgung$$2SWA
> > 002444903 690FC L $$aGeistliche$$2SWA
> > 002444903 7102 L $$aFreiwillige Prediger-Witwen- und
> > Waisenkasse$$gBasel$$1(DE-588)1085719227
> > 002444903 909A L $$fdoksF
> > 002444903 CAT L $$aOP$$b40$$c20020114$$lDSV01$$h1654
> > 002444903 CAT L $$c20030625$$lDSV01$$h1611
> > 002444903 CAT L $$c20060403$$lDSV01$$h0627
> > 002444903 CAT L $$aOP$$b40$$c20080129$$lDSV01$$h1014
> > 002444903 CAT L $$aOP$$b40$$c20080917$$lDSV01$$h0928
> > 002444903 CAT L $$aOP$$b40$$c20100210$$lDSV01$$h1401
> > 002444903 CAT L $$aOP$$b40$$c20101229$$lDSV01$$h1458
> > 002444903 CAT L $$aOP$$b40$$c20111115$$lDSV01$$h1051
> > 002444903 CAT L $$aOP$$b40$$c20111122$$lDSV01$$h0951
> > 002444903 CAT L $$aP18-Batch$$b$$c20140506$$lDSV01$$h1940
> > 002444903 CAT L $$aOP$$b40$$c20140721$$lDSV01$$h1439
> > 002444903 CAT L $$aOP$$b40$$c20140826$$lDSV01$$h1359
> > 002444903 CAT L $$aOP$$b40$$c20141209$$lDSV01$$h1545
> > 002444903 CAT L $$aOP$$b40$$c20141211$$lDSV01$$h1452
> > 002444903 CAT L $$aP18-Batch$$b$$c20160320$$lDSV01$$h0826
> > 002444903 CAT L $$aBATCH$$b00$$c20160326$$lDSV01$$h0917
> > 002444903 CAT L $$aBATCH$$b00$$c20160401$$lDSV01$$h0315
> >
> > What I like to do:
> > - I would like to extract a number of fields for each entry in this file.
> > Most important are the fields 24500, 909A and 690FC
> > - In the end I'd like to save this information in a CSV or Excel file.
> > - Approximately like so:
> >
> > 006658043;Dialogue;doksF;Kantonalbank
> > 002444903;Freiwillige Prediger-Witwen- und Waisenkasse - Basel;doksF;Betriebliche
> > Altersversorgung
> >
> > What I tried:
> > - I am using MARCEdit, Version 7.0.26 on Windows 10
> > - I tried to do the conversion with MarcMaker but I get an error every time
> >
> >
> >
> > Can anyone direct me to the right direction?
> >
> > Thanks in advance for reading and commenting.
> >
> > - Sorin
> >
> > ________________________________________________________________________
> >
> > 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 MARCEDIT-L-
> [log in to unmask] To unsubscribe, send a message "SIGNOFF
> MARCEDIT-L" to [log in to unmask]
> Email had 1 attachment:
> + image.png
> 21k (image/png)
--
Paul Schaffner UM Library : Digital Content & Collections
[log in to unmask] | http://secure-web.cisco.com/1KrHDXevqWNCm6-_Jbt6VXOieAr_WNbw_VU7CPl0ykyZ8ldZw0BlQLTqgGi_cLj425t4PBGwDyc9pd7z1_IZj18aqYh59QAbWteY1rwQvpoUKBMEWY0plsTSSlshQYInaVntXBkqwbqLUPvosz37yrbsvT2FsiXLdX0uWrcJ8E-UvUlmyeuwKTg-6HeDVFgxp5eMXa4J9yq4ZXm3C0mT80A88e94B9Dz1HZViuT5t-KnXP1UTj29VtIVQSP-KEnyo5vzFXXNrl3uYGHNTTJ1dcip1X2aA8I8aXNTi77US9GZc-QRW1tstlrE1seoHTzwLl3LCzd-RdcsBLYtrYpPxuMZxxjIlQGi4ehkhhCR-w0W5ZoHPGZB3RqO84IEC8egxUBMdGjjZ3TN7KCQdsp3fcg/http%3A%2F%2Fwww.umich.edu%2F%7Epfs%2F
________________________________________________________________________
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]
|