How to call a cmd file within python script
<p>This is the python script will do. The question is how to call the external cmd file within the function?</p>

<ul>
<li>Read a CSV file in the directory.</li>
<li>If the content in 6th column is    equal to 'approved', then calls an
external windows script 'TransferProd.cmd'</li>
</ul>

<p>.</p>

<pre><code>def readCSV(x):
    #csvContents is a list in the global scope that will contain lists of the  
    #items on each line of the specified CSV file
    try:
        global csvContents
        file = open(csvDir + x + '.csv', 'r')      #Opens the CSV file
        csvContents = file.read().splitlines()     #Appends each line of the CSV file to csvContents
        #----------------------------------------------------------------------
        #This takes each item in csvContents and splits it at "," into a list.
        #The list created replaces the item in csvContents
        for y in range(0,len(csvContents)):
            csvContents[y] = csvContents[y].lower().split(',')
        if csvContents[y][6] == 'approved':
            ***CALL TransferProd.cmd***
            file.close()
        return
    except Exception as error:
        log(logFile, 'An error has occurred in the readCSV function: ' + str(error))
        raise
</code></pre>
