Get one value out of combined list

This tip describes how to obtain one value out of combined list.

This will allow you to retrieve one value out of a combined list of two fields according to another field.

For example I have the following fields:
Field1 : Fruit values : Apple,Grape,Orange,Lemon
Field2 : Status values : InStock,Soldout,Instock,Soldout
Field3 : Soldoutlist;
Field4 : SoldOut

Add the two fields together in a varialble:
CombinedList = AppleInstock,GrapeSoldout,OrangeInstock,LemonSoldout,br> Replace the value that you are looking for with a "0" in a new variable.
Trim the list and get the new list of the fruit that is soldout.

SoldoutList = Grape,Lemon


 CombinedList := 
Fruit + Status;
Temp := @ReplaceSubstring
(CombinedList;SoldOut;"0")
@Trim(@Left(Temp;"0"))
This was first published in April 2003

Dig deeper on Lotus Notes Domino Formula Language

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchWinIT

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchVirtualDataCentre.co.UK

Close