Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

List View Filter

  Asked By: Sekhar    Date: Oct 25    Category: Sharepoint    Views: 1386

Here is an interesting issue and I was wondering if anyone knows about this. I
have a list with a choice field (Location) and I am trying to create a view with
a filter on this field. Some of the values in the field have a - (dash). For
eg., "US - TX" or "US - CA"

The filter field just does not picks up the dash. It does pick up the spaces
though. I know that I can probably use the contains option to compare to states,
but I do not want to do that. Is there some other way that dash is represented
internally in sharepoint which I have to mention in my filter field?



2 Answers Found

Answer #1    Answered By: Alexandra Patterson     Answered On: Oct 25

You might try using the ASCII code in your filter  in place of the dash
(- – or — depending on which dash  you are using). You can see
all of the ASCII codes here:

I haven't actually tried this as I'm rebuilding my server at the moment.

Answer #2    Answered By: Deven Ghurye     Answered On: Oct 25

but that did not work. I tried all three, in
ascii, decimal as well as hex values. Any other ideas?

Didn't find what you were looking for? Find more on List View Filter Or get search suggestion and latest updates.