I have never had a problem with the '*' and Excel. I convert VUCC to CSV then edit to one page for reference and saved to .XLSX. I also do DXCC with an Excel macro (.XLSM) to format and remove deleted that were not worked. Again, for a reference paper I take with me.
Dan KI6X -----Original Message----- From: dx4win-boun...@mailman.qth.net <dx4win-boun...@mailman.qth.net> On Behalf Of Randy Farmer Sent: Thursday, August 22, 2019 6:30 AM To: dx4win@mailman.qth.net Subject: Re: [Dx4win] Log export as .csv file (for spreadsheet analysis) Be aware if you are exporting a DX4WIN report as a csv file into Excel: DX4WIN uses an asterisk (*) to denote credited entities in a report. This character is a special reserved character in Excel, and attempting to use the raw csv export file from a DX4WIN report will therefore give some weird results. I'm always forced to first run the csv file through Notepad or Wordpad and do a search and replace on all the * characters. This has been a problem with the program forever, and I sure wish it could be fixed. 73... Randy, W8FN On 8/22/2019 5:16 AM, David Gould wrote: > Hi Cesar, > > Thanks for that, it has solved my problem. > > 73, > > Dave G3UEG > > > On 22/08/2019 11:08, PY2YP wrote: >> Hi Dave >> >> Right click on the logbook window then choose save file. >> >> 73 DX de PY2YP - Cesar >> >> On 22/08/2019 07:01, David Gould wrote: >>> I was surprised not to find a .csv file export option. >>> >>> Can anyone suggest a way to get the log data into a spreadsheet. I >>> want to sort the data on various columns. >>> >>> 73, >>> >>> Dave G3UEG > ______________________________________________________________ > DX4WIN mailing list > Home: http://mailman.qth.net/mailman/listinfo/dx4win > Help: http://mailman.qth.net/mmfaq.htm > Post: mailto:DX4WIN@mailman.qth.net > > This list hosted by: http://www.qsl.net Please help support this email > list: http://www.qsl.net/donate.html ______________________________________________________________ DX4WIN mailing list Home: http://mailman.qth.net/mailman/listinfo/dx4win Help: http://mailman.qth.net/mmfaq.htm Post: mailto:DX4WIN@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html ______________________________________________________________ DX4WIN mailing list Home: http://mailman.qth.net/mailman/listinfo/dx4win Help: http://mailman.qth.net/mmfaq.htm Post: mailto:DX4WIN@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
