[Isis-users] Update field

[Piet De Keyser]

Hi Jacinto,


Suppose you want to remove the last 3 characters of field v10. Write a proc for MX containing the following (e.g. named replace.prc):


'd10',

if p(v10) then '<10>', left(v10,size(v10)-3),'</10>' fi,


then run this proc using mx:


mx mydatabase proc=@replace.prc create=mydatab2 now -all


When all is OK, rename mydatab2 into mydatabase, reindex etc. (It might be a bit more complicated when subfields are present).


Piet de Keyser

UC Leuven-Limburg

Belgium

________________________________
Van: isis-users <isis-users-bounces+piet.dekeyser=ucll.be at iccisis.org> namens Jacinto Moura <moura.jacinto at gmail.com>
Verzonden: maandag 12 maart 2018 20:05
Aan: 'isis-users'
Onderwerp: [Isis-users] Update field

Dear All,

I would to like to update a field in all my ABCD database in certain condition. How should I do that? For example I must remove the last there characters from a text field.

Thanks,
Jacinto Moura
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20180314/c69f9524/attachment.html>