💻 Software

SQL like group by and sum for text files in command line?

Fresh5 days ago

Mar 15, 20266812 views

Confidence Score0%

Problem

I have huge text files with two fields, the first is a string the second is an integer. The files are sorted by the first field. What I'd like to get in the output is one line per unique string and the sum of the numbers for the identical strings. Some strings appear only once while other appear mu…

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: SQL like group by and sum for text files in command line?

Low Risk

In AWK, you could do something like this:

Awaiting Verification

Be the first to verify this fix

SQL like group by and sum for text files in command line?

Problem

1 Fix

Fix for: SQL like group by and sum for text files in command line?

Environment