shrug-l: Split a column in attribute table

[William B. Porter]

I've had little occasion to split columns in ArcGIS 9, but the older
versions had Right[n], left[n] and astring[] commands in tables. If the
data within your column is all the same length [padded with spaces or
zero place holders] the calc command [or GUI] allows such splits. The
logic isn't difficult once you see it. 

It's also possible to make serious mistakes so be sure and calc to new
columns. 


wbp
william.porter at famu.edu
412 7474 

-----Original Message-----
From: shrug-l-bounces at lists.dep.state.fl.us
[mailto:shrug-l-bounces at lists.dep.state.fl.us] On Behalf Of Sykes, John
Sent: Friday, October 06, 2006 2:38 PM
To: watry at coaps.fsu.edu; Shrug List
Subject: RE: shrug-l: Split a column in attribute table

 
Don't know about doing this in ArcGIS, but you can read the DBF file
into Excel or dBase and do it there using the various string commands.
(LEFT, RIGHT, MID).


-- John

-----Original Message-----
From: shrug-l-bounces at lists.dep.state.fl.us
[mailto:shrug-l-bounces at lists.dep.state.fl.us] On Behalf Of Gary Watry
Sent: Friday, October 06, 2006 1:50 PM
To: Shrug List
Subject: shrug-l: Split a column in attribute table

Is there a way to split a column in a shapefile attribute column into
several columns i.e.
20060401   11 AM

into

2006 | 04 |  01 | 11 AM |

--
Gary L. Watry
GIS Coordinator
Center for Ocean-Atmospheric Prediction Studies FSU / COAPS Johnson
Building, RM 215
2035 East Paul Dirac Drive
Tallahassee, Florida 32306-2840

Phone (850) 645-7457

E-Mail: watry at coaps.fsu.edu




_______________________________________________
SHRUG-L mailing list
SHRUG-L at lists.dep.state.fl.us
http://lists.dep.state.fl.us/mailman/listinfo/shrug-l

_______________________________________________
SHRUG-L mailing list
SHRUG-L at lists.dep.state.fl.us
http://lists.dep.state.fl.us/mailman/listinfo/shrug-l