[Isis-users] MX and proc
spinaker
spinaker at adinet.com.uy
Fri Aug 17 16:36:12 CEST 2012
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>
More information about the isis-users
mailing list