Sharepoint List Question

Ok, I have a company directory that is currently hosted in lotus notes.
I have imported this information into a sharepoint list but the
problem is that some of the fields contain data seperated by a ; Ex)

States Registered In:

CA;CO;IA

I would like to accomplish 2 things:

1) Display a web part/data view of the list that is grouped by the
states

So the grouping would contain the states like:

CA
-
CO
-
IA -

Instead of
CA;CO;IA
-

Also to allow filtering in the same fashion. If there is a better way
to accomplish what I am looking for let me know - right now the
information is stored in a text field.
Thanks
Bill

Mike
Sat Jul 30 03:11:25 CDT 2005

The main problem is that it would seem logical to put these in a single
multi-choice field BUT you can't group on multi-choice fields.

Having them in a text field means that you can filter on them ("contains
CA") but you still can't group on anything except the full text which would
lead to nonsense probably.

If you always had a maximun of three states you could create three new
fields and move the states manually across (using Datasheet View is easiest)
before deleting the original field. But that's unlikely.

I think therefore your best bet is to abandon your idea of grouping and just
uses Views instead.

CA view would be all items registered in CA which would overlap with CO view
etc.

------

A neater solution for permanent use would be to create a Choice Field with
the choices being the US States and where multichoice is allowed. Manually
move the initial selections across (again Edit in Document View is possibly
fastest but experiment) and remove the original field. Later you will just
check off the states you need for each new item.

Filtering would be as above. (I'm 99% sure filtering works with
multichoice - try it first to be sure)

Any use ?

Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please reply to the newsgroup

<ingallb@hro.com> wrote in message
news:1122655727.879392.67520@g14g2000cwa.googlegroups.com...
> Ok, I have a company directory that is currently hosted in lotus notes.
> I have imported this information into a sharepoint list but the
> problem is that some of the fields contain data seperated by a ; Ex)
>
> States Registered In:
>
> CA;CO;IA
>
> I would like to accomplish 2 things:
>
> 1) Display a web part/data view of the list that is grouped by the
> states
>
> So the grouping would contain the states like:
>
> CA
> -
> CO
> -
> IA -
>
> Instead of
> CA;CO;IA
> -
>
> Also to allow filtering in the same fashion. If there is a better way
> to accomplish what I am looking for let me know - right now the
> information is stored in a text field.
> Thanks
> Bill
>

Tariq
Sat Jul 30 06:35:58 CDT 2005

You can try doing this via the DataViewWebPart (DVWP) but I warn you it
requires a bit of custom xslt to be written.
Typically the DVWP renders a template dvt_1.groupHeader which displays
the group headers, this would be where you would have to hack ;)

Bill
Tue Aug 02 12:30:11 CDT 2005

Thanks for the comments, I currently have views set up for the states.
I will have to look into it some more, but if I cannot get it to work I
will probably switch to a multi-choice. I would but the users are used
to it grouping by state (notes allows this) so I would like to
replicate this feature.