I want to compare two files with same number of rows and columns with records in same order.
Just want to highlight the differences in the column values if any.
file A
Code:
1,kolkata,19,ab
2,delhi,89,cd
3,bangalore,56,ef
file2:
Code:
1,kolkata,21,ab
2,mumbai,89,gh
3,bangalore,11,kl
considering column 1 as primary key, we have differences in other columns.
i want to highlight those differences
Output format may be (not sure ):
Code:
record_number , columns_with_diff
1 3
2 2,4
3 3,4
does diff or comm can solve my problem ? if yes then what would be the exact command.. m trying but not getting
Last edited by Scrutinizer; 06-24-2014 at 10:05 AM..
Reason: CODE tags ; removed empty lines
I am very new to Unix. What are the similiarities and differences between ScoUnix and AIX5 if any? Where might i find the information? Which is better? (1 Reply)
i want to know the similarities and disimilarities of Unix and Windows file systems . methods of file , file orgsnization , meaning of file extension , file and disk fragments :confused::confused: (1 Reply)
Hello Everybody!!!!!!!!! Request you to help me with the below mentioned issue:
I have 2 files say,
File 1:
a|4|7
b|3|2
c|8|8
d|8|9
File 2:
a|4|6
b|2|2
c|8|8
d|9|8
The third file(output file) should have:
Data mismatch in row 1 column 3
Data mismatch in row 2 coumn 2
Data... (3 Replies)
Hello everyone!!!!! Need some help on inserting data in a file columnwise.
Example:
File1:
1|AAA|25|2
5|qqe|20|7
4|wer|31|81
I need to create a second file in which data can be inserted in a columnwise manner i.e.
File2:
AAA|25|1|2
qqe|20|5|7
wer|31|4|81
The order of columns in... (1 Reply)
Hello everyone!!!!! Need some help on inserting data in a file columnwise.
Example:
File1:
1|AAA|25|2
5|qqe|20|7
4|wer|31|81
I need to create a second file in which data can be inserted in a columnwise manner i.e.
File2:
AAA|25|1|2
qqe|20|5|7
wer|31|4|81
The order of columns in... (1 Reply)
Hi ,
I have a CSV file that has around 50K records in it. I have to delete all the duplicate rows from the file except one, depending upon data in column4.
Lets say there are 3 rows for 'column4data' in the file. I have to retain only that line which has the smallest date value in column2.... (3 Replies)
Hi All,
I want to trim each columns leading & trailing (like sql trim function) of a ',' separated file..
I've a file like this..
manab , c gi
lucky , home
babu , maa
I want the output as
manab,c gi
lucky,home
babu,maa
A one liner would be a great help. (2 Replies)
hi guys, i want help... Reding XML file and print the values into the text file using linux shell script file as per below xml file
<sequence>
<Filename>aldorzum.doc</Filename>
<DivisionCode>US</DivisionCode>
<ContentType>Template</ContentType>
<ProductCode>VIMZIM</ProductCode>
</sequence>... (4 Replies)
I have two files which has component name and version number separated by a space
cat file1
com.acc.invm:FNS_PROD 94.0.5
com.acc.invm:FNS_TEST_DCCC_Mangment 94.1.6
com.acc.invm:FNS_APIPlat_BDMap 100.0.9
com.acc.invm:SendEmail 29.6.113
com.acc.invm:SendSms 12.23.65
cat file2 ... (8 Replies)
Discussion started by: rakeshtomar82
8 Replies
LEARN ABOUT OSX
colrm
COLRM(1) BSD General Commands Manual COLRM(1)NAME
colrm -- remove columns from a file
SYNOPSIS
colrm [start [stop]]
DESCRIPTION
The colrm utility removes selected columns from the lines of a file. A column is defined as a single character in a line. Input is read
from the standard input. Output is written to the standard output.
If only the start column is specified, columns numbered less than the start column will be written. If both start and stop columns are spec-
ified, columns numbered less than the start column or greater than the stop column will be written. Column numbering starts with one, not
zero.
Tab characters increment the column count to the next multiple of eight. Backspace characters decrement the column count by one.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7).
EXIT STATUS
The colrm utility exits 0 on success, and >0 if an error occurs.
SEE ALSO awk(1), column(1), cut(1), paste(1)HISTORY
The colrm command appeared in 3.0BSD.
BSD August 4, 2004 BSD
06-24-2014
File comparison in UNIX columnwise
