OK. The SPEC says MHz. 14,037 is not a value in MHz, it's KHz. So, that's the violation right there. As for the particular function that your using to get this value, it's doing what it's suppose to. DxBase appears to be a little smarter and only lets you use '.' instead of ',' in the freq field. So, while FORMAT is doing what you ask it to do, what your asking it to do is wrong. You really want to move the decimal point up if the field is listed in KHz. I'm not sure if DxBase allows for the field to be logged in KHz or MHz, I haven't looked.
In any event, it sounds like your at least open to letting people view the source. It is a bummer that Vbasic was used as it's not very portable. I would however, like to view the source. Please send it along and I'll see if I can crank out a Linux version. :) -Brian 73 de W2SUQ > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Thursday, June 27, 2002 04:01 AM > To: [email protected] > Subject: DXBase digest, Vol 1 #169 - 1 msg > > > Send DXBase mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://mailman.qth.net/mailman/listinfo/dxbase > or, via email, send a message with subject or body 'help' to > [EMAIL PROTECTED] > > You can reach the person managing the list at > [EMAIL PROTECTED] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of DXBase digest..." > > > --- This is the DXBase Digest --- > > Today's Topics: > > 1. RE: dxbase2adif 3.1 ADIF 1.0 Specification violation (Cosme > Rubio Flores) > > --__--__-- > > Message: 1 > From: Cosme Rubio Flores <[EMAIL PROTECTED]> > To: "DXbase Reflector ([email protected])" <[email protected]> > Subject: RE: [DXBase] dxbase2adif 3.1 ADIF 1.0 Specification violation > Date: Wed, 26 Jun 2002 18:04:02 +0200 > > Hello folks... > First of all, I'm not agree with the subject. DXbase2Adif and in this > particular case (freq) follow the specification. > > Now I will try to explain > > The follow text is from Microsoft and explain how the FORMAT function = > works, > this is the function that Dxbase2Adif uses to export the value Freq = > inside > Dxbase. > > > ########################################################################= > #### > ####### > > The Format function does not always return the expected number format = > with > certain international settings. This article explains this behavior and > describes how the Format function interprets its parameters.=20 > > > > MORE INFORMATION > A common use of the Format function is to format numbers for a = > consistent > display. To do this, two parameters are passed to Format. The first > parameter is any valid numeric expression, such as 5555.5, "5555.5," = > etc. > The second parameter is a format expression, such as "###,###.00."=20 > > The key point of emphasis is this: if the first parameter is a string > representation of a number, such as "5555.5," Format expects it to be = > in the > proper regional setting as portrayed in Control Panel / Regional = > Settings. > However, Format always expects the second parameter to be in the = > "English > (United States)" setting.=20 > > For example, if the regional setting is such that the decimal symbol is = > "," > and the digit grouping symbol is ".", the following will occur:=20 > > Format(5555.5, "###,###.00") returns "5.555,50"=20 > Format("5555,5", "###,###.00") returns "5.555,50"=20 > Format("5.555,5", "###,###.00") returns "5.555,50"=20 > > Format("5555.5", "###,###.00") returns "55.555,00"=20 > Format("5,555.5", "###,###.00") returns "5,56"=20 > With the regional setting as described above, the number 5555.5 and the > string "5555.5" are interpreted quite differently by Format. > ########################################################################= > #### > ###### > > And now, this the code used in DXbase2Adif for this particular field > > QSOFREQ =3D Format((Val(.Fields(12))), "###,###.00") > =20 > QSOFREQ =3D "<FREQ:" & Len(QSOFREQ) & ">" & QSOFREQ > > Where: > QSOFREQ is a String. > .Fields(12) is the field Freq in Dxbase mdb file (always has this = > format > NNNN.NN or NNNN.N, ie. 21200.00 or 21200.0) > Format is the Function. > Val is a function that returns the numbers contained in a string as a > numeric value of appropriate type.The Val function recognizes only the > period (.) as a valid decimal separator. > Len is a function that calculate the lenght of the string. > > DXbase2Adif work in this way: > > 21.200,00=3DFormat((Val(21200.00))), "###,###.00") > <FREQ:9>21.200,00=3D"<FREQ:" & Len(21.200,00) & ">" & 21.200,00 > > Yo can see that I respect the second parameter of Format (###,###.00) = > and > this parameter is under the US Settings. > > Then.....where is the bug?? > > I don't know if all the U.S users has the same problem (I hope no). > > > About the open source... > If some of the users know Vbasic, it will be a pleasure to send it the > source code to improve the program, but some ocx's controls are > Comercial and if someone has not the licence, DXbase2Adif don't work. > > Any input are welcome. > > 73' de Cosme EA3TB > > > =20 > > > ->-----Mensaje original----- > ->De: Tony Cash [KD4K] [mailto:[EMAIL PROTECTED] > ->Enviado el: mi=E9rcoles 26/junio/02 05:37 > ->Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] > ->CC: DxBase Reflector > ->Asunto: Re: [DXBase] dxbase2adif 3.1 ADIF 1.0 Specification violation > -> > -> > ->I also think the suggestion is a good one. > ->I had to write a script here also (some time back) > ->Hope this neat program can be corrected. > -> > ->73 de Tony, KD4K > -> > ->My Weather page =3D http://home.adelphia.net/~tonycash > ->My Ham Page =3D http://home.adelphia.net/~tonycash/kd4k/radio.html > ->147.150 Repeater Page =3D http://home.adelphia.net/~tonycash/sawnee/ > -> > ->----- Original Message ----- > ->From: "Brian Boerner" <[EMAIL PROTECTED]> > ->To: <[EMAIL PROTECTED]> > ->Cc: "DxBase Reflector" <[email protected]> > ->Sent: Tuesday, June 25, 2002 9:36 PM > ->Subject: [DXBase] dxbase2adif 3.1 ADIF 1.0 Specification violation > -> > -> > ->> It appears the frequency is exported as 14,037 instead of=20 > ->14.037 as per > ->the > ->> specification. > ->> > ->> The spec says FREQ N in MHz not KHz. > ->> > ->> My DxBase 2002 exported file looks like: > ->> > -><QSO_DATE:8>20010926<TIME_ON:4>0317<CALL:5>3B8CF<RST_SENT:3>51 > ->9<RST_RCVD:3>5 > ->> 59<NAME:12>Seewoosankar<QTH:14>Quartre > ->> > ->Bornes<MODE:2>CW<FREQ:6>14,027<BAND:3>20m<PFX:3>3B8<QSL_RCVD:1 > ->>N<QSL_SENT:1> > ->> Y<QSLSDATE:8>20011110<QSL_VIA:6>BUREAU<MGR_NUMBER:1>1<EOR> > ->> > ->> Please Note: <FREQ:6>14,027 where it should be <FREQ:6>14.027. > ->> > ->> After writing a quick script to parse this out and correct=20 > ->it, it imported > ->> just fine. > ->> > ->> Overall I think this program works really well and I've=20 > ->copied the DxBase > ->> folks so they are aware. I do however have a single=20 > ->suggestion that might > ->> make things easier on you. Since your not actually charging=20 > ->any money for > ->> this beast, why not open it up to the open source=20 > ->community. If I had the > ->> source code for this, I would have simply fixed the bug,=20 > ->recompiled, and > ->> sent you the diff so you can make the change to the global=20 > ->pool. Just a > ->> thought. > ->> > ->> Thanks. > ->> -Brian > ->> 73 de W2SUQ > ->> > ->> _______________________________________________ > ->> DXBase Reflector - Please visit us on the web at www.dxbase.com > ->> - - - - - - - - - - - - - - - - - - - - - - - > ->> To UNSUBSCRIBE please visit: > ->> http://mailman.qth.net/mailman/listinfo/dxbase > ->> > -> > -> > ->_______________________________________________ > ->DXBase Reflector - Please visit us on the web at www.dxbase.com > ->- - - - - - - - - - - - - - - - - - - - - - -=20 > ->To UNSUBSCRIBE please visit: > ->http://mailman.qth.net/mailman/listinfo/dxbase > -> > > > --__--__-- > > _______________________________________________ > DXBase mailing list > [email protected] > http://mailman.qth.net/mailman/listinfo/dxbase > > > End of DXBase Digest
