in reply to Handling CSV files

How about fsql ?

The description seems to match your requirements:

fsql lets you perform SQL queries against one or several "flat" files of various formats. Each file will be regarded as a SQL table. By using SQL queries, you can do various calculations or manipulations that are otherwise hard/cumbersome to do with traditional text-manipulating Unix commands like cut, sort, head, tail, uniq, and so on. Particularly: data grouping, joining, or filtering with SQL expressions and functions.

        The best defense against logic is ignorance.

Replies are listed 'Best First'.
Re^2: Handling CSV files
by Tux (Canon) on Oct 21, 2015 at 06:39 UTC

    That app looks fantastic, but be prepared to get half of CPAN installed, as its dependency chain is huge. (Hit the "Dependency graph" in the bottom-right corner of that link)


    Enjoy, Have FUN! H.Merijn
[reply]
      "Service temporarily unavailable" -- slashdotted by Perlmonks?

      Update: JFTR this was an attempt at humour, making fun of the time coincidence.

      (impressive graph, BTW)
[reply]

In Section Seekers of Perl Wisdom