rmwolter

Spliting data in to new fields

Discussion created by rmwolter on Feb 14, 2014
Latest reply on Feb 14, 2014 by curtvprice
I have a set of data that has computer generated time stamps that I would like to copy specific parts of it into new fields. The fields are populated with this information:

1/1/2007 12:18:34.721544 AM -08:00

I want to remove the date portion in populate that in an already created field and do the same with the time as well. I have 2.4 million rows that I have to do this for in the already created 16 fields. I know some Python but haven't used it in awhile. What is the best process to do this? I was thinking field calculator but am clueless on the next step. Any help?

Randy

Outcomes