Jerwyn, your example shows a duplicated callnumber when you have 2 items It's multiplied by the number of items when you have more than 2?
If not, it have always the same structure (4 strings). In that case a clever search and replace using Notepad++ could help you (or Perl) Regards, Bernardo -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Sun, Mar 30, 2014 at 10:15 PM, Jerwyn Fernandez < jerwyn_fernan...@southville.edu.ph> wrote: > Hi Bob, > > I'll be attaching the files again. > > *Any way if you still can't view the attached files I'll be pasting here > the data.* > > *This are the data that I exported in ATHENA:* > > =LDR 00485nam 2200145 a 4500 > =005 20110303132525.0 > =008 100603s19uu\\\\xx\\\\\\\\\\\\00\\\\eng\d > =020 \\$a81-7301--211-3 > =100 \\$aMadaan, Anil > =245 \\$aLearn about computers part 1. > =260 \\$aNew Delhi, India :$bDreamland Pub,$c1997. > =300 \\$a80 > =440 \\$aDreamland's Learn About Computers > =650 \\$aComputer. > =852 \\$p0001$kM$h004$iM26$m1997$bMunich Library Main > Collection$6Books$924950.00Php$7Lib. Fund$820100603$zAGL > > =LDR 00451nam 2200121 a 4500 > =005 20101103145955.0 > =008 100524s19uu\\\\xx\\\\\\\\\\\\00\\\\eng\d > =100 \\$aBryant-Mole, Karen > =245 \\$aI'm happy. > =260 \\$c1998. > =650 \\$aHappy$xJuvenile literature > =852 \\$p0025$kM$h155.4$iB84$m1998$bMunich Library Main > Collection$6Books$7Sch. Fund$820100524$zjmls > =852 \\$p3250$kM$h155.4$iB84$m1998$bMunich Library Main > Collection$6Books$7Sch. Fund$820101103$zjmls > > =LDR 00407nam 2200121 a 4500 > =005 20110303132719.0 > =008 100520s19uu\\\\xx\\\\\\\\\\\\00\\\\eng\d > =100 \\$aBenito, Patricia Pe > =245 \\$aLearning basic programming :$bFor elementary schools. > =260 \\$bPhoenix,$c1994. > =650 \\$aProgramming > =650 \\$aComputer > =852 \\$bMunich Library Main > Collection$h005.1$iB43$m1994$p0007$zjmls$6Books$7Sch. Fund$820100520$kM > > And this are the data when I edited in through MARCedit tool: > > =LDR 00485nam 2200145 a 4500 > =005 20110303132525.0 > =008 100603s19uu\\\\xx\\\\\\\\\\\\00\\\\eng\d > =020 \\$a81-7301--211-3 > =050 \\$aM 004$bM26 1997 > =100 \\$aMadaan, Anil > =245 \\$aLearn about computers part 1. > =260 \\$aNew Delhi, India :$aDreamland Pub,$c1997. > =300 \\$a80 > =440 \\$aDreamland's Learn About Computers > =541 \\$eE0001 > =650 \\$aComputer. > =952 \\$pE0001$aMU$yBK$g24950.00Php$eLib. Fund$d20100603$xAGL$oM 004 M26 > 1997$bMU > > =LDR 00451nam 2200121 a 4500 > =005 20101103145955.0 > =008 100524s19uu\\\\xx\\\\\\\\\\\\00\\\\eng\d > =050 \\$aM 155.4$bB84 1998 B84 1998 > =050 \\$aM 155.4$bB84 1998 B84 1998 > =100 \\$aBryant-Mole, Karen > =245 \\$aI'm happy. > =260 \\$c1998. > =541 \\$eE0025 > =541 \\$eE3250 > =650 \\$aHappy$xJuvenile literature > =952 \\$pE0025$aMU$yBK$eSch. Fund$d20100524$xjmls$oM 155.4 B84 1998 M > 155.4 B84 1998$bMU > =952 \\$pE3250$aMU$yBK$eSch. Fund$d20101103$xjmls$oM 155.4 B84 1998 M > 155.4 B84 1998$bMU > > =LDR 00407nam 2200121 a 4500 > =005 20110303132719.0 > =008 100520s19uu\\\\xx\\\\\\\\\\\\00\\\\eng\d > =050 \\$a005.1 M$bB43 1994 > =100 \\$aBenito, Patricia Pe > =245 \\$aLearning basic programming :$aFor elementary schools. > =260 \\$aPhoenix,$c1994. > =541 \\$eE0007 > =650 \\$aProgramming > =650 \\$aComputer > =952 \\$aMU$pE0007$xjmls$yBK$eSch. Fund$d20100520$o005.1 B43 1994 M$bMU > > **note that I just selected 3 records due to we have thousands of records.* > > Take a look of the data that I edited; as you can see there is no problem > in the 1st record. However on the 2nd and 3rd record there are problems in > callnumbers take a look with the filed of 050$b and 952$o you will see the > problem. > > Thanks, > > - Jerwyn > > > On Sat, Mar 29, 2014 at 5:35 PM, Bob Birchall <b...@calyx.net.au> wrote: > > > Hi Jerwyn, > > The list does not support attachments. Describe the problem verbally or > > provide a click-able link. > > > > Regarding your original problem, using regular expressions to construct > > your 952$o is probably the best way to proceed. At least, it is what we > > do. The alternative is to import the data and manipulate the other > > sub-fields into 952$o afterwards, probably with a small script you would > > develop. > > > > Best wishes, > > Bob Birchall > > Calyx > > > > > > > > On 29/03/14 23:13, Jerwyn Fernandez wrote: > > > >> Hi Vikram, > >> > >> I wonder why you can't still see the attached files. > >> > >> Thank you for your respond, please see attached files. > >> > >> Please let me know if you still can't view the files. > >> > >> Regards, > >> > >> - Jerwyn > >> > >> > >> On Sat, Mar 29, 2014 at 1:23 PM, vikram zadgaonkar < > >> vikramczadgaon...@gmail.com> wrote: > >> > >> Hi, > >>> No attachment in your mail . > >>> In which format do you get data out put from ATHENA? If you can send > >>> sample data to me , I can try and mail you back. > >>> BTW which koha ver you are using? > >>> > >>> Vikram Zadgaonkar > >>> > >>> > >>> On Fri, Mar 28, 2014 at 7:12 AM, Jerwyn Fernandez < > >>> jerwyn_fernan...@southville.edu.ph> wrote: > >>> > >>> Good day! > >>>> > >>>> > >>>> We are currently migrating our system ATHENA to KOHA. > >>>> > >>>> > >>>> ATHENA holds data in 852 and on the other part KOHA holds data in > 952. I > >>>> used MarcEdit tool to edit the data. I was able to edit it somehow > >>>> however; > >>>> when I upload the data to KOHA I notice there are problems in > >>>> callnumber. > >>>> > >>>> > >>>> ATHENA holds the data of callnumber in 852 $kPrefix $hMain $iCutter > >>>> $mSuffix a > >>>> > >>>> KOHA holds the data of callnumber in 952 $ofull callnumber > >>>> > >>>> > >>>> I do have a problem for those data that I exported in ATHENA that has > >>>> *"multiple > >>>> > >>>> items on a single record and to those subfileds that are not properly > >>>> arranged".* > >>>> > >>>> > >>>> > >>>> > >>>> One of the attached file is the data that I exported to ATHENA, I just > >>>> selected 3 records due to we have thousands of records. > >>>> > >>>> > >>>> > >>>> And the other attached file is the data that I was able to edit please > >>>> check it. > >>>> > >>>> > >>>> > >>>> Is there anyone can help me with my problem? I heard that several > >>>> libraries > >>>> was successfully done this, some used regular expression and to be > >>>> honest > >>>> I'm not very particular with it. > >>>> > >>>> > >>>> > >>>> Hopefully I came in to the right place to answer my query. > >>>> > >>>> > >>>> > >>>> Thank you and best regards, > >>>> > >>>> -- > >>>> Jerwyn G. Fernadez > >>>> Basic Education Librarian > >>>> Southville International School and Colleges > >>>> > >>>> _______________________________________________ > >>>> Koha mailing list http://koha-community.org > >>>> Koha@lists.katipo.co.nz > >>>> http://lists.katipo.co.nz/mailman/listinfo/koha > >>>> > >>>> > >>>> > >> > >> > >> _______________________________________________ > >> Koha mailing list http://koha-community.org > >> Koha@lists.katipo.co.nz > >> http://lists.katipo.co.nz/mailman/listinfo/koha > >> > > > > -- > > Bob Birchall > > Director > > Calyx Group Pty Limited > > > > Mob: 0414 796 988 > > Email: b...@calyx.net.au > > Web: www.calyx.net.au > > > > Participating in the Koha Open ILS project: > > http://koha-community.org > > > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > -- > Jerwyn G. Fernadez > Basic Education Librarian > Southville International School and Colleges > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha