Re: Lotus Notes "Agent" script

From	Klaus Johannes Rusch <KlausRusch@atmedia.net>
Newsgroups	alt.comp.lang.lotuscript, comp.groupware.lotus-notes.misc, comp.groupware.lotus-notes.programmer
Subject	Re: Lotus Notes "Agent" script
Followup-To	comp.groupware.lotus-notes.programmer
Date	2012-01-20 01:57 +0100
Organization	-
Message-ID	<9nrseqFokrU1@mid.individual.net> (permalink)
References	<99tj92Fft8U1@mid.individual.net> <slrn20110803152209.917.twooffive@may.eternal-september.org> <j1ce6p$89n$1@dont-email.me>

Cross-posted to 3 groups.

Followups directed to: comp.groupware.lotus-notes.programmer

Show all headers | View raw

>>> I have to carryout an update to a Lotus Notes database which has many
>>> thousands of entries. There is a category field with a choice of
>>> approximately 60 categories, 30 or which need to be changed to an
>>> updated term. I have been given a CSV file containing both the old
>>> and new term that I hope to use as a lookup table. To do this I need
>>> to write an "Agent", Lotus speak for there equivalent of VB Script,
>>> but do not know how to do this.
>>> I would be grateful for any advice or code samples.

FIELD cat :=
         @If(
                 cat = "oldvalue1"; "newvalue1";
                 cat = "oldvalue2"; "newvalue2";
                 ...
                 cat = "oldvaluen"; "newvaluen";
                 cat);
SELECT @All


-- 
Klaus Johannes Rusch
klausrusch@atmedia.net
http://klausrusch.atmedia.net/

Back to comp.groupware.lotus-notes.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Re: Lotus Notes "Agent" script §ñühwö£f <snuhwolf@netscape.net> - 2011-08-03 15:23 -0600
  Re: Lotus Notes "Agent" script Klaus Johannes Rusch <KlausRusch@atmedia.net> - 2012-01-20 01:57 +0100
  Re: Lotus Notes "Agent" script Klaus Johannes Rusch <KlausRusch@atmedia.net> - 2012-01-20 01:58 +0100

csiph-web