[Isis-users] MX and proc

[spinaker]

Dear Peter

I don't undertand well your problem in item (1), but I have a solution 
for your problem (2)

*mx dbase proc=@delete.prc  copy=dbase now -all tell=1000*

Where file *delete.prc *is

*( if p(v959^o) then
      if s('.BON.BO.LES.ATL.'):s(mhu,|.|v959^o|.|,mpl) then
      else 'd.' fi,
  fi)*

I hope this works
Regards
Ernesto Spinak



El 17/08/2012 11:14, Hessels, Peter escribió:
>
> Dear all,
>
> I need your help in processing a database, using the mx tool.
>
> I have imported a file from a database (120.000 records) and all went 
> well. There are two problems left:
>
> 1)The control number from the original systems in mixed up: it 
> contains the control number from the imported system. That is OK. But 
> if the records has been copied from Worldcat, also the Worldcat 
> control number is in the same field. A normal control number would be 
> "12345", if the origin is Worldcat, the controlnumber would be like 
> "12345ocn101112". I want to copy the part "ocn101112" to another 
> field. How could I do that?
> I tried the Gsplit (mx dbase proc='Gsplit=1=o' create=newdb now --all) 
> but apparently the Gsplit does not work with the letter o.
>
> 2)From this imported file I created another database (loanobjects). 
> From this database I want to delete records that do not have a 
> specific value in field 959^o. The logic would be like:
> if (field 959^o is not one of (BON,BO,LES,ATL)) then (delete this record).
> How could I accomplish this?
>
> Any suggestions? I would be very grateful J
>
> Kind regards,
>
> Peter
>
>
>
> _______________________________________________
> 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/20120817/7a03f71b/attachment.html>