<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Dear Renate</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><u>Concerning your 2nd question, how to
clean fields with <> chars</u></div>
<div class="moz-cite-prefix">a) prepare a text file, with this
content</div>
<div class="moz-cite-prefix"> <|<br>
>|<br>
and save it with the name xxx.txt</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">b) now you create a gizmo file</div>
<div class="moz-cite-prefix"> mx seq=xxx.txt create=triang now</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">c) Then you apply this gizmo to your
databse</div>
<div class="moz-cite-prefix"> mx your_base create=xxx1 now -all
tell=1000 gizmo=triang,tag1,tag2 ... etc <br>
</div>
<div class="moz-cite-prefix"> where tag1,tag2 are the fileds
concernet, ex: gizmo=triang,12,18,25<br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">d) now you clean your database</div>
<div class="moz-cite-prefix"> mxcp xxx1 create=final clean
tell=1000</div>
<div class="moz-cite-prefix"> ready !!! enjoy it<br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><u>Now , let's see your first
questions, about the conversion of a JSON text file into isis
structure</u></div>
<div class="moz-cite-prefix">You sent me a file with examples, I
copied below the first record</div>
<div class="moz-cite-prefix">Maybe there is some converter out there
(I don't know) but we'd need at least the layout of the record,
with definitions of the labels, then it would be possible to
prepare a conversion procedure to substitute these labels with
appropiate labels like examples below<br>
</div>
<div class="moz-cite-prefix"><font size="+1" face="Courier New,
Courier, monospace">!ID mmmmmm<br>
!vXXX!...contents of tag XXX.............<br>
!vYYY!...contents of tag YYY.............</font><br>
...</div>
<div class="moz-cite-prefix">Then you could use the CISIS program
ID2I to convert the file , but first the first, do you have a
definition of the layout?</div>
<div class="moz-cite-prefix">Regards</div>
<div class="moz-cite-prefix">Ernesto Spinak</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">
<hr width="100%" size="2"><font face="Courier New, Courier,
monospace"><b>JSON RECORD</b><br>
</font></div>
<div class="moz-cite-prefix"><font face="Courier New, Courier,
monospace">{"doi": "10.1080/21645515.2017.1330236", <br>
"year": 2017, <br>
"genre": "journal-article", <br>
"is_oa": true, <br>
"title": "Advancements in DNA vaccine vectors, non-mechanical
delivery methods, and molecular adjuvants to increase
immunogenicity", <br>
"doi_url": <a class="moz-txt-link-rfc2396E" href="https://doi.org/10.1080/21645515.2017.1330236">"https://doi.org/10.1080/21645515.2017.1330236"</a>, <br>
"updated": "2018-06-19T00:17:12.337035", <br>
"publisher": "Informa UK Limited", "z_authors": <br>
[ {"given": "John J.", <br>
"family": "Suschak", <br>
"affiliation": <br>
[ {"name": " U.S. Army Medical Research Institute of
Infectious Diseases, Fort Detrick, MD, USA"} ]<br>
}, <br>
{"given": "James A.", <br>
"family": "Williams", <br>
"affiliation": <br>
[ {"name": " Nature Technology Corporation, Lincoln, NE,
USA"}]}, <br>
{"given": "Connie S.", "family": "Schmaljohn",
"affiliation": [{"name": " U.S. Army Medical Research Institute
of Infectious Diseases, Fort Detrick, MD, USA"}]}], <br>
"journal_name": "Human Vaccines & Immunotherapeutics", <br>
"oa_locations": <br>
[{"url":
<a class="moz-txt-link-rfc2396E" href="http://europepmc.org/articles/pmc5718814?pdf=render">"http://europepmc.org/articles/pmc5718814?pdf=render"</a>, <br>
"pmh_id": "oai:pubmedcentral.nih.gov:5718814", <br>
"is_best": true, <br>
"license": "cc-by-nc-nd", <br>
"updated": "2018-01-22T13:10:35.073612", <br>
"version": "publishedVersion", <br>
"evidence": "oa repository (via OAI-PMH title and first
author match)", <br>
"host_type": <br>
"repository", <br>
"url_for_pdf":
<a class="moz-txt-link-rfc2396E" href="http://europepmc.org/articles/pmc5718814?pdf=render">"http://europepmc.org/articles/pmc5718814?pdf=render"</a>,<br>
"url_for_landing_page":
<a class="moz-txt-link-rfc2396E" href="http://europepmc.org/articles/pmc5718814">"http://europepmc.org/articles/pmc5718814"</a>}], <br>
"data_standard": 2, <br>
"journal_is_oa": false, <br>
"journal_issns": "2164-5515,2164-554X", <br>
"published_date": "2017-06-12", <br>
"best_oa_location": {"url":
<a class="moz-txt-link-rfc2396E" href="http://europepmc.org/articles/pmc5718814?pdf=render">"http://europepmc.org/articles/pmc5718814?pdf=render"</a>, <br>
"pmh_id": "oai:pubmedcentral.nih.gov:5718814", <br>
"is_best": true, <br>
"license": "cc-by-nc-nd", <br>
"updated": "2018-01-22T13:10:35.073612", <br>
"version": "publishedVersion", <br>
"evidence": "oa repository (via OAI-PMH title and
first author match)", "host_type": "repository",
"url_for_pdf":
<a class="moz-txt-link-rfc2396E" href="http://europepmc.org/articles/pmc5718814? pdf=render">"http://europepmc.org/articles/pmc5718814? pdf=render"</a>,<br>
"url_for_landing_page":
<a class="moz-txt-link-rfc2396E" href="http://europepmc.org/articles/pmc5718814">"http://europepmc.org/articles/pmc5718814"</a>}, <br>
"journal_is_in_doaj": false}</font><br>
<br>
<br>
<hr width="100%" size="2"><br>
<br>
<br>
<br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">El 14/03/2019 a las 3:46, Renate
Morgenstern escribió:<br>
</div>
<blockquote type="cite"
cite="mid:9673f038da52bd395c6a72a58eff36d22572c840.camel@iway.na">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div><span>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Calibri, Helvetica, sans-serif; font-size:
16px;">Hi Ernesto,</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Calibri, Helvetica, sans-serif; font-size:
16px;"><br>
</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Calibri, Helvetica, sans-serif; font-size:
16px;">Hope you are doing fine?</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Calibri, Helvetica, sans-serif; font-size:
16px;">Is it possible to convert Jsonl files to ISIS? Please
advise.</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Calibri, Helvetica, sans-serif; font-size:
16px;">I am attaching one so that you can have a look at it.</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Calibri, Helvetica, sans-serif; font-size:
16px;">It contains 2000 records. The whole file contains
more than 100000 records.</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Calibri, Helvetica, sans-serif; font-size:
16px;"><br>
</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Calibri, Helvetica, sans-serif; font-size:
16px;">Secondly, I am cleaning an ISIS database which comes
from Winisis. I want to get rid of the <> around
articles (the, an, an, der, die das, etc) from the title
field.</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Calibri, Helvetica, sans-serif; font-size:
16px;">Example: ^a<The> history of Africa</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Calibri, Helvetica, sans-serif; font-size:
16px;">Is there an mx proc which I could use?</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Calibri, Helvetica, sans-serif; font-size:
16px;"><br>
</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Calibri, Helvetica, sans-serif; font-size:
16px;">Thanks for your help in advance.</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Calibri, Helvetica, sans-serif; font-size:
16px;"><br>
</div>
<pre><span style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif; font-size: 16px;">Renate</span></pre>
<pre>
</pre>
<pre>--
</pre>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<meta name="GENERATOR" content="GtkHTML/4.2.2">
<table width="100%" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td>
Renate Morgenstern<br>
Tel.: +264 61 242124<br>
Cell: +264 81 2910284<br>
Fax: 088637518<br>
Windhoek, Namibia
</td>
</tr>
</tbody>
</table>
</span></div>
</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>