You are here: > ESRI Forums > arcview 3.x users discussion forums > Thread Replies

ArcView 3.x Users Discussion Forums

ArcView GIS - Core program forum

PAT - changing all uppercase to upper/lower...   Tift Tax GIS Jul 10, 2003
Re: PAT - changing all uppercase to upper/l...   Dan Patterson Jul 10, 2003
Re: PAT - changing all uppercase to upper/l...   Dan Patterson Jul 10, 2003
Re: PAT - changing all uppercase to upper/l...   Kirsten Lawrence May 09, 2006
Re: PAT - changing all uppercase to upper/l...   Tift Tax GIS May 09, 2006
Re: PAT - changing all uppercase to upper/l...   Ganesh Devarajan May 09, 2006
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject PAT - changing all uppercase to upper/lower case 
Author Tift Tax GIS 
Date Jul 10, 2003 
Message We'd like to change all the text in one field of the PAT from all-uppercase (eg DAVIS ST, SMITH AVE) to upper/lower case (eg Davis St, Smith Ave). I've done it on individual street names, using Query and Calculator, but we have too many different street names to do it that way.
Is it possible to select all records in one field, then apply a formula to change all-caps to upper/lower case? 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: PAT - changing all uppercase to upper/lower case 
Author Dan Patterson 
Date Jul 10, 2003 
Message Add a new field to your table [LC_Names].
Assuming your field is called [Street_Names] (both fields are string BTW)

use the field calculator expression on the new field

[LC_Names]=
---------------------(faking the window ares
[Street_Names].LCase

You can of course do this on the original field but it something goes wrong then it is all your fault and not mine :) 
  Geomatics, Carleton University, Ottawa, Canada 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: PAT - changing all uppercase to upper/lower case 
Author Dan Patterson 
Date Jul 10, 2003 
Message too quick off the mark,

you can also use the BasicProper request if your field contains two or more words

[Street_Names].BasicProper(" ") 'space indicates word separator

 
  Geomatics, Carleton University, Ottawa, Canada 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: PAT - changing all uppercase to upper/lower case 
Author Kirsten Lawrence 
Date May 09, 2006 
Message Hi- i'd like to do this in arcmap but don't know the syntax - anyone know it? I want to change uppercase to initial caps. 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: PAT - changing all uppercase to upper/lower case 
Author Tift Tax GIS 
Date May 09, 2006 
Message I believe the syntax should be the same. Have you tried the syntax Dan posted? 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: PAT - changing all uppercase to upper/lower case 
Author Ganesh Devarajan 
Date May 09, 2006 
Message Hi Kirsten,

I tried this syntax in ArcMAp and it worked for me.
StrConv( [NEWFIELD2] , 3)
Substitute [NEWFIELD2]with your desired field name.

gd