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 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> References: <99tj92Fft8U1@mid.individual.net> 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: X-URL: http://www.phonecardfolder.com/ Xref: x330-a1.tempe.blueboxinc.net comp.groupware.lotus-notes.misc:13 comp.groupware.lotus-notes.programmer:14 >>> 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/