Search Results

grep -F -x -v -f file2 file1 ?? or any other optimization command

Thanks for the quick reply, Entire line...

sample look-

2036|001|021|92|570|2|422|1|0|0|0|570|0|0|12

Field separate - "|"

File 1 Size ( 60 G)
File 2 Size ( 61 g)
Note - data is not in the sorted order ( file1 and file2)
...

I have 2 large file (.dat) around 70 g, 12 columns but the data not sorted in both the files.. need your inputs in giving the best optimized method/command to achieve this and redirect the not...

Optimization shell/awk script to aggregate (sum) for all the columns of Huge data file

File delimiter "|"
Need to have Sum of all columns, with column number : aggregation (summation) for each...

Thanks , I need to redirect the Distinct column1 and column2 to dis_col1.txt and dis_col2.txt files. File SIze is Huge ( 24 G). Appreciate for your quick reply and time

I have a file size is around 24 G with 14 columns, delimiter with "|"

My requirement- can anyone provide me the fastest and best to get the below results

Number of records of the file
First...

Thanks Singh, command looks good for me. If there are strings in between , can we ignore this and add as NA


A|B
100|50
200|200
DDD|DDD

Expected-

A|B|C
100|50|50%
200|200|100%...

Thanks Don,

Input having only 2 columns A and B

A|B
100|50
200|200

Third column has to be generated with %Percentage ( B/A*100)

Like below -

A|B|C
100|50|50%
200|200|100%...

having two columns, A and B.. i need to add another column C in a file and calculate the percentage based on the column A and B. (COLUMN B/ COLUMN A *100) . "|" is delimiter separating the A and...

I have a file with below config details, File name: test.cfg

Using sed , need to globally search and replace starting after the "-" with the new values.

FactTable1TimeRange=1000-1002...

Thanks a lot Don, It worked. Thanks for your time and Help.

How to Read Multiple Files in a Loop ?

My input file having 10 ZIP files.

Happy Holidays.

count lines in a compressed file ( Unix)

My Zip file having multiple files, without ever writing the (decompressed) file to disk., how i can check the line counts for each of the file

I tried...