Click here to Skip to main content
15,936,119 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

This question is with regard to creating views in SharePoint.
I am trying to create a view on SharePoint list where i want a filter to select only those rows where Department is equal to E&TC but it's not happening.

It's because of '&' sign.

Also it's indexed column so i cannot apply "begins with"

How to filter such values using Views in SharePoint?

Updated 19-Jul-16 23:54pm
CHill60 13-Dec-15 14:42pm    
Try E%26TC and see if that works
DanielBrownAU 13-Dec-15 18:13pm    
Another way around this is to create a calculated field whiches replaces the * with "-", and then use that to filter. Not clean but can work.
DanielBrownAU 15-Dec-15 17:52pm    
Any luck?
Arvind Jha 29-Jan-16 2:13am    
No Daniel.Anyways Thanks

1 solution

Try the department value as "E_x0026_TC".
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900