Checkbox Data

[Gabzilla]

Greetings and happy new year...

I have a field that the data is populated through a checkbox. Could be 2 to 4 values checked.

How can I split those entries into seperate fields?

Example:

The field "Skill" contains: Run, Jump, Swim

I want field Skill01 to contain Run

field Skill02 to contain Jump, etc.

[stanley]

Gabzilla:

I'm not sure I understand why you would want to do this, but the solution is to create four fields, each formatted as a checkbox, each with only one item in its related value list. With a checkbox, you can check & uncheck it, so it works fine.

-Stanley

[sbg2]

Another way would be to create 4 unstored calculation fields:

Skill01 = Substitute(MiddleValues(Skill;1;1);¶;"")

Skill02 = Substitute(MiddleValues(Skill;2;1);¶;"")

Skill03 = Substitute(MiddleValues(Skill;3;1);¶;"")

Skill04 = Substitute(MiddleValues(Skill;4;1);¶;"")

[LaRetta]

I agree with Stanley - the reasoning is unclear to us ...

If you only want to change it to then concatenate the fields into a line, you can also create ONE calculation (text) with:

Substitute ( ValueListItems ( Get ( FileName) ; "yourVLname" ) ; "¶" ; ", " )

... to produce one line of the results. Why add additional fields (whether four new skill fields and/or four calc fields)? Sure as the sun rises, you'll be needing to add another checkbox item ... and then you'll add ANOTHER field AND add (or change) another calc?

The field, as it stands as multiline is powerful for joins. So your reasons for splitting it into separate fields can probably be handled in better ways. Can you explain what this will be used for?

LaRetta

[sbg2]

Iyou can also create ONE calculation (text) with:

Substitute ( ValueListItems ( Get ( FileName) ; "yourVLname" ) ; "¶" ; ", " )

... to produce one line of the results.

Wouldn't this just return the items in the Value List? Unless you are talking about creating a new value list from a self relationship where ID::ID. That seems a long way to go when simply:

Substitute(Skill;"¶" ; ", " )

produces a comma seperated list of the Skill field for each inividual record.

[Gabzilla]

Thank you for the responses. sbg2's suggestion works for what I need.

OK, the reason I want to do this is because the data is already entered into one field, and I have decided that I want to have the data in seperate fields. Had I thought of it originally, I would have done it the way Stanley suggested.

I may not even need to do this, but my own limitations make me think that I can accomplish what I want to accomplish if I have the data seperated, or at least do it easier, or at least test it out to see if it works. I did not think it through enough beforehand, but I am also still struggling to accomplish what I want and am "fishing" for solutions.

I am trying to sort students into a schedule. They have chosen topics. There are multiple sessions of each topic. It is easy enough to place them into different sessions, but the complication comes in with multiple time periods.

For example: John picks Running as one of his topics and Swimming as his second. Running has three sessions - 1 in first period & 2 in second period. Swimming has three sessions as well, but they are all during first period. So John HAS to be in the 2nd period Running.

I decided that it would be easier for me to script the sorting process if I had the data in seperate fields. Maybe it wouldn't be if I had more knowledge, but at this point I think I need to have it that way.

Thanks again for your help.