Calc for export

[JTSmith]

I have a field called Sizes, which is a check box.  The options are Studio, One / One, Two / One, Two / Two, Three / Two.  I'm trying to make a calculation field, export_sizes, which would be in this format:

One Bed, Two Bed, Three Bed

 

I don't care about studios.  But if a record has sizes one/one and three/two, it should be calculated at "One Bed, Three Bed".

 

If a record has sizes two/one and two/two, is should be calculated at "Two Bed".

 

This should be simple, but I can't seem to make sense of it...

 

Any help would be greatly appreciated. 

[eos]

 

This should be simple, but I can't seem to make sense of it...

 

One could say that "you made your list, now lie in it", but that would be a bit harsh … 

 

Try

Let ( [

  l = ¶ & List ( "three/two" ; "Studio" ; "one/one" ) ; // sample data: List() represents your field; keep the pilcrow

  one = Case ( PatternCount ( l ; "¶one" ) ; "One Bed" ) ;
  two =  Case ( PatternCount ( l ; "¶two" ) ; "Two Bed" ) ; 
  three = Case ( PatternCount ( l ; "¶three" ) ; "Three Bed" )
  ] ; 
  Substitute ( List ( one ; two ; three ) ; ¶ ; ", " )
)

which for the sample value list returns "One Bed, Three Bed"

[JTSmith]

I know, I have learned my lesson on checkboxes.  Thanks for the help, worked like a charm!