|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to compare the columns in two .csv files?
Post 302528944 by Kanchana on Wednesday 8th of June 2011 09:32:13 AM
06-08-2011
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
need to compare 2 csv files and report should containg number of matching lines,different lines ,missing lines in one file using perl.
I dont want to use read line by line and scan thru the second file for matching line ,as this logic was so time consuming .Any ideas.i need the soultion badly .... (2 Replies)
Discussion started by: kittu1979
2 Replies
2. Shell Programming and Scripting
Hi all,
Am new to scripting. So i just need your ideas to help me out. Here goes my requirement.
I have two csv files
1.csv 2.csv
abc,1.24 abc,1
def,2.13 def,1
I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Discussion started by: chinnahyd
2 Replies
3. Shell Programming and Scripting
Hiiiii friends
I have 2 files which contains huge data & few lines of it are as shown below
File1: b.dat(which has 21 columns)
SSR 1976 8 12 13 10 44.00 39.0700 70.7800 7.0 0 0.00 0 2.78 0.00 0.00 0 0.00 2.78 0 NULL
ISC 1976 8 12 22 32 37.39 36.2942 70.7338... (6 Replies)
Discussion started by: reva
6 Replies
4. Shell Programming and Scripting
Hi all,
Could someone help me with the following issue:
1st
I have an CSV file delimiter is ";" I I have a column 7 where I need to do some multiple mathem. operation, I need all values in this columns to be multiplied by 1.5 and create a new CSV file with the replaced values.
2nd.
I... (3 Replies)
Discussion started by: kl1ngac1k
3 Replies
5. Shell Programming and Scripting
(say) I have 2 csv files - file1.csv & file2.csv as mentioned below:
file1.csv
ID,version,cost
1000,1,30
2000,2,40
3000,3,50
4000,4,60
file2.csv
ID,version,cost
1000,1,30
2000,2,45
3000,4,55
6000,5,70
The... (7 Replies)
Discussion started by: Naresh101
7 Replies
6. Shell Programming and Scripting
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies
7. Shell Programming and Scripting
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies
8. Shell Programming and Scripting
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies
9. Shell Programming and Scripting
I have 8 .csv files with 16 columns and "n" rows with no Header. I want to parse each of these .csv and get column and put the data into a new.csv. Once this is done, the new.csv should have 16 columns (2 from each input.csv) and "n" rows.
Now, I want to just take the average of Column from... (3 Replies)
Discussion started by: Zam_1234
3 Replies
10. Shell Programming and Scripting
Hello,
I want to compare two csv files expected.csv and actual.csv by fields "f3", "f4", "f5". Field "z" can be differnt.
Each record identified by two fields: "number" +"key".
Records are not sorted.
Can you please help me to get such report:
Error: Mismatch in the record... (4 Replies)
Discussion started by: Eugenne
4 Replies
LEARN ABOUT CENTOS
setarch
SETARCH(8) System Administration SETARCH(8) NAME
setarch - change reported architecture in new program environment and set personality flags SYNOPSIS
setarch <arch> [options] [program [arguments]] arch [options] [program [arguments]] DESCRIPTION
setarch This utility currently only affects the output of uname -m. For example, on an AMD64 system, running 'setarch i386 program' will cause 'program' to see i686 (or other relevant arch) instead of x86_64 as machine type. It also allows to set various personality options. The default program is /bin/sh. OPTIONS
-v, --verbose Be verbose. -h, --help Display help (it is also displayed when setarch takes no arguments). -V, --version Output version information and exit. --uname-2.6 Causes the program to see a kernel version number beginning with 2.6. -3, --3gb Specifies that processes should use a maximum of 3GB of address space on systems where it is supported (ADDR_LIMIT_3GB). --4gb Ignored (for backward compatibility only). --list List architectures that can be set. -B, --32bit Turns on ADDR_LIMIT_32BIT. -F, --fdpic-funcptrs Userspace function pointers point to descriptors (turns on FDPIC_FUNCPTRS). -I, --short-inode Turns on SHORT_INODE. -L, --addr-compat-layout Changes the way virtual memory is allocated (turns on the ADDR_COMPAT_LAYOUT). -R, --addr-no-randomize Disables randomization of the virtual address space (turns on ADDR_NO_RANDOMIZE). -S, --whole-seconds Turns on WHOLE_SECONDS. -T, --sticky-timeouts Turns on STICKY_TIMEOUTS. -X, --read-implies-exec Turns on READ_IMPLIES_EXEC. -Z, --mmap-page-zero Turns on MMAP_PAGE_ZERO. EXAMPLES
setarch ppc32 rpmbuild --target=ppc --rebuild foo.src.rpm setarch ppc32 -v -vL3 rpmbuild --target=ppc --rebuild bar.src.rpm setarch ppc32 --32bit rpmbuild --target=ppc --rebuild foo.src.rpm AUTHOR
Elliot Lee <sopwith@redhat.com> Jindrich Novy <jnovy@redhat.com> AVAILABILITY
The setarch command is part of the util-linux package and is available from Linux Kernel Archive <ftp://ftp.kernel.org/pub/linux/utils /util-linux/>. util-linux September 2011 SETARCH(8)