shrug-l: Split a column in attribute table

[Yurong Tan]

My $0.02 to John's comments:  The same is true in ArcGIS (I use 9.0 or 9.1)
for the left, right, mid, and char index functions, though not very
user-friendly.  You will be better off by putting the dbf in Excel or
Access, or SQL server (or some other RDBMS) and do the manipulation there
instead of doing it in ArcGIS.  By the way, are any ArcGIS developers
listening to  this thread?

Thanks


-----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