Sign In
Create Account
Hi!
I'd like to query an integer field in Arc to find some "numeric" characters...
I'd like to use this query (from MapInfo) into ArcGIS : RIGHT$(Str$(Field),2)
The "Right" part is basic, but I can't find the equivalent of the Str$ command in Arc...
Thanks!
Integer to String "on-the-fly" conversion in ArcGIS
Started by
François Goulet
, Jun 17 2009 09:01 AM
4 replies to this topic
#1
Posted 17 June 2009 - 09:01 AM
François Goulet
-
- Validated Member
-
- 641 posts
Ultimate Contributor
- Gender:Male
- Location:Mille-Isles, Qc
- Interests:Cartography, History, Graphic Design and almost everything else...
-
Canada
-
Francois Goulet
---
www.fgcartographix.com :: blog.fgcartographix.com :: http://twitter.com/fgcartographix
Back to top
#2
Posted 17 June 2009 - 02:34 PM
Crischan
-
- Validated Member
-
- 199 posts
Master Contributor
- Gender:Male
- Location:Eberswalde, Germany
- Interests:Spatial Information Design
-
Germany
-
#3
Posted 17 June 2009 - 03:30 PM
François Goulet
-
- Validated Member
-
- 641 posts
Ultimate Contributor
- Gender:Male
- Location:Mille-Isles, Qc
- Interests:Cartography, History, Graphic Design and almost everything else...
-
Canada
-
That would be CStr in VBA...
Crischan
Is that working for a definition query too? I can't find the right syntax, but I'll keep working on it...
Thanks!
Francois Goulet
---
www.fgcartographix.com :: blog.fgcartographix.com :: http://twitter.com/fgcartographix
#4
Posted 18 June 2009 - 02:47 AM
Crischan
-
- Validated Member
-
- 199 posts
Master Contributor
- Gender:Male
- Location:Eberswalde, Germany
- Interests:Spatial Information Design
-
Germany
-
AFAIK there's no VBA support in SQL queries in ArcGIS. You would have to derive a new field with the computed values first.
Crischan
Crischan
Crischan Wygoda
http://wygoda.net
http://wygoda.net
#5
Posted 18 June 2009 - 06:09 AM
François Goulet
-
- Validated Member
-
- 641 posts
Ultimate Contributor
- Gender:Male
- Location:Mille-Isles, Qc
- Interests:Cartography, History, Graphic Design and almost everything else...
-
Canada
-
AFAIK there's no VBA support in SQL queries in ArcGIS. You would have to derive a new field with the computed values first.
Crischan
Oh yeah, you're right!!!
Is there a way to do this directly in SQL?
Thanks!!!!
Francois Goulet
---
www.fgcartographix.com :: blog.fgcartographix.com :: http://twitter.com/fgcartographix
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
