Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

List View Filter

  Asked By: Sekhar Shanubhogue         Date: Oct 25, 2008      Category: Sharepoint      Views: 260
 

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?

Tagged:      

 

2 Answers Found

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

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:
www.petefreitag.com/cheatsheets/ascii-codes/

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, 2008       

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.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].