There are some Unix/Linux editors and utilities that handle "Regular Expressions" that have been ported to Windows. In retrospect that's what I should have used...
Mel... ON4AOI wrote: > Mel, > > Yep step by step would be a good start and always save with new name in case > Something goes wrong you can always go back one step. > With TEXTPAD you can select a part of the text where the changes > Should be made only, not 100% bullet proof due different length but you can > first > Make instead of a space another delimiter afterwards you rearrange the txt > to make that > Delimiter be recognized like a tab , then it will be much easier to search > and replace > I am used to work with textpad for many years now and am very familiar with > the possibilities > Build it, you can even create your own macro´s in it > > Guy ON4AOI > >> -----Oorspronkelijk bericht----- >> Van: [email protected] [mailto:[email protected]] >> Verzonden: zondag 9 augustus 2009 11:31 >> Aan: ON4AOI; 'Tonno Vahk' >> CC: [email protected] >> Onderwerp: Re: [Dx4win] Ver 8.01 issues >> >> Dear Guy, >> I think this will work as long as the QTH consists of just >> one word. The problem is how to just change the first space >> not the other. If this is solved I guess that one have to >> change all other comments added to Notes for this QSO >> manually. I have in those contacts with several different >> operators and QTHs used , and | to separate them. Perhaps it >> is better to do it in sequence, like export and remove all >> that do not have any separation signs like , | and then >> delete them from the data base and try to work with the less >> complex. When those are fixed the other may be changed >> manually. >> 73 de Mel - SM0MPV >> >> 73s Mel - SM0MPV >> >>> OK Tonno, >>> >>> B4 YOU TRY THIS MAKE BACKUPS !!!!!!! >>> >>> With spaces it is (a little) harder but I think it could >>> be done >>> And if only Names and qth are in it, other comments or >>> data will mess up >>> >>> If you like you can try the following or wait until Paul >>> comes up >>> with a solution, and I know for sure it will not be easy >>> because >>> everybody has filled in differently. >>> >>> First step >>> Export your log in Version 7 using the dx4win6 I/E filter >>> Name it ES5TV-v7 >>> Now you should have >>> ES5TV-v7.DXQ and ES5TV-v7.DXN >>> >>> We ARE only interested in the ES5TV-v7.DXN file >>> Open this file with TEXTPAD or similar editor that has >>> more >>> Options those provided by WINDOWS (they don´t work for >>> this) >>> Now you will see something like this example >>> >>> JA1BNL,TAKA TOKYO >>> Now with textpad you search for a (space) and replace with >>> (space)IN(space) >>> Afterwards it should look like >>> JA1BNL,TAKA IN TOKYO >>> >>> If ok you do replace all >>> >>> Save the file >>> >>> Second step >>> Open Version 7 >>> Close your log >>> New Log >>> Name it ES5TV-TESTLOG >>> VERY IMPORTANT NOW >>> PUT 1 QSO IN THIS NEW LOG >>> SAVE THE LOG with alt-s >>> Now import with dx4win6 I/E filter ES5TV-v7.DXQ >>> Also the correct *.DXN needs to be there >>> Take the second option in possibilities >>> if there would be an other problems >>> The import would stop if you chose the first one >>> If all goes well you have a new log with the correct >>> delimiter >>> >>> Third step >>> Copy this log ES5TV-TESTLOG.DXL in version 8 save >>> directory >>> Close everything else >>> Start DX4W801 now >>> Close the log you have open and then open >>> The new log you placed in the save directory >>> It will be converted to the V8 standard now >>> >>> Now go to QSO|multiple QSO´s operations|Set Name and Qth >>> And all should be put in correct fields >>> >>> Guy ON4AOI >>> >>> >>> >>> >>> >>>> -----Oorspronkelijk bericht----- >>>> Van: Tonno Vahk [mailto:[email protected]] >>>> Verzonden: zaterdag 8 augustus 2009 21:37 >>>> Aan: 'ON4AOI'; 'Mel' >>>> CC: [email protected] >>>> Onderwerp: RE: [Dx4win] Ver 8.01 issues >>>> >>>> It does not work this way Guy! >>>> >>>> I am also in trouble with the delimiter as I have used >>> space between >>>> name >>>> and QTH. >>>> >>>> I have been trying to find way to export the log to >>> change the >>>> delimiter but >>>> it is impossible with DXQ-QXN export-import because the >>> Notes for This >>>> Call >>>> gets doubled! Meaning the old values are not replaced >>> whatever you do >>>> but >>>> anything you import on top of them are added with "/". >>>> >>>> Even if you export your log, delete ALL QSOs after that >>> and import all >>>> the >>>> QSOs back then your Notes for This Call get multiplied >>> by two with "/" >>>> in >>>> between. Crazy. >>>> >>>> And it is not possible to open a new log file (thus >>> getting rid of the >>>> old >>>> Notes... data) and import all QSOs there because then >>> you also lose all >>>> the >>>> Groups list. >>>> >>>> Thus as far as I have no idea how do change delimiter >>> automatically in >>>> ADIF >>>> file with my domestic tools like excel etc I don't see >>> any way to >>>> accomplish >>>> this task without the program being modified to let the >>> user choose the >>>> delimiter, better yet logic similar to Excel Text to >>> Columns. >>>> What I really need is to be able to split at the first >>> space. As there >>>> are >>>> often spaces in QTH description (like near Rome or >>> alike). >>>> 73 >>>> Tonno >>>> ES5TV >>>> >>>> -----Original Message----- >>>> From: [email protected] [mailto:dx4win- >>>> [email protected]] >>>> On Behalf Of ON4AOI >>>> Sent: Tuesday, August 04, 2009 6:27 PM >>>> To: 'Mel' >>>> Cc: [email protected] >>>> Subject: Re: [Dx4win] Ver 8.01 issues >>>> >>>> Thats normally fixed in a few minutes >>>> In version 7 >>>> Export your log >>> DX4WIN6 >>>> THE *.DXN file contains the name and qth, change the >>> delimiter with >>>> textpad >>>> or similar to IN >>>> Save and import >>>> >>>> Guy ON4AOI >>>> >>>>> -----Oorspronkelijk bericht----- >>>>> Van: Mel [mailto:[email protected]] >>>>> Verzonden: dinsdag 4 augustus 2009 17:18 >>>>> Aan: ON4AOI >>>>> Onderwerp: Re: [Dx4win] Ver 8.01 issues >>>>> >>>>> very nice... but I have 25,000 QSOs not formatted that >>> way Guy ;-) >>>>> ON4AOI wrote: >>>>>> Mel and others >>>>>> >>>>>> The delimiter in or IN works perfect >>>>>> >>>>>> So MEL IN STE-MARTINE works 100 % >>>>>> >>>>>> And will populate Name =EL and QTH=TE-MARTINE >>>>>> >>>>>> When you do multiple QSO´s operations - Set Name >> and >>> Qth >>>>>> Guy ON4AOI >>>>>> >>>>>> >>>>>> >>>>>>> -----Oorspronkelijk bericht----- >>>>>>> Van: [email protected] [mailto:dx4win- >>>>>>> [email protected]] Namens Mel >>>>>>> Verzonden: dinsdag 4 augustus 2009 17:07 >>>>>>> Aan: David, K2DBK >>>>>>> CC: DX4WIN >>>>>>> Onderwerp: Re: [Dx4win] Ver 8.01 issues >>>>>>> >>>>>>> I would suggest that you not use DX4Win to populate >>> the name and >>>> QTH >>>>>>> fields then. If Paul doesn't allow a specified >>> delimiter ("," or >>>> "|" >>>>> or >>>>>>> "in") then either Jim will modify one of his >>> programs or I will >>>>> write a >>>>>>> new one. I already have a program than could do >>> this (To recognize >>>> a >>>>>>> "," >>>>>>> as well as "|" is a one line change) but it works >>> with ADIF which >>>>>>> doesn't preserve LotW status for example. I used it >>> to transfer >>>>> DX4Win >>>>>>> data to another logger I was testing (D4W was >>> better). Jim's >>>>> programs >>>>>>> work with DXQ which is preferable... so I'm hoping >>> that he might >>>>> hack >>>>>>> one of his programs if we ask him really nicely ;-) >>>>>>> >>>>>>> Mel...VE2DC >>>>>>> >>>>>>> David, K2DBK wrote: >>>>>>>> I'd been using "," (such as "David, River >>> Vale") but I can >>>> live >>>>>>> with >>>>>>>> it. I suppose the optimal solution would be to >>> have the user >>>>> specify >>>>>>> the >>>>>>>> delimiter, but if I really feel the need I can >>> export my log, >>>>> massage >>>>>>>> the data, and re-import it. I'm just happy to have >>> the new >>>> version >>>>>>> out, >>>>>>>> and am anxiously awaiting my version 8 key. :-) >>>>>>>> >>>>>>>> Mel wrote: >>>>>>>>> Perhaps he could also delimit on "|"... I don't >>> believe I am the >>>>>>> only >>>>>>>>> one using this convention. >>>>>>>>> >>>>>>>>> re MFSK ... conversion to MFSK16 should be OK as >>> I don't think >>>>> MFSK8 >>>>>>>>> is used a lot.... not really an issue here as I >>> can change the >>>> few >>>>>>>>> QSOS involved manually in less time than it took >>> me to complain >>>>>>> about >>>>>>>>> it ;-) >>>>>>>>> >>>>>>>>> I exported in DX4Win ver 6.03 format. I'll send >>> you the file if >>>>> you >>>>>>>>> like Jim. >>>>>>>>> >>>>>>>>> Maybe you could make your program QSX & Name >>> fix... I already >>>>> wrote >>>>>>> a >>>>>>>>> program to do this and it works fine... but it >>> works on the ADIF >>>>>>> file. >>>>>>>>> If I export/import ADIF I will lose information. >>>>>>>>> >>>>>>>>> I will send file direct. >>>>>>>>> >>>>>>>>> Jim Reisert AD1C wrote: >>>>>>>>> >>>>>>>>>> Regarding name, etc. >>>>>>>>>> >>>>>>>>>> If you read the on-line help, you'll see that >>> DX4WIN looks for: >>>>>>>>>> <name> in <QTH> >>>>>>>>>> >>>>>>>>>> MFSK is not a real mode. Neither is PSK. PSK >>> was removed from >>>>>>> this >>>>>>>>>> release, QSOs should automatically convert to >>> PSK31. >>>>>>>>>> >>>>>>>>>>> For QSOs where the Frequency string was >>> "Frequency=NNNKHz) >>>> the >>>>>>>>>>> "Frequency=was left in the notes field >>> instead of being >>>>>>> supressed. >>>>>>>>>> Since that's from an import, Paul can >>> (hopefully) fix this. I >>>>> can >>>>>>>>>> modify my "qsxfix" program to deal with this. >>>>>>>>>> >>>>>>>>>> I'm curious about the Satellite QSOs. What >>> export/import >>>> format >>>>>>> did >>>>>>>>>> you use? Would you be willing to send me the >>> file you tried to >>>>>>> import >>>>>>>>>> (please ZIP it first)? >>>>>>>>>> >>>>>>>>>> 73 - Jim AD1C >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Tue, Aug 4, 2009 at 8:05 AM, >>> Mel<[email protected]> wrote: >>>>>>>>>> >>>>>>>>>>> I exported my ver & data and imported it into >>> ver 8 to verify >>>>> the >>>>>>> data >>>>>>>>>>> converts properly. >>>>>>>>>>> >>>>>>>>>>> Issues... >>>>>>>>>>> >>>>>>>>>>> I had a few rejects where the mode was MFSK... >>> should probably >>>>>>> convert >>>>>>>>>>> to MFSK16. >>>>>>>>>>> >>>>>>>>>>> I had over 100 cryptic errors {Satel Mode=... >>> These were not >>>>>>>>>>> satellite >>>>>>>>>>> QSOs and were various modes and bands. >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> When extracting Frequency... >>>>>>>>>>> >>>>>>>>>>> For QSOs where the Frequency string was >>> "Frequency=NNNKHz) >>>> the >>>>>>>>>>> "Frequency=was left in the notes field >>> instead of being >>>>>>> supressed. >>>>>>>>>>> When Extracting Name QTH >>>>>>>>>>> >>>>>>>>>>> I store my data in the Format"Name| QTH| Notes" >>>>>>>>>>> >>>>>>>>>>> I would have thought this would have been easy >>> to extract... >>>> but >>>>>>> the >>>>>>>>>>> entire string ends up in NAME... what delimiter >>> is being used? >>>>>>>>>>> Shouldn't >>>>>>>>>>> the line break be a valid delimiter? >>>>>>>>>>> >>>>>>>>>>> Mel, VE2DC >>>>>>>>>>> >>> __________________________________________________________ >>> ____ >>>>>>>>>>> Dx4win mailing list >>>>>>>>>>> Home: >>> http://mailman.qth.net/mailman/listinfo/dx4win >>>>>>>>>>> Help: http://mailman.qth.net/mmfaq.htm >>>>>>>>>>> Post: mailto:[email protected] >>>>>>>>>>> >>>>>>>>>>> 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:[email protected] >>>>>>>>> >>>>>>>>> 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:[email protected] >>>>>>> >>>>>>> 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:[email protected] >>>> >>>> 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:[email protected] >>> >>> 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:[email protected] > > 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:[email protected] This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
