Advanced Search

CSV File Processing

/ Published in: Python
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. def processCsv(self):
  2.         fileName = self.progPath + "\\csv\\"  + self.fileToRun
  3.         thisCsv = csv
  4.         with open(fileName,  "rb") as f:
  5.             try:
  6.                 rownum = 0
  7.                 for row in thisCsv.reader(f,  delimiter = ",",  quotechar = '"'):
  8.                     if rownum == 0:
  9.                         header = row
  10.                     else:
  11.                         colnum = 0
  12.                         for col in row:
  13.                             print '%-8s: %s' % (header[colnum], col)
  14.                             if (header[colnum] == "Submit Date"):
  15.                                 orderdate = self.extractDate(header[colnum])
  16.                             if (header[colnum] == "Customer"):
  17.                                 processedName = self.splitName(col)
  18.                                 firstname = processedName[1]
  19.                                 lastname = processedName[0]
  20.                             colnum += 1
  21.                         #self.findOrder(firstname, lastname, orderdate)
  22.                     rownum += 1
  23.             except thisCsv.Error,  e:
  24.                 sys.exit('file %s: %s' % (fileName,  e))
  25.         pass

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.