Madinat al-Muslimeen Islamic Message Board
| Excel & CSV |
|---|
| Kashif |
| 04/03/01 at 05:16:08 |
| assalaamu alaikum If i want to save the data from an Excel spreadsheet in CSV format and my local list-separator is set to ',' then how can i get the data to be read correctly if one of the cells in the Excel spreadsheet actually contains a ',' within its data? Kashif Wa Salaam |
| NS |
| Re: Excel & CSV |
|---|
| jannah |
| 04/03/01 at 09:58:56 |
| wlm, take it out and replace it with some other weird character and put it in after you have it in excel. csv and delimited ascii works as designed you tell it the seperator and voila.. it doesn't know exceptions |
| Re: Excel & CSV |
|---|
| Kashif |
| 04/03/01 at 11:44:44 |
| jazakillah jannah. But after a series of tests i realised that the CSV file-formatting handles all commas & speech marks by itself perfectly. |
| NS |
Individual posts do not necessarily reflect the views of Jannah.org, Islam, or all Muslims. All trademarks and copyrights on this page are owned by their respective owners. Comments are owned by the poster and may not be used without consent of the author.The rest © Jannah.Org |