Format star catalog data for use in the sc #terminal based spreadsheet application using #Python #K9

$ ./c.py hyg4.csv > hyg5.sc

#!/usr/bin/python3
import sys
import string
filename_in = sys.argv[1]
outfile = sys.stdout
delimiter = ','
infile = open(filename_in, 'r')
letters = string.ascii_uppercase
text=[":"]
row=0
for line in infile.readlines():
allp = line.rstrip().split(delimiter)
column = 0
for p in allp:
col = letters[column]
if len(p) == 0:
continue
try:
n = string.atol(p)
text.append('let %c%d = %d' % (col, row, n))
except:
if p[0] == '"':
text.append('leftstring %c%d = %s' % (col, row, p))
else:
text.append('leftstring %c%d = "%s"' % (col, row, p))
column += 1
row += 1
infile.close()
outfile.write("\n".join(text))
outfile.write("\n")
if outfile != sys.stdout:
outfile.close()