Search Results for "csv awk"

AWK was released in 1977, which makes it over 40 years old! Not bad for a domain-specific language that’s still used for one-liners on Unix command lines everywhere. GoAWK is a POSIX-compatible version of AWK, and additionally has a CSV mode for reading and writing CSV and TSV files. This feature was sponsored by the library of the University of Antwerp.

Miller is like awk, sed, cut, join, and sort for data formats such as CSV, TSV, JSON, JSON Lines, and positionally-indexed. With Miller, you get to use named fields without needing to count positional indices, using familiar formats such as CSV, TSV, JSON, JSON Lines, and positionally-indexed. Then, on the fly, you can add new fields which are functions of existing fields, drop fields, sort, aggregate statistically, pretty-print, and more.

AWK is a fascinating text-processing language, and somehow after reading the delightfully-terse The AWK Programming Language I was inspired to write an interpreter for it in Go. Licensed under MIT license Source: https://github.com/benhoyt/goawk Visit: http://albanese.atwebpages.com

Copyright © 2014 Neil Butterworth. If you have any dealings at all with data and databases, then you almost certainly will have to deal with comma-separated values (CSV) data. Unfortunately, the CSV files you are given, or are required to produce, never seem to be in quite the right format for your particular business application. And because of the structure of CSV records, using standard text processing tools like sed, awk and perl is not as simple as it might be. Usage: http://csvfix.byethost5.com/csvfix15/csvfix.html?...

Elevations moves data from Excel to Unix systems. It connects VBA with Cygwin SSH, CGI and HTTP POST to deliver to a QuantLib C++ server through pipes. Provides C++ classes to process CSV files and the strings to C++ types. File schema definitions.

...The advantages by using CSV as input and output are the following: - Many applications allow an export of its data to CSV or Excel(were it could be saved to CSV) - It is possible to pre- and postprocess the data, e.g removing version numbers before comparing - It is easy to create CSV data from logfiles and other resources by using unix tools like sed or awk - CSV can be loaded into other applications, especially Excel, were it can be formatted by macros for analyzing.

AwkStatistics is a script which is used to generate statistical data for csv data by using awk. It takes two columns from the input file, one is used to identify the row(option -i) and the other one is the column where the values are taken from (option -v). The script was designed for performance engineers to be able to analyze CSV-Data on the fly and have a good possibility to automate the analysis process.

logjoin is a tool for joining two log files (or any kind of CSV output) on a common column and concatenates the result, thus simulating MySQL join command between two files. With the help of parsers like awk it can give useful reports. Examples: * Joining two log files by their 4th and 3rd column giving result in result.txt logjoin -v -o result.txt -j 4=3 leftlog.txt rightlog.txt * Inner-join of two log files on their first columns logjoin -i leftlog.txt rightlog.txt > result.txt * Inner-join of leftlog.txt and rightlog.txt on 2nd and 3rd column and join with thirdlog on 1st and 2nd cat leftlog.txt | logjoin -i -j 2=3 rightlog.txt | logjoin -j 1=2 thirdlog.txt It depends on command-line parser library at http://tclap.sourceforge.net/

These three tools build Checkpoint, Cisco ASA or Netscreen policys from logfiles. They write dbedit, access-list or set address, set service and set policy commands for the traffic seen in the logs, that can be cut and pasted into the firewalls. WOOT

This command-line tool will help people who want to compare 2 csv-like files, and get a detailed report on which rows and fields differ between both files. An awk-based version and Perl Version is currently available.