Manage Learn to apply best practices and optimize your operations.

Extract 1 Particular Value From A Text List Using Formula

Normally when trying to extract 1 particular value from a text list, you would
use Script and extract the value with the array(index), but there is a simple
way to do this with formula language
For this to work, you must know which value you wish to retrieve, ie.. what
number the value is in the list.
Use @Subset to get your desired results.
This example uses a nested @Subset with another @Subset.
For example:
If the field you are wanting to extract the value from is,

Joe, Bill, Fred, Frank, Jake, Jill, Jack, Julie, Nancy, Christine, Kevin,
Corey, Samantha, Mickinzy

and you want to extract the value "Frank" from the list, use the following in
another field:

@Subset(@Subset("fieldname";4);-1)

This first gets the value of the first 4 entries in the list, then extracts the
last value from that list giving you the desired result "Frank", since Frank is
the 4th value in the 1st list, and the last in the second.

Dig Deeper on Domino Resources - Part 7

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

SearchWindowsServer

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 ...

SearchDataCenter

SearchContentManagement

Close