• another teaser for the batch gurus, resolve to whole numbers

    From Richard Webb@1:116/901 to all on Wed Feb 10 13:44:38 2010
    Hello all!


    Looking for a way to resolve numbers found in a text file
    which would appear with a decimal point and up to 9 places
    afterword.


    Timo from Finland has a great little batch calculator, but
    there are times when although it's working with whole
    numbers for inputs the trailing zeroes are superfluous.

    YEs I could stuff those variables into an environment
    variable and use Horst's count, which I may do in some
    applications, but often for batches called from batches
    invoked from other batches TImo's batch calculator runs more reliably.



    Regards,
    Richard
    --- timEd 1.10.y2k+
    * Origin: Radio REscue net operations BBS (1:116/901)
  • From Paul Quinn@3:640/384 to Richard Webb on Thu Feb 11 10:41:57 2010
    Hi! Richard,

    On 10 Feb 10 13:44, you wrote to all:

    Looking for a way to resolve numbers found in a text file
    which would appear with a decimal point and up to 9 places
    afterword.

    Beats me. I've never had a need. There's some interesting-looking utils in the BFDS library but I don't have any on hand to recommend. Ben Ritchey (1:393/68) may be able to point you to something. One that did look likely (based on its listing) was:

    VPCALC24.ZIP 142,240 05-14-00 04:30:40
    Variable Precision Calculator for batch file operation.

    Caveat emptor: I don't have it here and have -never- used it.

    Timo from Finland has a great little batch calculator, but

    [ ...trimmed... ]

    invoked from other batches TImo's batch calculator runs more
    reliably.

    It's probably best to stick with what you know and love to use. Have fun!

    Cheers,
    Paul.

    ... "Hey! Who took the cork off my lunch?!?" - W.C. Fields.
    --- GoldED+/LNX 1.1.4.7
    * Origin: Quinn's Post - Maryborough, Queensland, OZ (3:640/384)
  • From Richard Webb@1:116/901 to Paul Quinn on Thu Feb 11 13:39:54 2010
    Hi Paul,

    On Thu 2038-Feb-11 10:41, Paul Quinn (3:640/384) wrote to Richard Webb:

    Looking for a way to resolve numbers found in a text file
    which would appear with a decimal point and up to 9 places
    afterword.

    Beats me. I've never had a need. There's some interesting-looking
    utils in the BFDS library but I don't have any on hand to recommend.
    Ben Ritchey (1:393/68) may be able to point you to something. One
    that did look likely (based on its listing) was:

    VPCALC24.ZIP 142,240 05-14-00 04:30:40
    Variable Precision Calculator for batch file
    operation.

    Might have a look at that, since last time I tried I had
    good pots connects with Ben's system. THink I meant to dl
    one of his big bfds cataloguings as well.

    Caveat emptor: I don't have it here and have -never- used it.

    Timo from Finland has a great little batch calculator, but

    [ ...trimmed... ]

    invoked from other batches TImo's batch calculator runs more
    reliably.

    It's probably best to stick with what you know and love to use.
    Have fun!

    YEp, as I say, a lot of this could be done with HORst's
    count which increments or decrements an environment
    variable, but sometimes we end up nested two and three deep, then the batch doesn't have what it needs. Just
    brainstorming to myself the other night while putting
    together some radio messaging network stats and check the
    robot's work <g>.
    I often go through those reports, and with these decimal
    figures round up to next .1 or down awhichever is
    appropriate according to the rules we learned in grammar
    school <g>. IN fact, I had one guy who cried
    (figurativelyof couse) about my reports showing percentages
    like American baseball batting averages, i.e 50% was .50000
    etc. SO we added lines in the batch that made that report
    to do the multiplication so he'd get his percentages as he
    was accustomed to seeing them <g>.

    Regards,
    Richard
    --- timEd 1.10.y2k+
    * Origin: Radio REscue net operations BBS (1:116/901)
  • From Richard Webb@1:116/901 to Paul Quinn on Thu Feb 11 15:12:54 2010
    Hi Paul,

    following up a message from Richard Webb to Paul Quinn:

    <snippety doo dah>
    Beats me. I've never had a need. There's some interesting-looking
    utils in the BFDS library but I don't have any on hand to recommend.
    Ben Ritchey (1:393/68) may be able to point you to something. One
    that did look likely (based on its listing) was:

    VPCALC24.ZIP 142,240 05-14-00 04:30:40
    Variable Precision Calculator for batch file
    operation.

    Might have a look at that, since last time I tried I had
    good pots connects with Ben's system. THink I meant to dl
    one of his big bfds cataloguings as well.

    Caveat emptor: I don't have it here and have -never- used it.

    That's the way I am here with a lot of things, but I"ve
    found some real gems here and there. Think it was his
    system where I grabed an ms word to ascii converter that
    runs beautifully from a batch. IN fact, I have an auomagic
    routine runs in my morning event that looks in the directory where I dump all received emails I might want to save in
    other than reader's native format for *.doc files, moves
    them to the antiword directory, creates a batch from the
    filenames it moves, runs antiword across each one outputting same file name as *.txt then deletes the *.doc files and
    moves the *.txt files somewhere else and sends me the list
    as a message in my local private msg area <g>.

    Now, if I could just find a cool and easy way to do .xls to
    something dBase could import without knowing the database
    structure first etc. I'll still cogitate on that one, as
    I'll maybe want it if I retain this leadership position in a ham radio organization. But, I've got pretty much all the
    net managers trained to send me the real important stats as
    plaintext as well as attaching the *.xls with all the
    minutiae. Still it would be cool to be able to look at sai
    fine resolution data <g>.

    Timo from Finland has a great little batch calculator, but
    Yep, but might look at that one you pointed me to as well.
    I usually grab something, play with it in a noncritical
    application for a couple of days, find out if I really like
    it better, then plug it into existing batches etc. if I
    really do. Otherwise, I just put it in my file base.
    There's another math related prg Ben pointed me at in
    response to another query I made here which I grabbed,
    played with a few hours and decided that it was too complex for me to really figure out if it suited without a whole
    bunch more intermediate processing to make it work, but
    would play later when I decided to set the current system up to save the data files for me to play with later, and never
    got one of those round tuit things <g>. The bug will bite
    some day though <grin>.


    I maybe ought to mention it to a new face
    that's shown up in the dosinternet echo lately. Note he
    mentioned sed in an msg I read earlier this morning, so if
    he's not aware of it he might really appreciate the pointer
    to Ben's system.

    It's probably best to stick with what you know and love to use.
    IT is, but sometimes exploring is fun too, and as noted
    above, sometimes I find the better tool for a job i'm
    already getting done. I don't laugh at tools anymore.
    sOrt of off topic for this echo, but related to tools, my
    lady gave me a flashlight a few years ago with a tookit
    stored in its belly. She bought the stupid thing around
    Christmastime since my birthday is right before Christmas,
    and it was available in an Avon catalogue. You know, the
    ladies' and mens' cologne and cosmetics folks. Reason she
    bought it: I was always tired of hassling with those little sets of Allen wrenches and never having the right sized one
    around when I wanted it. Since the emergency backpack
    always went along to a sound or musical job a flashlight
    would be something would go in said backpack, so if the
    flashlight was there I'd have a complete set of allens. I
    said cool, put some batteries in the flashlight and figured
    the tools inside were a joke.

    Then during Katrina nobody could find the right sized wrench to do the switcharoo to different battery systems for the
    ham radios. SIlly me for thinking we had the right tool in
    the cabinets or drawers in the radio room <g>. so, I pull
    open the little silly flashlight thing, open its belly, and
    there's the right tool, and even usable. I promised myself
    I'd never laugh at "cute" tools again.


    Otoh my mil gave me one of those all-in-one driver sets with an articulated handle, and though it has a great variety of
    screw and nut drivers the stupid handle means you can't
    exert enough force when you need it because the handle won't let you <g>.


    Regards,
    Richard
    --- timEd 1.10.y2k+
    * Origin: Radio REscue net operations BBS (1:116/901)
  • From mark lewis@1:3634/12 to Richard Webb on Thu Apr 15 13:17:27 2010

    Now, if I could just find a cool and easy way to do .xls to
    something dBase could import without knowing the database
    structure first etc.

    this shold be something such as CSV (Comma Separated Values)... but, even with the fields header line, there's no structure info... you really should know what data you are getting before you go to make a database and app out of it :P
    ;)

    )\/(ark


    * Origin: (1:3634/12)
  • From Richard Webb@1:116/901 to mark lewis on Fri Apr 16 00:13:19 2010
    HI Mark,

    On Thu 2038-Apr-15 13:17, mark lewis (1:3634/12) wrote to Richard Webb:

    Now, if I could just find a cool and easy way to do .xls to
    something dBase could import without knowing the database
    structure first etc.

    this shold be something such as CSV (Comma Separated Values)... but,
    even with the fields header line, there's no structure info... you
    really should know what data you are getting before you go to make a database and app out of it :P ;)
    Yup, which is why the only way to do it is crack open the
    raw files and figure it out.
    THe guy whose web site emails me the boats data wants me to
    submit my loggings to his logger pgm. THey're comma
    delimited, and that part's easy, but not sure what to do if
    I don't have something for a field yet. WE're still in
    talking stages, but I've got a piece of his data to work
    with. A lot of the guys that use it do the lookups, or the
    site does in realtime for call signs.

    WE both sort of put that project on the shelf though, as he
    moved house, then moved jobs, but I"m sure he'll bring it
    back up again.


    kRegards,
    Richard
    --- timEd 1.10.y2k+
    * Origin: (1:116/901)
  • From mark lewis@1:3634/12 to Richard Webb on Fri Apr 16 18:18:28 2010

    Now, if I could just find a cool and easy way to do .xls to
    something dBase could import without knowing the database
    structure first etc.

    this shold be something such as CSV (Comma Separated Values)... but,
    even with the fields header line, there's no structure info... you
    really should know what data you are getting before you go to make a database and app out of it :P ;)
    Yup, which is why the only way to do it is crack open the
    raw files and figure it out.
    THe guy whose web site emails me the boats data wants me to
    submit my loggings to his logger pgm. THey're comma
    delimited, and that part's easy, but not sure what to do if
    I don't have something for a field yet.

    you leave it blank... for example... here's a quickie with 4 fields... the 3rd one is empty... you might need to turn on your setting to hear punctuations...

    field1,field2,,field4

    if the last field is empty, there's still the comma for it... for example...

    field1,field2,field3,

    here's one with all fields empty...

    ,,,

    still the same 4 fields but just on data in any of them... you can turn off your punctuation setting now ;)

    WE're still in talking stages, but I've got a piece of his data
    to work with. A lot of the guys that use it do the lookups, or the
    site does in realtime for call signs.

    WE both sort of put that project on the shelf though, as he
    moved house, then moved jobs, but I"m sure he'll bring it
    back up again.

    i hear ya...

    )\/(ark


    * Origin: (1:3634/12)
  • From Richard Webb@1:116/901 to mark lewis on Sat Apr 17 00:34:13 2010
    HI Mark,

    On Fri 2038-Apr-16 18:18, mark lewis (1:3634/12) wrote to Richard Webb:

    THe guy whose web site emails me the boats data wants me to
    submit my loggings to his logger pgm. THey're comma
    delimited, and that part's easy, but not sure what to do if
    I don't have something for a field yet.

    you leave it blank... for example... here's a quickie with 4
    fields... the 3rd one is empty... you might need to turn on your
    setting to hear punctuations...

    field1,field2,,field4

    if the last field is empty, there's still the comma for it... for example...

    YEp, how I perceived it. I've got to talk to him a little more. THink it's doable. I took a cursory look at the
    sample datat file he sent me, but then we put the project on hold. I"m sure that now he's getting settled in at new job
    and house we'll revisit the idea nad start playing with some data however.


    - Origin: (1:3634/12)

    Regards,
    Richard
    --- timEd 1.10.y2k+
    * Origin: (1:116/901)