'''
American Custom Finishing ASN Generate

ACF gets a differently structured document (than HTX/SYF/ATX) but with mostly the same information.
It appears to be pipe ('|') delimited.

Fields IN ORDER:
    Constant - 'ST'
    Constant - 'ST'
    Order/Roll
    STYLE1-STYLE2
    Pattern Name
    ???
    Roll length ex. 061.250
    PO number of some sort
    Color number
    Customer Name
    Ship to Address 1
    Ship to Address 2
    Ship to City, State, Zip 'SUNBURY PA 17801'
    ??? Looks like a finish code
    **Not Used**
    **Not Used**
    ???
    ???
    Finished Description (?)
    **Not Used**
    **Not Used**
    **Not Used**
    **Not Used**
    **Not Used**
    **Not Used**
    ???
    ???
'''
import csv
if __name__ == '__main__':
    lines = []
    data = []
    with open('G:\\FTP\\ACF_SAMPLE.txt') as f:
        lines = f.readlines()
    for line in lines:
        row = line.split('|')
        for i,field in enumerate(row):
            row[i] = field.strip()
        data.append(row)
        print row
    with open('G:\\FTP\\ACF_SAMPLE_FIXED.txt', 'w') as out:
        #derp = csv.writer(out, delimiter ='|',quotechar =',',quoting=csv.QUOTE_NONE,escapechar='*')
        derp = csv.writer(out, delimiter ='|',quoting=csv.QUOTE_NONE)
        derp.writerows(data)