format list of numbers

[rivet]

I would like a recursive CF to turn this field entry:

3¶

4¶

12¶

102¶

22¶

Into this:

003¶

004¶

012¶

102¶

022¶

[comment]

Try something like:

LeadifyList ( list )

Let ( [

item = LeftValues ( list ; 1 ) ;

processed = Right ( "000" & Substitute ( item; ¶ ; "" ) ; 3 ) ;

nextList = RightValues ( list ; ValueCount ( list ) - 1 )

] ;

Case ( not IsEmpty ( item ) ; processed & ¶ )

&

Case ( not IsEmpty ( nextList ) ; LeadifyList ( nextList ) )

)

It could be simplified a bit by using the new GetValue () function, but this way it's compatible with v.7.

[rivet]

that is great I will give it a try - thanks comment