Separate One Field to Multiple Booleans 1

[alembong]

I have a security table in the database that gives all the Actions allowed for each Security Category. However, the values are held in one string. (yuck!)

Cat Actions This is what is granted
----- ------- -----------------------
Cat 1 mPnCd amend, approve, cancel, create, delete
Cat 2 PnCx approve, cancel, create, verify
Cat 3 CdSsxv create, delete, list, sched, verify, view


I want to be able to display something like:

Cat amnd appr cancel create del list sched verify view
----- ---- ---- ------ ------ --- ----- ----- ------ ----
1 T T T T T F F F F
2 F T T T F F F T F
3 F F F T T T T T T

It's an Oracle db and I'm using CR 9.

Any ideas?

 

[lbass]

One approach would be to create a series of formulas like the following:

//{@Amend}:
if "amend" in {table.string} then "T" else "F"

//{@Approve}:
if "approve" in {table.string} then "T" else "F"

-LB

 

[alembong]

Thanks! that'll work for me!