Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jackmaster

  1. jackmaster

    diffrences between a csv file in 2003 and 2007

    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
  2. jackmaster

    diffrences between a csv file in 2003 and 2007

    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...
  3. jackmaster

    diffrences between a csv file in 2003 and 2007

    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...
  4. jackmaster

    diffrences between a csv file in 2003 and 2007

    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...
  5. jackmaster

    diffrences between a csv file in 2003 and 2007

    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...
  6. jackmaster

    diffrences between a csv file in 2003 and 2007

    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
  7. jackmaster

    diffrences between a csv file in 2003 and 2007

    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
  8. jackmaster

    diffrences between a csv file in 2003 and 2007

    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
  9. jackmaster

    diffrences between a csv file in 2003 and 2007

    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
  10. jackmaster

    diffrences between a csv file in 2003 and 2007

    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
  11. jackmaster

    diffrences between a csv file in 2003 and 2007

    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
  12. jackmaster

    CSV difference between 2003 and 2007

    spotted my error, sorry about that.
  13. jackmaster

    diffrences between a csv file in 2003 and 2007

    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...
  14. jackmaster

    CSV difference between 2003 and 2007

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

    CSV difference between 2003 and 2007

    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...
See more

Part and Inventory Search

Back
Top