But this may be wishful thinking as some customers will not understand why we need to do this. We are thinking of providing the data in two slightly different formats: one as Excel Friendly (using the options suggested above by adding a TAB, the other one as the 'master'. They can just about open and save an email attachment. And many customers are not really computer savvy. The data in the raw CSV files is correct it's when customers open those files in Excel the problems start. Retail customers want the list in CSV format because of back-end processing programs, that are also out of our control and different per customer, so we cannot change the format of the CSV files. Take away the leading zeroes and you may actually match another product. This is in CSV format and contain part-codes, some of them start with zero's, set by manufacturers (not under our control). Take my example: my work produces list of products they sell to retail. It may work for individual cases, but only if you're in control of the final display. None of the solutions offered here is a good solution. Excel text import wizard multiple times how to#this Stackoverflow: How to correctly display. At least, instructions exist for getting around it. It needs to be said that newer versions (2013 ) of MS Excel don't open the CSV in spreadsheet format any more - one more speedbump in one's workflow making Excel less useful. Depending on your requirements/application, one might be better than another. XLS format, but I don't have experience with this. Might be to generate XML files, for which a certain format also is accepted for import by newer MS Excel versions, and which allows a lot more options similar to. If there's a reason you don't want to use the tab, look in an Unicode table for something else suitable. You don't need to import the CSV, but can simply double-click to open the CSV in Excel.and could be removed by find/replace in Excel (or Notepad etc).is not a big hindrance when viewing the CSV in Notepad (etc),.the zero-width space (ZWSP, Unicode U 200B) (If this is however a problem, look at other characters e.g.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |