Converting delimited text into checkboxes
Greetings,
I have downloaded a publicly available spreadsheet from the FDA containing their warning letters and have imported into quickbase. It has worked well but I am stumped on how to do the following. Under their "subject" column, they list multiple causes for the warning letter. I have been able to convert those causes to different text columns because they are delimited with "/". However, what I think really would like to do is to create a checklist of all causes and then associate that back to the record. That way, I think, it will be easier for me to analyze and report the occurrence of the causes.
In case it matters, the order of the causes is not always the same.
The column in question (in the form in which it is downloaded) looks like this:
| Subject |
| CGMP/QSR/Medical Devices/PMA/Adulterated/Misbranded |
| CGMP/QSR/Medical Devices/Adulterated/Misbranded |
| Medical Device Reporting/Misbranded |
I presume it needs some sort of formula so I have tagged it that way. Any and all help would be appreciated. Including if their is a completely better way to do it.
John
several ideas but let's take this step by step. If you create a new field of type Formula multi select text with this formula
Split(List(";",
[Cause 1], [cause 2], [Cause 3], .... etc, [Cause 9]))then you will be able to use that field as a dynamic filter. It would not do any fancy percentage calculations for you but if there are not too many different causes then you could quickly filter your master list down and write down on a piece of paper :) how many came up on the filtered report as you cycle through each Dynamic Filter option in turn.
Do you have more ideas but why don't you start by doing that and post back.
Also can you tell me whether or not you have access to a master list of the causes, or do you need to generate them out of the data.
