Script to convert .XLS to .CSV

[system]

Hi,
I have a output file in .XLS format. Instead of .xls i can make .csv as a output flat file. But my limitation is in my data i have comma in between on field like(Citi bank,Chicago). I need all value in one field. So i generated .xls File.

Is there any suggestion to develop script for converting .xls to .csv

---

kannar (BOB member since 2011-08-01)

[system]

This post may help you to generate your .CSV file successfully:-

120×120 10.4 KB

Hi , please any body explain this option with example in the file format. Row within text string having two options one is charcter and another one is row delimiter. but by default option is character only . when we will use row delimter option . can you explain one example of useage of this functionality. Thanks&Regards, Ramana. Ramana (BOB member since 2009-04-30)

---

Nemesis (BOB member since 2004-06-09)

[system]

heres a cool vbscript you can use. rename script to .vbs … also requires excel be installed.

you can drag/drop multiple csv’s or can be called from ds, sending in paths of files you need converted.

this script saves our pps a lot of time and it doesnt do any data formatting that you get when you open with excel and do a save-as.
XLStoCSV.txt (0.0 KB)

---

jlynn73 (BOB member since 2009-10-27)