I imported a CSV from NWS to a file geodatabase and would like to calculate a new field (Time1).
I used the following code. It succeeds with no errors. However, I want to remove the colons. I am not sure why they carry over to the new field? Both time and Time1 are string fields.
Left( [time_],2 ) + Mid( [time_], 3,4 ) + " CST"