converting pipe delimited file to fixed width

John Posner jjposner at snet.net
Thu Mar 19 13:55:27 EDT 2009


[snip]
 
> field_widths = [14, 6, 18, 21, 21, 4, 6]
> 
> out = open("/home/chatdi/ouptut.csv", 'w')
> for line in open("/home/chatdi/input.csv", "r"):
>     fields = line.rstrip().split('|')
>     padded_fields = [field.ljust(width) for field, width in zip(fields, field_widths)]
>     out.write("".join(padded_fields) + "\n")
> 
> out.close()

How about a version that uses Python 3.0 string formatting:

  field_widths = [14, 6, 18, 21, 21, 4, 6]

  out = open(r"c:\temp\output.csv", 'w')
  for line in open(r"c:\temp\input.csv", "r"):
      fields = line.rstrip().split('|')
      outline = ""
      for pair in zip(fields, field_widths):
          outline += "{0:{1}}".format(*pair)
      out.write(outline + "\n")
  out.close()

Or, if you hate NLs (and, perhaps, like obfuscation):

  field_widths = [14, 6, 18, 21, 21, 4, 6]

  out = open(r"c:\temp\output.csv", 'w')
  for line in open(r"c:\temp\input.csv", "r"):
      fields = line.rstrip().split('|')
      out.write("".join(["{0:{1}}".format(*pair) for pair in \
                zip(fields, field_widths)]) + "\n")
  out.close()




More information about the Python-list mailing list