Hi y'all,
I'm trying to export an excel sheet as CSV comma delimited. I've put this code together but I do not get the comma delimitation. Furthermore, some figures contained in the sheet turn into dates in the CSV file. Any ideas? thanks :-)
Please Login or Register to view this content.
Can you include your sample file also??
*If you wish you click on *,a way to say ThankYou
Unfortunately not. Sadly the "attach file" is disabled in this forum.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
I also assume you have opened the file in notepad to see the format? It is possible it is ok, but if you reopen it in excel it convers certain cell to dates. is this the case?
here's the sample file finally
Yes, when I reopen it in excel and comma delimitate the content it converts certain cell to dates.
Last edited by vio.coman; 01-28-2020 at 07:48 AM.
Yes, when I reopen it in excel and comma delimitate the content it converts certain cell to dates.
Don't open it from Excel.Originally Posted by vio.coman
Right click on CSV file and open from other program like Notepad.
CSV is just a Comma Separated Values Text File and when you open it from Exel, it automatically assign to cells.
Thanks, but I need to upload the csv file from excel into a system. There is no way around it but to open it in excel
Just export csv file.
Other system shold be able to read it.
Again, Excel can create csv file, also read it, but not how text editor does.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks