Some Python to parse out those pesky characters

ParseDis.csv

Parser.py

import csv

# Open the raw file
fileReader=open('ParseDis.csv','rb')
# Open the writer
writer=open('DisBeParsed.csv','wb')
# Read the raw file as a CSV
reader=csv.reader(fileReader)

replaceDees=['-','|']

# Get all rows
for row in reader:
    line=''
    # Get all rows
    for col in row:
        # Get a character to replace
        for i in replaceDees:
            # Replace it
            col=col.replace(i,'')
            # Replace it good
        # Add it to the current line
        line+=col+','
    # Write the line
    writer.write(line+'\n')

# Shut it down
fileReader.close()
writer.close()