Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Reply
Contributor
pmarseil
Posts: 14
Registered: ‎10-04-2006
Message 1 of 4 (60 Views)

Filter case sensitive

60 Views, 3 Replies
10-02-2007 07:59 AM
Hi,
I'm trying to create a search tool in the studio on a shapefile and sdf where all the content are uppercase. I was thinking that the operator LIKE was supposed to do the job, but it seems that no!

Is somebody know was is exactly the function to do that. I've tried Upper() but not working.
Thanks
Employee
dswilson
Posts: 730
Registered: ‎09-14-2006
Message 2 of 4 (60 Views)

Re: Filter case sensitive

10-09-2007 09:13 AM in reply to: pmarseil
Upper should be the correct function.

The expression in the advanced expression builder should look something like:

"PropertyName" LIKE Upper('%$USER_VARIABLE%')

Note I added wildcards to both sides of the expression. There is also a bug such that this doesn't appear to work with Extended characters such as é found in non-english languages.

Regards,
Dave


Dave Wilson
SQA Analyst
AEC IM
Autodesk, Inc.

Contributor
pmarseil
Posts: 14
Registered: ‎10-04-2006
Message 3 of 4 (60 Views)

Re: Filter case sensitive

10-09-2007 01:43 PM in reply to: pmarseil
Thanks Dave,
The problem was my upper synthax. Now it' work great.
Can you tell me in wich language are the expression builder?

Thanks again
Employee
dswilson
Posts: 730
Registered: ‎09-14-2006
Message 4 of 4 (60 Views)

Re: Filter case sensitive

10-09-2007 02:02 PM in reply to: pmarseil
I don't think the expression is in any formal language syntax. It's FDO syntax as far as I know.

Dave


Dave Wilson
SQA Analyst
AEC IM
Autodesk, Inc.

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.