I am receive my data in a text file in the following format:
"5365-00-384-6859","SPACER","","EA|EA","1.50|1.50"

Is there a way I can upload this data into a table. It appears that the brackets are causing a problem when I am uploading using the typical:
appen from myfile.txt type sdf delimited