From: Terence K. <cha...@ea...> - 2002-07-16 16:19:33
|
Hello all, I just want to start by saying what an awesome set of scripts these = are and how grateful my company is to have been able to use them. I got = a great amount of help from the user groups (under the alias "Unix = Newbie") and I would like to possibly give something back. The survey that was needed by my company was huge, 300 questions long, = it was a exam based survey full of free form text answers and other such = things. Well, everything worked fine, but the csv file output. Due to = users using quotation marks and commas in their free form text the file = had all kinds of troubles with excel. Also because the file had more = than 256 columnes some data as getting lost (excel can only use 256 = colums per workbook). Well to fix this I wrote a pretty basic perl = script that will strip out the problematic quotations, and spilt files = with more than 256 columns into two. Its a pretty easy to use script and = I wanted to make it available should anybody be running into the same = problem I did. Its free for you to use any way you please. You can download it from = http://homepage.mac.com/kent9646/FileSharing1.html. I plan on making = additions to it to handle diffent file types and making it easier to use = but here it is for now, and you are welcome to it if it can help you! =20 Terry. |