import re
  import os
  import StringIO
  import psycopg2
  
  #DSN = "dbname=pnegron"
  
  file = '/Users/pnegron/Desktop/SCRIPT-TESTING/R1.cfg'
  
  test = open(file,'r')
  
  text = test.read()
  
  test.close()
  
  text1 = re.search(r'NAME:\s\D(.+)\D.*DESCR:\s(.*)', text)
  print text1.group(1).strip(' \",')
  #text2 = re.search(r'(SN:\s)([0-9].*)', text)
  #text3 = re.findall(r'(NAME:\s.*)(DESCR:\s.*)', text)
  #text4 = re.findall(r'(SN:)\s([0-9].)', text)
  #text5 = re.search(r'Chassis', text)
  #print text1.group(1)
  #print text1.group(1).strip(" ,")
  #print newtext
  #newtext3 = text1.group(2)
  #newtext2 = text2.group(2)
  #print text3
  #print text5.group()
  #print text1.group(1)
  #print text1.group(2)
  #print text2.group(2)
  
  #print "Opening connection using dsn:", DSN
  #conn = psycopg2.connect(DSN)
  #print "Encoding for this connection is", conn.encoding
  
  #curs = conn.cursor()
  #try:
  #    curs.execute("CREATE TABLE cisco_devices (device text, Serial_No text, Description text)")
  #except:
  #    conn.rollback()
  #    curs.execute("DROP TABLE cisco_devices")
  #    curs.execute("CREATE TABLE cisco_devices (device text, Serial_No text, Description text)")
  #conn.commit()
  
  # demostrate copy_to functionality
  #data = [(newtext, newtext2, newtext3)]
  #query = "INSERT INTO cisco_devices VALUES (%s,%s,%s)"
  #curs.executemany(query, data)
  #conn.commit()