<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Courier New \, serif";
panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Courier New \, serif \;";
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML - wstępnie sformatowany Znak";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Tekst dymka Znak";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
color:black;}
span.HTML-wstpniesformatowanyZnak
{mso-style-name:"HTML - wstępnie sformatowany Znak";
mso-style-priority:99;
mso-style-link:"HTML - wstępnie sformatowany";
font-family:Consolas;
color:black;}
span.TekstdymkaZnak
{mso-style-name:"Tekst dymka Znak";
mso-style-priority:99;
mso-style-link:"Tekst dymka";
font-family:"Tahoma","sans-serif";
color:black;}
span.Stylwiadomocie-mail21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.Stylwiadomocie-mail22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.Stylwiadomocie-mail23
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.Stylwiadomocie-mail24
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.Stylwiadomocie-mail25
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.Stylwiadomocie-mail26
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.Stylwiadomocie-mail27
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.Stylwiadomocie-mail28
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.Stylwiadomocie-mail29
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.Stylwiadomocie-mail30
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:953251765;
mso-list-template-ids:1799663236;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=PL link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>THanks a lot!!!!<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>You are great<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>It works <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>God bless you<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>You<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><a name="_MailEndCompose"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></a></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> spinaker [mailto:spinaker@adinet.com.uy] <br><b>Sent:</b> Tuesday, May 01, 2012 8:03 PM<br><b>To:</b> Wieslaw Glinski<br><b>Subject:</b> Re: [Isis-users] change the structure of the CDS/ISIS database<o:p></o:p></span></p></div></div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal>Oops!!<br>sorry, I forgot that part of the procedure!!!!<br>to delete all the mfns with repeated value of V10, but the last one<br>this step is before (4)<br><br>so you should do the following command <o:p></o:p></p><p class=MsoNormal><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New"'>mxcp zzz1 create=zzz2 repeat=% clean</span></b><o:p></o:p></p><p class=MsoNormal>then <o:p></o:p></p><p class=MsoNormal><b><span style='font-size:13.5pt;font-family:"Courier New"'>mx zzz2 "proc=if ref(mfn+1,v10)=s(v10) then 'd.' fi" copy=zzz2 now -all tell=100</span></b><o:p></o:p></p><p class=MsoNormal>then<o:p></o:p></p><p class=MsoNormal><b><span style='font-size:13.5pt;font-family:"Courier New"'>mx zzz2 iso=zzz2.iso now -all tell=100<br>mx iso=zzz2.iso create=final now -all tell=100</span></b><o:p></o:p></p><p class=MsoNormal>Now it works<br>The set of commands are:<o:p></o:p></p><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="100%" align=center></div><ol start=1 type=1><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New"'>mx agwb </span></b><b><span style='font-size:13.5pt;font-family:"Courier New"'><a href="mailto:proc=@subfields.prc"><span lang=EN-US>proc=@subfields.prc</span></a></span></b><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New"'> create=zzz1 now -all tell=100</span></b><o:p></o:p></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>mx zzz1 </span></b><b><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'><a href="mailto:proc=@carryover.prc"><span lang=EN-US>proc=@carryover.prc</span></a></span></b><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> copy=zzz1 now -all tell=100</span></b><o:p></o:p></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif ;","serif"'>mxcp zzz1 create=zzz2 repeat=% clean</span></b><o:p></o:p></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'><b><span style='font-size:13.5pt;font-family:"Courier New"'>mx zzz2 "proc=if ref(mfn+1,v10)=s(v10) then 'd.' fi" copy=zzz2 now -all tell=100</span></b><o:p></o:p></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'><b><span style='font-size:13.5pt;font-family:"Courier New"'>mx zzz2 iso=zzz2.iso now -all tell=100</span></b><o:p></o:p></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'><b><span style='font-size:13.5pt;font-family:"Courier New"'>mx iso=zzz2.iso create=final now -all tell=10</span></b><o:p></o:p></li></ol><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="100%" align=center></div><p class=MsoNormal><br><br>El 01/05/2012 14:20, Wieslaw Glinski escribió: <o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thanks a lot. I downloaded the software it looks cool, many opportunities…</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>So I took another piece of data it worked perfectly very smoothly just as you described me.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>but how to get rid of the MFNs that are the same like mfn 3 and 4 since all are in mfn 5</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>best</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>regards</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> spinaker [<a href="mailto:spinaker@adinet.com.uy">mailto:spinaker@adinet.com.uy</a>] <br><b>Sent:</b> Tuesday, May 01, 2012 3:06 PM<br><b>To:</b> Wieslaw Glinski<br><b>Subject:</b> Re: [Isis-users] change the structure of the CDS/ISIS database</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US>Dear Wes<br><br>OK, we go with the explanation</span><o:p></o:p></p><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="100%" align=center></div><p class=MsoNormal><b><u><span lang=EN-US>// You need the CISIS utilties of (c) Bireme in your PC</span></u></b><span lang=EN-US><br><br>We have a database named agwb, with the structure</span><o:p></o:p></p><p class=MsoNormal><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>mfn= 1</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'> 10 «´╗┐¯ö»¯êÜab┼éo┼ä»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'> 20 «39»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'> 30 «VI»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'> 40 «3»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>..</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>mfn= 2</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼ä»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'> 20 «59»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'> 30 «VI»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'> 40 «3»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>..</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>mfn= 3</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼äa»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'> 20 «54»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'> 30 «VI»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'> 40 «3»</span></b><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>We want to join all records with the same value of v10, into a single records with fields v10,v30,v40 converted in a single filed v100 with subfields, like</span><o:p></o:p></p><p class=MsoNormal><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>mfn= 3</span></b><b><span lang=EN-US><br></span></b><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼äa»</span></b><b><span lang=EN-US><br></span></b><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>100 «^a54^bVI^c3»</span></b><b><span lang=EN-US><br></span></b><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>..</span></b><b><span lang=EN-US><br></span></b><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>mfn= 4</span></b><b><span lang=EN-US><br></span></b><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼äa»</span></b><b><span lang=EN-US><br></span></b><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>100 «^a54^bVI^c3»</span></b><b><span lang=EN-US><br></span></b><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>100 «^a106^bVI^c3»</span></b><b><span lang=EN-US><br></span></b><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>..</span></b><b><span lang=EN-US><br></span></b><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>mfn= 5</span></b><b><span lang=EN-US><br></span></b><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼äa»</span></b><b><span lang=EN-US><br></span></b><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>100 «^a54^bVI^c3»</span></b><b><span lang=EN-US><br></span></b><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>100 «^a106^bVI^c3»</span></b><b><span lang=EN-US><br></span></b><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>100 «^a107^bVI^c3»</span></b><b><span lang=EN-US><br></span></b><b><span lang=EN-US style='font-family:"Courier New , serif","serif"'>..</span></b><o:p></o:p></p><p class=MsoNormal><span lang=EN-US><br>1) first you have to convert a group of fields into a single subfielded field<br> the proc is simple because there are no repeatable fields involved, <br> otherwise the strategy would be more complex.<br><br><b>mx agwb </b></span><b><a href="mailto:proc=@subfields.prc"><span lang=EN-US>proc=@subfields.prc</span></a></b><b><span lang=EN-US> create=zzz1 now -all tell=100</span></b><span lang=EN-US><br><br><b><u>File: subfields.prc</u></b></span><o:p></o:p></p><p class=MsoNormal><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>'d20d30d40'</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>'<100>^a',v20,'^b',v30,'^c',v40,'</100>'</span></b><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>Now you have a dbase zzz1 with contents</span><o:p></o:p></p><p class=MsoNormal><b><span lang=EN-US>mfn= 1<br> 10 «´╗┐¯ö»¯êÜab┼éo┼ä»<br>100 «^a39^bVI^c3»<br>..<br>mfn= 2<br> 10 «¯ö»¯êÜab┼éo┼ä»<br>100 «^a59^bVI^c3»<br>..<br>mfn= 3<br> 10 «¯ö»¯êÜab┼éo┼äa»<br>100 «^a54^bVI^c3»</span></b><o:p></o:p></p><p class=MsoNormal><span lang=EN-US><br>2) the following step is more tricky<br> if field v10 were a common Isis field (char are ascii or ansi, or non graphic Unicode, Utf)<br> you could use the parameter join= of mx, but for this you need a classic Inverted File which fails<br> because the non-standard characters<br> Therefore we had to circumvent this problem using another strategy<br> Also: We have the database ordered by v10, so all the contigous records belong to the same group<br> Otherwise we should to order the database using the command msrt.exe)<br><br> The idea is to browse the database in ascending MFN order and if field v10 or record xx is the same as record xx -1, theN we carry over the data from the previous record and add to the actual record.</span><o:p></o:p></p><p class=MsoNormal><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>mx zzz1 </span></b><b><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'><a href="mailto:proc=@carryover.prc"><span lang=EN-US>proc=@carryover.prc</span></a></span></b><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> copy=zzz1 now -all tell=100</span></b><o:p></o:p></p><p class=MsoNormal><b><u><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>file: carryover.prc</span></u></b><o:p></o:p></p><p class=MsoNormal><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>if ref(mfn-1,v10)=s(v10) then</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> 'd100',</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> '<100>', ref(mfn-1,v100+|%|), '</100>'</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> '<100>', v100, '</100>'</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>fi,</span></b><o:p></o:p></p><p class=MsoNormal><span lang=EN-US><br>In the example, v10 of MFN 3 and 4 are the same, then MFN=4 carry the contents of MFN=3 and places it<br>as the first occ of the field V100. <br>(note: the concatenation of strings with % is a trick to preserve the order)</span><o:p></o:p></p><p class=MsoNormal><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>mfn= 3</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼äa»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a54^bVI^c3»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>..</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>mfn= 4</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼äa»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a54^bVI^c3»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a106^bVI^c3»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>..</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>mfn= 5</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼äa»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a54^bVI^c3%^a106^bVI^c3»</span></b><span lang=EN-US><br></span><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a107^bVI^c3»</span></b><o:p></o:p></p><p class=MsoNormal><span lang=EN-US><br>3) Explode of chains with % as repeatable field and clean file from spaces, etc</span><o:p></o:p></p><p class=MsoNormal><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>mxcp zzz1 create=final repeat=% clean<br><br>mfn= 3<br> 10 «¯ö»¯êÜab┼éo┼äa»<br>100 «^a54^bVI^c3»<br>..<br>mfn= 4<br> 10 «¯ö»¯êÜab┼éo┼äa»<br>100 «^a54^bVI^c3»<br>100 «^a106^bVI^c3»<br>..<br>mfn= 5<br> 10 «¯ö»¯êÜab┼éo┼äa»<br>100 «^a54^bVI^c3»<br>100 «^a106^bVI^c3»</span></b><o:p></o:p></p><p class=MsoNormal><span lang=EN-US><br>4) export the file to an ISO standard</span><o:p></o:p></p><p class=MsoNormal><b><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>mx final iso=nwagb.iso now -all tell=100</span></b><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>ready!!!<br><br>If you find this excercise interesting, I'd appreciate you communicate it to the ISIS list<br>in order to give some feedback to the list and show colleagues that this List works<br><br>Regards from Montevideo<br>Ernesto Spinak<br><br><br><br><br><br><br>El 01/05/2012 9:28, Wieslaw Glinski escribió: </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thanks a lot</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Yes that’s it.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Now how did you do this?</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>If it’s not the secret please tell me. I am asking because there are and will be more data to convert. </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I am trying to make something in PASCAL, but I am afraid it may take a long time… </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Best regards</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> spinaker [</span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'><a href="mailto:spinaker@adinet.com.uy"><span lang=EN-US>mailto:spinaker@adinet.com.uy</span></a></span><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>] <br><b>Sent:</b> Tuesday, May 01, 2012 2:05 PM<br><b>To:</b> Wieslaw Glinski<br><b>Subject:</b> Re: [Isis-users] change the structure of the CDS/ISIS database</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>Wes<br><br>I sent you by error the wrong file, sorry<br>find attached the real one<br>there you will find the repeatable grous as field v100</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>mfn= 4</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼äa»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a54^bVI^c3»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a106^bVI^c3»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>..</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>mfn= 5</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼äa»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a54^bVI^c3»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a106^bVI^c3»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a107^bVI^c3»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>..</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>mfn= 6</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼äa»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a54^bVI^c3»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a106^bVI^c3»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a107^bVI^c3»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a110^bVI^c3»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>..</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>mfn= 7</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼äa»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a54^bVI^c3»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a106^bVI^c3»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a107^bVI^c3»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a110^bVI^c3»</span><span lang=EN-US><br></span><span lang=EN-US style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a111^bVI^c3»</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US><br>Ernesto<br><br><br><br><br>El 30/04/2012 19:45, Wieslaw Glinski escribió: </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I made small mistake in AGWB2, so sending you corrected data once again</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>wes</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> spinaker [</span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'><a href="mailto:spinaker@adinet.com.uy"><span lang=EN-US>mailto:spinaker@adinet.com.uy</span></a></span><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>] <br><b>Sent:</b> Monday, April 30, 2012 10:35 PM<br><b>To:</b> Wieslaw Glinski<br><b>Subject:</b> Re: [Isis-users] change the structure of the CDS/ISIS database</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>Dear wes<br><br>We don't have AlphaIsis, this has not been release, so I don't have access<br>Anyway, I used somo non-orthodox application and I got the file attached<br>Let me know if this is what you need<br><br>Ernesto Spinak<br><br><br><br>El V </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US><br><br><br><br><br></span><o:p></o:p></p><pre><span lang=EN-US>-- </span><o:p></o:p></pre><pre><span lang=EN-US> .^. .^.</span><o:p></o:p></pre><pre><span lang=EN-US> ( ) ( )</span><o:p></o:p></pre><pre><span lang=EN-US> === ===</span><o:p></o:p></pre><pre><span lang=EN-US> =[=]================================[=]=</span><o:p></o:p></pre><pre><span lang=EN-US> | | Ernesto Spinak | |</span><o:p></o:p></pre><pre><span lang=EN-US> | | </span><a href="mailto:spinaker@adinet.com.uy"><span lang=EN-US>spinaker@adinet.com.uy</span></a><span lang=EN-US> | |</span><o:p></o:p></pre><pre><span lang=EN-US> | | Montevideo, Uruguay | |</span><o:p></o:p></pre><pre><span lang=EN-US> | | tel/fax (598) 2622-3352 | |</span><o:p></o:p></pre><pre><span lang=EN-US> | | celular (598) 99612238 | |</span><o:p></o:p></pre><pre> =[=]================================[=]=<o:p></o:p></pre><pre> === ===<o:p></o:p></pre><pre> ( ) ( )<o:p></o:p></pre><pre> V V <o:p></o:p></pre><p class=MsoNormal><br><br><br><br><o:p></o:p></p><pre>-- <o:p></o:p></pre><pre> .^. .^.<o:p></o:p></pre><pre> ( ) ( )<o:p></o:p></pre><pre> === ===<o:p></o:p></pre><pre> =[=]================================[=]=<o:p></o:p></pre><pre> | | Ernesto Spinak | |<o:p></o:p></pre><pre> | | <a href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a> | |<o:p></o:p></pre><pre> | | Montevideo, Uruguay | |<o:p></o:p></pre><pre> | | tel/fax (598) 2622-3352 | |<o:p></o:p></pre><pre> | | celular (598) 99612238 | |<o:p></o:p></pre><pre> =[=]================================[=]=<o:p></o:p></pre><pre> === ===<o:p></o:p></pre><pre> ( ) ( )<o:p></o:p></pre><pre> V V <o:p></o:p></pre><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> spinaker [<a href="mailto:spinaker@adinet.com.uy">mailto:spinaker@adinet.com.uy</a>] <br><b>Sent:</b> Tuesday, May 01, 2012 3:19 PM<br><b>To:</b> Wieslaw Glinski<br><b>Subject:</b> Re: [Isis-users] change the structure of the CDS/ISIS database</span><o:p></o:p></p></div></div><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>Dear Wes<br><br>now you have the procedure, so use it with a clean database<br><br>Regards<br>Ernesto<br><br><br>El 01/05/2012 10:12, Wieslaw Glinski escribió: <o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I check once again. </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Sorry changing the structure of the data should cause the loss of some records (or even most of them) but it did not happened in your database. There are many repetitions of records 3-9 and 13 to 75 . So for example instead of records 13 to 75 there should be only record 75 (since it contains all the instances of the field 100 in records 13 to 74), etc </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>It is because the field 10 repeats as I made in the example of the AGWB and AGWB2. The AGWB has as much as 70records (in most of the the content of the field 10 was repeated many times) when I changed the structure the number of records decreases since the field 10 appears only once and there is a repeatable group of subfields 11^a^b^c. (The content of the fields 20 30 and 40 became the subfields of repeatable group 11.)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Look at the database AGWB and AGWB2</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Best regards</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>wes</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> spinaker [<a href="mailto:spinaker@adinet.com.uy">mailto:spinaker@adinet.com.uy</a>] <br><b>Sent:</b> Tuesday, May 01, 2012 2:05 PM<br><b>To:</b> Wieslaw Glinski<br><b>Subject:</b> Re: [Isis-users] change the structure of the CDS/ISIS database</span><o:p></o:p></p></div></div><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>Wes<br><br>I sent you by error the wrong file, sorry<br>find attached the real one<br>there you will find the repeatable grous as field v100<o:p></o:p></p><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>mfn= 4</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼äa»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a54^bVI^c3»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a106^bVI^c3»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>..</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>mfn= 5</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼äa»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a54^bVI^c3»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a106^bVI^c3»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a107^bVI^c3»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>..</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>mfn= 6</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼äa»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a54^bVI^c3»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a106^bVI^c3»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a107^bVI^c3»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a110^bVI^c3»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>..</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>mfn= 7</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'> 10 «¯ö»¯êÜab┼éo┼äa»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a54^bVI^c3»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a106^bVI^c3»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a107^bVI^c3»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a110^bVI^c3»</span><br><span style='font-size:13.5pt;font-family:"Courier New , serif","serif"'>100 «^a111^bVI^c3»</span><o:p></o:p></p><p class=MsoNormal><br>Ernesto<br><br><br><br><br>El 30/04/2012 19:45, Wieslaw Glinski escribió: <o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I made small mistake in AGWB2, so sending you corrected data once again</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>wes</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> spinaker [<a href="mailto:spinaker@adinet.com.uy">mailto:spinaker@adinet.com.uy</a>] <br><b>Sent:</b> Monday, April 30, 2012 10:35 PM<br><b>To:</b> Wieslaw Glinski<br><b>Subject:</b> Re: [Isis-users] change the structure of the CDS/ISIS database</span><o:p></o:p></p></div></div><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>Dear wes<br><br>We don't have AlphaIsis, this has not been release, so I don't have access<br>Anyway, I used somo non-orthodox application and I got the file attached<br>Let me know if this is what you need<br><br>Ernesto Spinak<br><br><br><br>El V <o:p></o:p></p><p class=MsoNormal><br><br><br><br><br><o:p></o:p></p><pre>-- <o:p></o:p></pre><pre> .^. .^.<o:p></o:p></pre><pre> ( ) ( )<o:p></o:p></pre><pre> === ===<o:p></o:p></pre><pre> =[=]================================[=]=<o:p></o:p></pre><pre> | | Ernesto Spinak | |<o:p></o:p></pre><pre> | | <a href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a> | |<o:p></o:p></pre><pre> | | Montevideo, Uruguay | |<o:p></o:p></pre><pre> | | tel/fax (598) 2622-3352 | |<o:p></o:p></pre><pre> | | celular (598) 99612238 | |<o:p></o:p></pre><pre> =[=]================================[=]=<o:p></o:p></pre><pre> === ===<o:p></o:p></pre><pre> ( ) ( )<o:p></o:p></pre><pre> V V <o:p></o:p></pre><p class=MsoNormal><br><br><br><br><o:p></o:p></p><pre>-- <o:p></o:p></pre><pre> .^. .^.<o:p></o:p></pre><pre> ( ) ( )<o:p></o:p></pre><pre> === ===<o:p></o:p></pre><pre> =[=]================================[=]=<o:p></o:p></pre><pre> | | Ernesto Spinak | |<o:p></o:p></pre><pre> | | <a href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a> | |<o:p></o:p></pre><pre> | | Montevideo, Uruguay | |<o:p></o:p></pre><pre> | | tel/fax (598) 2622-3352 | |<o:p></o:p></pre><pre> | | celular (598) 99612238 | |<o:p></o:p></pre><pre> =[=]================================[=]=<o:p></o:p></pre><pre> === ===<o:p></o:p></pre><pre> ( ) ( )<o:p></o:p></pre><pre> V V <o:p></o:p></pre><p class=MsoNormal><br><br><br><o:p></o:p></p><pre>-- <o:p></o:p></pre><pre> .^. .^.<o:p></o:p></pre><pre> ( ) ( )<o:p></o:p></pre><pre> === ===<o:p></o:p></pre><pre> =[=]================================[=]=<o:p></o:p></pre><pre> | | Ernesto Spinak | |<o:p></o:p></pre><pre> | | <a href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a> | |<o:p></o:p></pre><pre> | | Montevideo, Uruguay | |<o:p></o:p></pre><pre> | | tel/fax (598) 2622-3352 | |<o:p></o:p></pre><pre> | | celular (598) 99612238 | |<o:p></o:p></pre><pre> =[=]================================[=]=<o:p></o:p></pre><pre> === ===<o:p></o:p></pre><pre> ( ) ( )<o:p></o:p></pre><pre> V V <o:p></o:p></pre></div></body></html>