Dynamic counter as result (part) of the repeat(...)-function

[Christiann]

Hi all,

I'm looking for a solution to the following problem:

I need a counter that counts up within the result of the repeat(...) function.

As an example:
=repeat( X, 5 ) should return '12345' as the result.

What can X look like for this?

Best regards

[jpenuliar · Accepted solution]

look at Valueloop function:

Concat(distinct ValueLoop(1, 10),'',ValueLoop(1, 10))

[Christiann]

Thank you for your reply.
Unfortunately, it doesn't quite solve the problem.

I need to concretize it.

X is a combination of text and consecutive number, so the result should be the following:

'abc1', 'abc2', 'abc3', 'abc4', 'abc5'

[Christiann]

or more precisely, the result should be as follows:

'abc1 xyz1', 'abc2 xyz2', 'abc3 xyz3', 'abc4 xyz4', 'abc5 xyz5'

I need the number twice per repetition

[Christiann · Accepted solution]

Hi,

here the complete solution:

concat( '<FirstPartOfText>' & valueloop( ExpForCounter ) & '<SecondPartOfText>' & valueloop( ExpForCounter ),

'<AdditionalPartOfText>', // this is important for the concat( ... ) function

valueloop( ExpForCounter ) ) // for correct sorting of the result