Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Reply
Contributor
14 Posts
0 Kudos
Registered: ‎10-04-2006
Post 1 of 4

Filter case sensitive

62 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
730 Posts
1 Kudo
Registered: ‎09-14-2006
Post 2 of 4

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
14 Posts
0 Kudos
Registered: ‎10-04-2006
Post 3 of 4

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
730 Posts
1 Kudo
Registered: ‎09-14-2006
Post 4 of 4

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
Are you interested in helping shape the future of the Autodesk Community? To participate in this brief usability study, please click here. Your time and input is greatly appreciated!