I have a utility to load data into an application. It requires that the data be comma delimited. One vendor supplying the data says they can only provide it in a pipe delimited file. I need a simple script I can add to a batch file to change:
John|Doe|123 Main Street, Suite 200|New York|NY
"John","Doe","123 Main Street, Suite 200","New York","NY"
I need the data surrounded in quotes because of the poitential for imbedded commas in the addresses.
I'm not particular about the method used, but I am not a programmer. I need something I can plug into a script so it will say:
convert filea.txt filea.cvs