[Isis-users] Creating database from csv file - unique names

[spinaker]

Dear Renate

There is simple and effective way to get a clean list of terms without 
duplicates using Cisis utitlies from the command line

*mxtb *is a tabulator, i.e. it can extract all different instances of a 
data (see the manual)

I'll do an example using a marc database, to get an author list
authors are recorded in v100^a and v700^a (repeatable)
so the line would be
*
mxtb marc create=author  "100:v100^a/(v700^a/)" class=2000 tell=100*
it will get out something like

*mxtb: 5100 recs in
       1230 tabs
       860 recs out*

just in case you have an error return, like the following line,
*fatal: mxtb/maxhash overflow*
the problem is that you have more than 2000 intances, then you increase 
the numer to class=3000 or 10000 or ...etc

The author database has three fields like the example, one record for 
each different key
*mx author
mfn=     1
   1  «Leite, José Alfredo A. (José Alfredo Américo).»
998  «999999998»
999  «1»*

then you export the unique names
*mx author "proc='d998d999'" iso=author.iso now -all tell=100*

mxtb is case sensitive

Enjoy it
Regards
Ernesto Spinak



El 07/07/2016 a las 3:50, Renate Morgenstern escribió:
>
> Good day,
>
> I want to generate a name authority database from a csv file generated 
> from an ISIS database.
> However, in the generated csv file there are many duplicates of the 
> same name, which I do not need in he name authority database.
> How, can I generate the file that it only takes a name once.
> I DOS ISIS it was easy with the printing of headings.
> Thanks for any help.
> Regards
> Renate.
>
>
> _______________________________________________
> isis-users mailing list
> isis-users at iccisis.org
> To manage your own subscription options go to: http://lists.iccisis.org/listinfo/isis-users
> Or contact Henk Rutten: hlrutten at xs4all.nl


-- 
   .^.                                .^.
   ( )                                ( )
   ===                                ===
  =[=]================================[=]=
   | |  Ernesto Spinak                | |
   | |  spinaker at adinet.com.uy        | |
   | |  Montevideo, Uruguay           | |
   | |  tel/fax  (598) 2622-3352      | |
   | |  celular  (598) 99612238      | |
  =[=]================================[=]=
   ===                                ===
   ( )                                ( )
    V                                  V

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20160707/3dd9a38d/attachment.html>