Help: exploding 1:5 become 1;2;3;4;5

HCL Domino Domino Forum
1

Hello,

I need to generate range of numbers.

I have two fields:

field_one:= 1;

field_two:= 10;

on other field I would like to explode the two fields above become

1,2,3,4,5,6,7,8,9,10

Any ideas?

Thank’s beforehand,

Glenn

2

Subject: Help: exploding 1:5 become 1;2;3;4;5

This should do it (no validity checking) ==>

field_one:= 1;

field_two:= 10;

result := field_one;

@For(i:=field_one+1; i<=field_two; i:=i+1;

result := result : i

);

@Prompt([Ok]; “Test”; @Implode(@Text(result); “~”))

3

Subject: RE: Help: exploding 1:5 become 1;2;3;4;5

superb!

but on my pc only can generate up to 1626, if I want to go further, an error message appear and says “The formula has exceeded the maximum allowable memory usage”.

Thank’s for your help.