shrug-l: Split a column in attribute table

[lance.peterson at dot.state.fl.us]

Is it safe to open the DBF file in other programs? 

I've had trouble with corrupting the database when editing the DBF file 
with MS Access. 

I never tried using Excel.

Lance Peterson
Peterson Consulting / FL Dept. of Transportation
Business Systems Support Office
Office of Information Systems
Phone: 850-410-5545




"Sykes, John" <John.Sykes at dep.state.fl.us> 
Sent by: shrug-l-bounces at lists.dep.state.fl.us
10/06/2006 02:38 PM

To
<watry at coaps.fsu.edu>, "Shrug List" <shrug-l at lists.dep.state.fl.us>
cc

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.dep.state.fl.us/pipermail/shrug-l/attachments/20061006/c2cfd3a4/attachment.html