I also have never had a problem with “*” in CSV files (back to v5). I export my DXCC standings all the time. I just did it to double check (it’s been a few months), and it worked just fine.
73 Len <dit dit> > On Aug 22, 2019, at 10:54 PM, Dan Violette <dank...@socal.rr.com> wrote: > > 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 ______________________________________________________________ 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