Re: Lotus Notes "Agent" script

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!newsreader4.netcologne.de!news.netcologne.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
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	Fri, 20 Jan 2012 01:57:01 +0100
Organization	-
Lines	23
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>
Reply-To	KlausRusch@atmedia.net
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding	7bit
X-Trace	individual.net tubgU6yTLAsQs+bCBtnshAHPKJ932VA5qh10vWTTDjTWTtbUQ=
Cancel-Lock	sha1:Xph1O9XC4qpW2BXmdlHeSN90e2g=
User-Agent	Mozilla/5.0 (Windows NT 5.1; rv:9.0) Gecko/20111222 Thunderbird/9.0.1
In-Reply-To	<j1ce6p$89n$1@dont-email.me>
X-URL	http://www.phonecardfolder.com/
Xref	x330-a1.tempe.blueboxinc.net comp.groupware.lotus-notes.misc:13 comp.groupware.lotus-notes.programmer:14

Cross-posted to 3 groups.

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

Show key headers only | 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