Value lists

[mahima]

Hi,

In my database I have one field "status" which is a Vaue list containing list of vlaues.

When I export that field to Excel file it is like this

"Inactive

Failed Eval #1

Failed Eval #2"

.

Before exporting Can we do like this separate those values with commas like this:

"Inactive,

Failed Eval #1,

Failed Eval #2"

Do this for values which are checked(checkbox checked) before exporting?

or Can we export into multiple columns of excel like status1, status2..

 

Thanks in advance

[mahima]

Hi,

I got the answer:

Let ( [

n = YourCheckBoxField ;

x = Substitute ( n ; "¶" ; ", " )

];

If ( PatternCount ( x ; ", " ) ; Replace ( x ; Position ( x ; ", " ; 1 ; PatternCount ( x ; ", " ) ) ; 2 ; " and " ) ; x )

)

 

Thanks