1. Forum
  2. Usenet
  3. COMP.UNIX.SHELL

  • Miller (Was: sort by multiple columns)

    From Kenny McCormack@21:1/5 to [email protected] on Fri May 5 14:53:24 2023
    In article <[email protected]>,
    Martin rautmann <[email protected]> wrote:
    On Fri, 5 May 2023 12:26:56 -0000 (UTC), Kenny McCormack wrote:
    In article <[email protected]>,
    Martin rautmann <[email protected]> wrote:
    On Fri, 5 May 2023 10:35:01 +0200, Dr Eberhard W Lisse wrote:
    mlr --fs 'semicolon' --ocsv --hi --ho --from t.ssv sort -n 4 -f 2,3

    miller looks very powerful to me, but unfortunately it's not available here. >>
    Some sort of import/export restriction in your country?

    Error: Port miller requires a full Xcode installation, which was not
    found on your system.

    ...and I've not enough space for that, 256 GB SSD only.

    (Quoting Arte Johnson) Interesting... But not very.

    I did a little research on "Miller" (which I had never heard of before
    today). I don't see the point of it. It just seems like another AWK (or
    Perl or Ruby or Python or ...). I.e., what I am saying is that the only
    reason to use the "traditional" Unix tools (cut, join, comm, sort, sed,
    grep, etc, etc) is because you just don't want to learn anything new (*).
    If you were going to learn something new, just learn AWK - which can do all
    the things that any/all of those "traditional" tools can do - and much more. Why bother to learn this "Miller" thing?

    (*) Or for pedagogical reasons. I sometimes see people - who obviously
    know better - post sed | grep | cut | sed | sort | grep | ...
    pipeliners on various boards because they assume their audience is more comfortable that way.

    Finally, I note that you mentioned Xcode. That's a Mac/Apple thing. Is
    this "Miller" a specifically Apple thing?

    --
    To be evangelical is to spend every waking moment hovering around
    two emotional states: fear and rage. Evangelicals are seriously the
    angriest and most vicious bunch of self-pitying, constantly-moaning
    whinybutts I've ever encountered.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin =?UTF-8?Q?=CE=A4rautmann?=@21:1/5 to Kenny McCormack on Sat May 6 09:54:51 2023
    On Fri, 5 May 2023 14:53:24 -0000 (UTC), Kenny McCormack wrote:
    Finally, I note that you mentioned Xcode. That's a Mac/Apple thing. Is
    this "Miller" a specifically Apple thing?

    Absolutely not. But if I want to install it the easy way I do a
    sudo port install miller
    which does require more of the xcode installation which I acutally have.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dr Eberhard W Lisse@21:1/5 to Kenny McCormack on Sat May 6 16:22:37 2023
    On 05/05/2023 16:53, Kenny McCormack wrote:
    [...]
    (Quoting Arte Johnson) Interesting... But not very.

    I did a little research on "Miller" (which I had never heard of
    before today).

    Obviously not enough research, but then that's a bliss :-)-O

    I don't see the point of it. It just seems like another AWK (or
    Perl or Ruby or Python or ...). I.e., what I am saying is that
    the only reason to use the "traditional" Unix tools (cut, join,
    comm, sort, sed, grep, etc, etc) is because you just don't want
    to learn anything new (*). If you were going to learn something
    new, just learn AWK - which can do all the things that any/all
    of those "traditional" tools can do - and much more. Why bother
    to learn this "Miller" thing?

    Because it is extremely powerful and can do a lot of things awk
    can't do or not do as well or as easily.

    It has become one of a few of my goto tools to slice, dice and
    look at CSV (and variants)

    MILLER
    QSV
    CSVQ
    CSVIEW
    CSVLENS
    (TYPST)

    The first three and typst (which is a new but VERY promising
    typesetting software) are under active development, the other two
    not so much but they are just viewers and stable.

    I have written me a large number of bash functions using
    combinations of the above which make my life (Gynecologist six
    months before retirement, doing my own admin and book keeping)
    much easier (and time is money :-)-O)

    From reconciling bank statements, over declaring Value Added and
    Employees' Tax submitting claims to Funders.

    I have been able to retire some long used Perl Scripts which are
    much longer and in spite of having commented them very well I
    don't understand any more :-)-O

    [...]
    Finally, I note that you mentioned Xcode. That's a Mac/Apple
    thing. Is this "Miller" a specifically Apple thing?

    See above, my research comment.

    That means, in my understanding, that MacPorts wants to compile
    from source and for that it apparently wants the full XCode.

    el

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)