NumberListItems(listField)

[TJ53]

Hi,

I wonder if there is already a custom function out there that does the following:

parameter: listField, that would be a field with a list of items, e.g.

oranges

apples

bananas

I would need the following result:

NumberListItems(listField) =

0001 oranges

0002 apples

0003 bananas

Any ideas? Thanks in advance!

Edited December 13, 2008 by Guest

[comment]

The function itself could be rather trivial:

SerializeValues ( listOfValues )

Let ( [

countValues = ValueCount ( listOfValues ) 

] ;

Case ( countValues > 1 ; SerializeValues ( LeftValues ( listOfValues ; countValues - 1 ) )  & ¶ )

&

Case ( countValues ; SerialIncrement ( "0000" ; countValues ) & " " & GetValue ( listOfValues ; countValues ) )

)

See also:

http://www.briandunning.com/cf/677

However, if you need this you should probably keep the values in separate records of a related table, rather than in a single text field.

[TJ53]

Awesome, thanks a lot!