Sort by record column, Compare with conditons and export the result


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Sort by record column, Compare with conditons and export the result
# 1  
Old 02-12-2018
Sort by record column, Compare with conditons and export the result

Hello,

I am new to Unix and would like to seek a help, please.

I have 2 files (file_1 and file_2), I need to perform the following actions.
1 ) Sort the both file by the column 26-36 (which is Invoice number)
what is sort command with the column sort?

2) Compare the file_1.sorted and file_2.sorted. I would like Unix to ignore the difference when the differences are data stamp.
The data stamp is in Record 0010 and Record 2000. (Record ID is in column 92-95)
Date stamp in Record 0010 is in the column 451 -471.
Date stamp in Record 2000 is in the column 356 -385.
My goal is only displays the difference other than the date stamps.
what is the Unix command for the compare?

3) Would like to set nowrap and export the result in text file.

Thank you so much for your help in advance.
Usagi
# 2  
Old 02-13-2018
Welcome to the UNIX & Linux Forums. When starting a new thread in the UNIX for Beginners Questions & Answers forum, please always tell us what operating system (including version number) and shell (including version number) you're using.

Please also show us (in CODE tags) short sample file_1 and file_2 input files and the exact output(s) you are trying to produce from those two input files.

The UNIX sort utility is designed to sort fields within a text file where fields are delimited by a string of one or more <space> and <tab> characters or by each occurrence of a specified field delimiter character. If we know what characters are expected in your data file, we might be able to choose a delimiter character that should never appear in your data files and then select offsets within the only field in each line that correspond to the display columns you want to sort.

One might also be able to use awk to process your two input files and produce the output you want without sorting either of your input files, but again we need to know in detail what your input files look like and what output you're trying to produce.
# 3  
Old 02-19-2018
hello Usagi,
provide contents of the file you want to process and also tell us a little bit about what you have tried already.
Thanks.
# 4  
Old 02-19-2018
Code:
1. sort -dib -k26n,36n -o file_1.sorted file_1 
    sort -dib -k26n,36n -o file_2.sorted file_2

2. diff -aib -W222 file_1.sorted  file_2.sorted

3.
Code:
-W

option is width limit (max char.) for a line to prevent line wrap

Last edited by abdulbadii; 02-20-2018 at 06:54 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Add column and multiply its result to all elements of another column

Input file is as follows: 1 | 6 2 | 7 3 | 8 4 | 9 5 | 10 Output reuired (sum of the first column $1*$2) 1 | 6 | 90 2 | 7 | 105 3 | 8 | 120 4 |9 | 135 5 |10 | 150 Please enclose sample input, sample output, and code... (5 Replies)
Discussion started by: Sagar Singh
5 Replies

2. Shell Programming and Scripting

Split column data if the table has n number of column's with some record

Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records Table --------- Col1 col2 col3 col4 ....................col20 1 2 3 4 .................... 20 a b c d .................... v ... (11 Replies)
Discussion started by: Priti2277
11 Replies

3. Shell Programming and Scripting

How to compare the current result with previous line result.?

Hi Gurus, I have requirement to compare current result with previous reuslt. The sample case is below. 1 job1 1 1 job2 2 1 job3 3 2 job_a1 1 2 job_a2 2 2 job_a3 3 3 job_b1 1 3 job_b2 2 for above sample file, GID is group ID, for input line, the job run... (1 Reply)
Discussion started by: ken6503
1 Replies

4. UNIX for Dummies Questions & Answers

Match sum of values in each column with the corresponding column value present in trailer record

Hi All, I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record. For example, let's assume for column D... (9 Replies)
Discussion started by: tpk
9 Replies

5. Shell Programming and Scripting

Problem facing to compare different column and print out record with smallest number

Hi, Input file 1 : 37170 37196 77 51 37174 37195 73 52 37174 37194 73 53 Desired Output file 1 : 37170 37196 77 51 Input file 2 : 37174 37195 73 0 37170 37196 77 0 Desired Output file 2 : 37174 37195 73 0 (1 Reply)
Discussion started by: cpp_beginner
1 Replies

6. Shell Programming and Scripting

How to compare current record,with next and previous record in awk without using array?

Hi! all can any one tell me how to compare current record of column with next and previous record in awk without using array my case is like this input.txt 0 32 1 26 2 27 3 34 4 26 5 25 6 24 9 23 0 32 1 28 2 15 3 26 4 24 (7 Replies)
Discussion started by: Dona Clara
7 Replies

7. UNIX for Advanced & Expert Users

How to export Result to Excel Tabular format from UNIX?

Hi I am working on a script in which I am firing a query on database through Unix and getting the result set. I want to export that in an excel file. I am able to do so nut the result are exported horizontally one below the other. Can anyone plss help me out in exporting the Result in Tabular... (4 Replies)
Discussion started by: Saritau3
4 Replies

8. Shell Programming and Scripting

start searching a word from the particular record on the result of first occurence change the value

Hi, I need a script to start searching a word from the particular record on the result of first occurence i need to change the value in that record. I have a input file like this <properties> <add key="DeliveryWithinDay" value="False" /> <add key="ABC" value="23:00:00 PM" /> <add... (5 Replies)
Discussion started by: NareshN
5 Replies

9. Shell Programming and Scripting

Compare to files and export only different values

Hello, I need to compare two files which have the following structure File1: No : 1 Name : George/Brown Value2 : type2 Value3 : type3 Date : Wed Oct 20 11:12:58 2010 Value : yes No : 2 Name : John/Cash Value2 :... (4 Replies)
Discussion started by: @dagio
4 Replies

10. UNIX for Dummies Questions & Answers

find common lines using just one column to compare and result with all columns

Hi. If we have this file A B C 7 8 9 1 2 10 and this other file A C D F 7 9 2 3 9 2 3 4 The result i´m looking for is intersection with A B C D F so the answer here will be (10 Replies)
Discussion started by: alcalina
10 Replies
Login or Register to Ask a Question