I imported some streamflow data from USGS that imported as several fields merged into a single text column. I now need to go through the text column and extract the date and flow data in separate columns for analysis.

i.e. I have several hundred lines of data in a single column that looks like this "USGS 11181390 1976-10-12 0.09 A"

Is there a way to extract the date (i.e. 1976-10-12) [through 1996-06-09] and the numerical value after the date, in this case = "0.09" and put them in different columns so I can analyze flows by date. The location of the beginning of each field seems to be the same, the ending changes for the numerical values for the flow data varies a little since some of the flow data is only to tenths, i.e. - 0.1 and not 0.10.

Thanks, R