Highlight columns instead of rows of text

[Insomniator]

I have the following assload of numbers:

baseball stats

Now is there anyway for me to pull out one column of stats? Like just the hits per game since 1900?

I wanna put them in a spread sheet but cant think of any other way besides manually typing them in..

thanks

 

[TastesLikeChicken]

Originally posted by: Insomniator
I have the following assload of numbers:

baseball stats

Now is there anyway for me to pull out one column of stats? Like just the hits per game since 1900?

I wanna put them in a spread sheet but cant think of any other way besides manually typing them in..

thanks

You could create tables out of those stats in Word or Excel and then be able to select a column from any tbale. It would still require some manual tweaking to create the tables but it'd be faster than typing it all in.

 

[TheoPetro]

just import the table on that page into excel and go at it

 

[spidey07]

Originally posted by: TheoPetro
just import the table on that page into excel and go at it

Yep, copy paste into notepad, import text file. Done.

 

[KillerCharlie]

If you hate excel as much as I do, you can always do it with a text editor like nedit.

 

[jfall]

Year H/G
2007 9.2
2006 9.1
2005 9.0
2004 9.0
2003 9.0
2002 8.9
2001 9.0
2000 9.2
1999 9.3
1998 9.0
1997 9.0
1996 9.0
1995 9.1
1994 9.2
1993 9.1
1992 8.5
1991 8.5
1990 8.8
1989 8.3
1988 8.4
1987 8.9
1986 8.6
1985 8.5
1984 8.7
1983 8.7
1982 8.8
1981 8.6
1980 8.8
1979 8.9
1978 8.6
1977 9.0
1976 8.7
1975 8.8
1974 8.7
1973 8.7
1972 8.4
1971 8.5
1970 8.9
1969 8.5
1968 8.2
1967 8.5
1966 8.8
1965 8.5
1964 8.7
1963 8.3
1962 9.0
1961 9.0
1960 8.7
1959 9.0
1958 9.0
1957 9.0
1956 8.7
1955 8.9
1954 9.1
1953 9.3
1952 8.6
1951 8.9
1950 9.1
1949 9.1
1948 9.1
1947 9.2
1946 8.7
1945 9.3
1944 9.0
1943 8.8
1942 8.5
1941 8.9
1940 9.2
1939 9.5
1938 9.4
1937 9.5
1936 9.9
1935 9.9
1934 10.0
1933 9.3
1932 9.8
1931 9.8
1930 10.9
1929 10.4
1928 9.7
1927 9.8
1926 9.6
1925 10.4
1924 9.8
1923 10.0
1922 10.3
1921 10.1
1920 9.1
1919 8.6
1918 8.4
1917 8.2
1916 8.1
1915 8.2
1914 8.3
1913 8.7
1912 9.2
1911 8.7
1910 8.4
1909 8.0
1908 7.7
1907 8.0
1906 8.0
1905 8.6
1904 8.4
1903 9.3
1902 8.9
1901 9.4
1900 9.9

 

[IronWing]

Originally posted by: jfall
Year H/G
2007 9.2
2006 9.1
2005 9.0
2004 9.0
2003 9.0
2002 8.9
2001 9.0
2000 9.2
1999 9.3
1998 9.0
1997 9.0
1996 9.0
1995 9.1
1994 9.2
1993 9.1
1992 8.5
1991 8.5
1990 8.8
1989 8.3
1988 8.4
1987 8.9
1986 8.6
1985 8.5
1984 8.7
1983 8.7
1982 8.8
1981 8.6
1980 8.8
1979 8.9
1978 8.6
1977 9.0
1976 8.7
1975 8.8
1974 8.7
1973 8.7
1972 8.4
1971 8.5
1970 8.9
1969 8.5
1968 8.2
1967 8.5
1966 8.8
1965 8.5
1964 8.7
1963 8.3
1962 9.0
1961 9.0
1960 8.7
1959 9.0
1958 9.0
1957 9.0
1956 8.7
1955 8.9
1954 9.1
1953 9.3
1952 8.6
1951 8.9
1950 9.1
1949 9.1
1948 9.1
1947 9.2
1946 8.7
1945 9.3
1944 9.0
1943 8.8
1942 8.5
1941 8.9
1940 9.2
1939 9.5
1938 9.4
1937 9.5
1936 9.9
1935 9.9
1934 10.0
1933 9.3
1932 9.8
1931 9.8
1930 10.9
1929 10.4
1928 9.7
1927 9.8
1926 9.6
1925 10.4
1924 9.8
1923 10.0
1922 10.3
1921 10.1
1920 9.1
1919 8.6
1918 8.4
1917 8.2
1916 8.1
1915 8.2
1914 8.3
1913 8.7
1912 9.2
1911 8.7
1910 8.4
1909 8.0
1908 7.7
1907 8.0
1906 8.0
1905 8.6
1904 8.4
1903 9.3
1902 8.9
1901 9.4
1900 9.9

The average is 1953.5

 

[FrankSaucedo]

open file in word, hold down alt. This will let you select a block of text

 

[tRaptor]

I remember the COBOL editor we used to use in college (name escapes me) used to have this ability. I realize this is not really helpful to you but i really liked that ability for some reason. I will have to give this nedit a try...