Checkbox to text list calculation?

[weststreet]

Hi,

I have a field containing about 20 selection choices via checkboxes. I have another field who's purpose is to display the first 2 characters,(plus a comma) of each checked item. I can't seem to get past "Left" functions.

So if there are three checkboxed items, "ACCOUNTING", "PREPRESS", "SHIPPING", I am looking to see returned "AC,PR,SH"

Any help would be appreciated.

Thanks!

MW

[comment]

It's best to use a custom function for this. Something like:

TruncateValues ( listOfValues ) =

Let ( [

countValues = ValueCount ( listOfValues )

] ;

Left ( GetValue ( listOfValues ; 1 ) ; 2 )

&

Case ( countValues > 1 ; ", " & TruncateValues ( RightValues ( listOfValues ; countValues - 1 ) ) )

)

[Raybaudi]

Any help would be appreciated.

Another way is to use two calc fields:

1) Repeating field with 20 rep:

Left ( GetValue ( Extend ( yourField ) ; Get ( CalculationRepetitionNumber ) ) ; 2 )

2) Calculation text field:

Substitute ( List ( repeating ) ; ¶ ; "," )