[Dx4win] Log export as .csv file (for spreadsheet analysis)

[Len K1NU]

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 <danki6x at 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-bounces at mailman.qth.net <dx4win-bounces at mailman.qth.net> On Behalf Of Randy Farmer
> Sent: Thursday, August 22, 2019 6:30 AM
> To: dx4win at 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 at 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 at 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 at mailman.qth.net
> 
> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html