Filter on comma separated values

[Bhuvi]

Hi all,

I am  using simile widgets for my page, I ahve an issue for one of my columns which is a set of comma separated strings.

For example, I have field name ="Keywords" values are comma separated => 1 record has java,c,j2ee 

2 record has c,c++,asp

3 record has java, .net , python

Currently when I give filter on "keywords" field, the page shows filter on each record wise..I want to group on each word in record like Java(2) , c(2),python(1) etc.

Is there a way to do this?

Thanks .

[David Karger]

it is always helpful to point to an example. depending on how you are
storing your data, you might want to try using semicolons instead of
columns; in some cases exhibit recognizes these as value separators.
but again, linking to example will help people see the problem and solve it.

> --
> You received this message because you are subscribed to the Google
> Groups "SIMILE Widgets" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to simile-widget...@googlegroups.com.
> To post to this group, send email to simile-...@googlegroups.com.
> Visit this group at http://groups.google.com/group/simile-widgets?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

[Bhuvaneswari S]

I got to fix this one. I had to give every value in quotes separated by comma, For example

"research":['Java', 'C++', 'C', 'JavaScript', 'jQuery', 'Python' ] 

This solved my issue.

On Thu, Feb 28, 2013 at 7:37 PM, David Karger <kar...@mit.edu> wrote:

it is always helpful to point to an example.  depending on how you are storing your data, you might want to try using semicolons instead of columns; in some cases exhibit recognizes these as value separators.  but again, linking to example will help people see the problem and solve it.

On 2/28/2013 7:34 PM, Bhuvi wrote:

Hi all,
I am  using simile widgets for my page, I ahve an issue for one of my columns which is a set of comma separated strings.
For example, I have field name ="Keywords" values are comma separated => 1 record has java,c,j2ee
2 record has c,c++,asp
3 record has java, .net , python
Currently when I give filter on "keywords" field, the page shows filter on each record wise..I want to group on each word in record like Java(2) , c(2),python(1) etc.
Is there a way to do this?
Thanks .
--

You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group.

To unsubscribe from this group and stop receiving emails from it, send an email to simile-widgets+unsubscribe@googlegroups.com.

To post to this group, send email to simile-widgets@googlegroups.com.

Visit this group at http://groups.google.com/group/simile-widgets?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to a topic in the Google Groups "SIMILE Widgets" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/simile-widgets/j2yix9AvtUU/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to simile-widgets+unsubscribe@googlegroups.com.
To post to this group, send email to simile-widgets@googlegroups.com.

Visit this group at http://groups.google.com/group/simile-widgets?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

--
" Every job is a self-portrait of the person who did it. Autograph your work with excellence"