Search results for query: *

I am now wondering if the script that creates my output from the csv file is at fault so i have added a link to this file also. http://db.tt/358OhP0S

Nothing that has been suggest to me is working so i have created links to 3 files The original excel file http://db.tt/ZPYS90rn The 2003 csv file http://db.tt/9s7RQznV The 2007 csv file http://db.tt/hSFG89dk Hopefully it will be easier to understand if you can see the actual...

i know this is over kill but these are the outputs i get from bother versions. ************2003************ CHAPTER,NC_RESOURCES Keywords,Name Types,String NC_TOOLS,NC_TOOLS NC_INSERTS,NC_INSERTS NC_TOOL_ASSEMBLIES,NC_TOOL_ASSEMBLIES NC_CORRECTORS,NC_CORRECTORS END, CHAPTER,NC_TOOLS...

Sorry to disappoint you Skip but I posted the first few lines of data taken from both the 2003 and 2007 csv files, I did this to hi-light the difference if you want me to post ALL of the data then I will and then you will see all of the commas, If you have both versions then i suggest you create...

I will try to explain more clearly. The excel sheet has 670 rows 1 to 59 have data in columns A,B. 60 to 117 have data in columns A-AI 118 to 252 have data in coulmns A-AG and so on, so i cannot just select the columns as Skip suggested and then delete the empty data from the cells, what i did...

Finally skip i get what you mean (i am not dumb, honestly) this does work to some degree but because the data varies in column width it will makes things long winded to remove the empty spaces on each line. i am signing off now so may not reply until tomorrow. Jonnie

i need the all the data in the sheet, it appears the empty cells are being filled with a comma and this is causing me problems, i cannot just remove all commas as some are needed in certain places. Jonnie

Sorry Skip but as i said earlier i am new to forums. i have tried to select the columns on the first few rows and r/h click select delete and save this as csv, once i open with wordpad the commas are still present, i know it doesnt make sense but this is what is happening. Jonnie

Hi Andy, It is not possible to delete the columns as there are many and they all vary in size, i have attached the xls file (i think) to show you. Jonnie

Hi Andy, I just select the page in excel and hit file save as 'csv' but for some reason there is a difference between 2003 and 2007. Cheers Jonnie

sorry about that Skip,i am new to forums. i am using excel to create the csv and i have tried all the options available ie (msdos) (mac) etc but the file size is still large and the commas are still there. jackmaster

spotted my error, sorry about that.

i am using a csv file to create a tool catalogue in Catia V5 and it worked perfectly using a csv file from office 2003 now using 2007 it doesnt work and the file size is almost 4 times the size of the 2003 csv file, when i open the csv file using wordpad the 2007 version has multiple commas...

Hi SQLBill i am new to this and i am not really sure what you mean.

i am using a csv file to create a tool catalogue in Catia V5 and it worked perfectly using a csv file from office 2003 now using 2007 it doesnt work and the file size is almost 4 times the size of the 2003 csv file, when i open the csv file using wordpad the 2007 version has multiple commas...