HCTXcity=OpenRead["Z:\\chluser1\\CHL-Archive-Projects\\Texas-Studies\\Hydro-observations\\StormSurge-data\\2008-Ike\\Observations-sourcedata\\HarrisCounty-TexasCity-HWM\\SV-HWM-LATLONG-26427.txt"
];

raw=ReadList[HCTXcity, String];
raw=StringSplit[raw,{",", " "}];

lengthdata=Length[raw]

HCTC={{"Lat", "Long", "HWM (NAVD88)"}}; 

For[i=1,i<lengthdata, i++,
raw[[i,4]]=StringDrop[raw[[i,4]],-1];
raw[[i,7]]=StringDrop[raw[[i,7]],-1];
HCTC=Append[HCTC,{ToExpression[raw[[i,2]]]+ToExpression[raw[[i,3]]]/60+ToExpression[raw[[i,4]]]/3600,ToExpression[raw[[i,5]]]+ToExpression[raw[[i,6]]]/60+ToExpression[raw[[i,7]]]/3600,ToExpression[raw[[i,8]]]}]
];

Export["HCTC.csv",HCTC]

raw[[1,4]]=StringDrop[raw[[1,4]],-1]