Retrieve a Char from a string

HCL Domino Domino Forum
1

Hi, I have a problem that I can’t solve and was hoping that someone here may have had a simliar problem to this

I have a view with and 1 of the columns contains the following data :

0,0,0,0,0,12,54,66,852,51,336,3259,200, now this data can vary depend on selection. But what I need is the value after the 7th value (54). Because the values change I found it diffcult to use the @Middle function.

Do you have any ideas

Thanks

2

Subject: Retrieve a Char from a string

You could use instr a number of times to search for the seventh and eight comma positions and use mid to get characters between these two values

3

Subject: RE: Retrieve a Char from a string

Or Split to break the string into an array, then Left to get the first character of a particular element.

4

Subject: RE: Retrieve a Char from a string

This is what Andre means:

yourstring := 0,0,0,0,0,12,54,66,852,51,336,3259,200;

list := @Explode(yourstring; “,”);

answer := list[7];

The above will work with Notes 6. If you’re not using that then the last line could read:

answer = @Subset(@Subset(list; 7); -1)

hth

Tony