Seq

All posts tagged Seq

Wanted to translate two-digit years into 4 digit years for the 1900s only.

Two digits were getting written as 35-37 or 40-50 in the spreadsheet.  This needed to be translated to 1935 1936 1937 or 1940 1941 1942 1943 1944 1945 1946 1947 1948 1949 1950.

Or

By creating a file named ‘years’ with two-digit years on each line.

67 80

55 60

45 50

 

Wanted to have Excel do this automatically.  But for now, I’m just using this method and copy/pasting results into the spreadsheet.   If anyone has any suggestions, please let me know.

 

Just figured this out and in the past I would either do two for loops ..one for 01 – 09 and other 10 – X.  Figured there had to be a better way, and sure enough this is..

servername01p
servername02p
servername03p
servername04p
servername05p
servername06p

.

.

.

servername49p
servername50p