<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">Egbert</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">your solution could work, but there is
another problem to take care</div>
<div class="moz-cite-prefix">that field v10 is repeatable</div>
<div class="moz-cite-prefix">therefore the problem is to implement
repeatable loops into repeatable fields</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">but this solution can be a begining</div>
<div class="moz-cite-prefix">regard</div>
<div class="moz-cite-prefix">Ernesto</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">El 27/10/2021 a las 3:47, Egbert De
Smet escribió:<br>
</div>
<blockquote type="cite"
cite="mid:ff212088df7e4998a7511df503480460@uantwerpen.be">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css" style="display:none;">P {margin-top:0;margin-bottom:0;}</style>
<div id="divtagdefaultwrapper"
style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;"
dir="ltr">
<p>[forwarded]</p>
<p><br>
</p>
<div id="Signature">
<div class="BodyFragment"><font size="2"><span
style="font-size:10pt;">
<div class="PlainText"><span style="font-family:
Calibri, Helvetica, sans-serif; font-size: 12pt;">Hi,</span><br>
</div>
</span></font></div>
</div>
<div style="color: rgb(0, 0, 0);">
<div>
<div id="divtagdefaultwrapper" dir="ltr"
style="font-size:12pt; color:#000000;
font-family:Calibri,Helvetica,sans-serif">
<p><br>
</p>
<p>if you are prepared to apply the modifications in a
terminal window, you could use a 'proc' parameter with
the CISIS-executable 'mx'.</p>
<p>For both the WinISIS and the JISIS data you would first
have to export them to an ISO-format, the resulting
records can be exported in their turn to ISO again and
then imported in either WinISIS or JISIS.</p>
<p><br>
</p>
<p>So, starting from an ISO2709 export of your data, in a
terminal window you have to issue the following
commands, with the mx-executable (available in the
cgi-bin folder of ABCD or from other sources) available
in the work-folder where you have the ISO-export named
'before.iso' : </p>
<p>mx iso=before iso create=before now -all</p>
<p>mx before <a class="moz-txt-link-abbreviated" href="mailto:proc=@replacesf.proc">proc=@replacesf.proc</a> create=after now -all</p>
<p>mx after iso=after.iso now -all</p>
<p><br>
</p>
<p>Then the file 'after.iso' is the result and these
records can be imported into your database.</p>
<p><br>
</p>
<p>The actual trick is in the process (proc) which is
executed by mx and listed here : </p>
<div>======</div>
<div>'d10',</div>
<div> s1:=(s(v10)),</div>
<div> e1:=size(s1),</div>
<div> e2:=1,</div>
<div> s2:=(''),</div>
<div>/* sequence of subfields : vdpk */</div>
<div> while e2<=e1</div>
<div> (</div>
<div> if mid(s1,e2,1) : s(';') then</div>
<div> if s2 : '^p' then s2:=(s2,'^k') else</div>
<div> if s2 : '^d' then s2:=(s2,'^p') else</div>
<div> if s(s2) : '^v' then s2:=(s2,'^d') else</div>
<div> s2:=(s2,'^v'),</div>
<div> fi,</div>
<div> fi,</div>
<div> fi,</div>
<div> else s2:=(s2,mid(s1,e2,1)),</div>
<div> fi,</div>
<div> e2:=e2+1,</div>
<div> )</div>
<div> '<10>',s2,'</10>',</div>
<div>=====</div>
<div><br>
</div>
<div>Copy/paste this code into a file 'replacesf.proc' and
put it in the same work-folder. </div>
If you feel it being too complicated, send me the
ISO-export of your data and I can do it (in fact in a few
seconds time...).
<p><br>
</p>
<div id="Signature">
<div class="BodyFragment"><font size="2"><span
style="font-size:10pt">
<div class="PlainText">Egbert de Smet<br>
Universiteit Antwerpen</div>
</span></font></div>
</div>
<br>
<br>
<div style="color:rgb(0,0,0)">
<hr tabindex="-1" style="display:inline-block;
width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font
style="font-size:11pt" face="Calibri, sans-serif"
color="#000000"><b>From:</b> Amjad Ali Malik
<a class="moz-txt-link-rfc2396E" href="mailto:amjadalimalik66@hotmail.com"><amjadalimalik66@hotmail.com></a><br>
<b>Sent:</b> Tuesday, October 26, 2021 5:27 PM<br>
<b>To:</b> Egbert De Smet<br>
<b>Subject:</b> Re: Splitting a Field</font>
<div> </div>
</div>
<div>
<div style="background-color:#FFEB9C; width:100%;
border-style:solid; border-color:#9C6500;
border-width:1pt; padding:2pt; font-size:10pt;
line-height:12pt; font-family:'Calibri';
color:Black; text-align:left">
<span style="color:#9C6500; font-weight:bold">CAUTION:</span>
This email originated from outside of the
organization. Do not click links or open attachments
unless you recognize the sender and know the content
is safe.</div>
<br>
<div>
<div
style="font-family:Calibri,Helvetica,sans-serif;
font-size:12pt; color:rgb(0,0,0)">
Dear Egbert,</div>
<div
style="font-family:Calibri,Helvetica,sans-serif;
font-size:12pt; color:rgb(0,0,0)">
The sequence of subfields is fixed, The ';' is
need to be replaced with any subfield character(s)
in an algorithm sequentially 1st, 2nd , 3rd.....
& I am using Winisis & JISIS<br>
</div>
<div
style="font-family:Calibri,Helvetica,sans-serif;
font-size:12pt; color:rgb(0,0,0)">
Regards </div>
<hr tabindex="-1" style="display:inline-block;
width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font
style="font-size:11pt" face="Calibri,
sans-serif" color="#000000"><b>From:</b> Egbert
De Smet <a class="moz-txt-link-rfc2396E" href="mailto:egbert.desmet@uantwerpen.be"><egbert.desmet@uantwerpen.be></a><br>
<b>Sent:</b> Tuesday, October 26, 2021 6:44 PM<br>
<b>To:</b> Amjad Ali Malik
<a class="moz-txt-link-rfc2396E" href="mailto:amjadalimalik66@hotmail.com"><amjadalimalik66@hotmail.com></a>;
<a class="moz-txt-link-abbreviated" href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a>
<a class="moz-txt-link-rfc2396E" href="mailto:isis-users@iccisis.org"><isis-users@iccisis.org></a><br>
<b>Subject:</b> Re: Splitting a Field</font>
<div> </div>
</div>
<div dir="ltr">
<div id="x_divtagdefaultwrapper" dir="ltr"
style="font-size:12pt; color:#000000;
font-family:Calibri,Helvetica,sans-serif">
<p>Hi,</p>
<p><br>
</p>
<p>the problem I see is how to do this if the
sequence of subfields is not fixed : how do we
know which ';' to replace by which subfield
'vdpk' ?</p>
<p>I can imagine it is possible if the sequence
is fixed, but if it is not no way to do it. In
principle in ISIS the sequence of subfields is
not by definition fixed, e.g. ^b can come
before ^a etc. </p>
<p>In ABCD there is in the FDT a column
'pre-literals' which is meant to match a
separator in some input string to subfields.
But again the sequence will need to be fixed.</p>
<p> </p>
<div id="x_Signature">
<div class="x_BodyFragment"><font size="2"><span
style="font-size:10pt">
<div class="x_PlainText">Egbert de Smet<br>
Universiteit Antwerpen</div>
</span></font></div>
</div>
<br>
<br>
<div style="color:rgb(0,0,0)">
<hr tabindex="-1" style="display:inline-block;
width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font
style="font-size:11pt" face="Calibri,
sans-serif" color="#000000"><b>From:</b>
isis-users
<a class="moz-txt-link-rfc2396E" href="mailto:isis-users-bounces+egbert.desmet=ua.ac.be@iccisis.org"><isis-users-bounces+egbert.desmet=ua.ac.be@iccisis.org></a>
on behalf of Amjad Ali Malik
<a class="moz-txt-link-rfc2396E" href="mailto:amjadalimalik66@hotmail.com"><amjadalimalik66@hotmail.com></a><br>
<b>Sent:</b> Tuesday, October 26, 2021
3:25 PM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a><br>
<b>Subject:</b> [Isis-users] Splitting a
Field</font>
<div> </div>
</div>
<div>
<div style="background-color:#FFEB9C;
width:100%; border-style:solid;
border-color:#9C6500; border-width:1pt;
padding:2pt; font-size:10pt;
line-height:12pt; font-family:'Calibri';
color:Black; text-align:left">
<span style="color:#9C6500;
font-weight:bold">CAUTION:</span> This
email originated from outside of the
organization. Do not click links or open
attachments unless you recognize the
sender and know the content is safe.</div>
<br>
<div>
<div
style="font-family:Calibri,Helvetica,sans-serif;
font-size:12pt; color:rgb(0,0,0)">
Dear Experts,</div>
<div
style="font-family:Calibri,Helvetica,sans-serif;
font-size:12pt; color:rgb(0,0,0)">
<br>
<div>I want to split a field into
subfields having data stored as</div>
<div><br>
</div>
<div> Source --><span
style="font-size:12pt"> </span><span
style="font-size:12pt"><b>v10 =
^m256;12;103;;^i10242020</b></span></div>
<div><br>
</div>
<div><span
style="background-color:rgb(255,255,255);
display:inline!important">Target
--></span><span
style="background-color:rgb(255,255,255);
display:inline!important;
font-size:12pt">
</span><span
style="background-color:rgb(255,255,255);
display:inline!important;
font-size:12pt"><b>v10 =
^m256^v12^d103^p^k^i10242020</b></span><br>
</div>
<div><br>
</div>
<div>How it will be accomplished.</div>
<div><br>
</div>
<div>Regards</div>
Amjad Ali Malik<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
isis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a>
To manage your own subscription options go to: <a class="moz-txt-link-freetext" href="http://lists.iccisis.org/listinfo/isis-users">http://lists.iccisis.org/listinfo/isis-users</a>
Or contact Henk Rutten: <a class="moz-txt-link-abbreviated" href="mailto:hlrutten@xs4all.nl">hlrutten@xs4all.nl</a>
</pre>
</blockquote>
<p><br>
</p>
<pre class="moz-signature" cols="72">--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | <a class="moz-txt-link-abbreviated" href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a> | |
| | Montevideo, Uruguay | |
| | tel/fax (598) 2622-3352 | |
| | celular (598) 99612238 | |
=[=]================================[=]=
=== ===
( ) ( )
V V </pre>
</body>
</html>