Thanks for the reply. So I realized that my data in file 2, it has the Zipcode in column #2, not the last the column. would the command be:
Code:
awk 'FNR==NR {zip[$1]; next} $2 in zip' file1 file2
I tried both versions and nothing was in the output so not really sure.
That's why it is important to post accurate representative information.
To answer your last question: Yes, your modification "should" work if what you are saying is factual. However, since you are not getting any output that could only mean that what you think is not accurate, neither.
Hi All,
I've two .csv files as below
file1.csv
abc, tdf, 223, tpx
jgsd, tex, 342, rpy
a, jdjdsd, 423, djfkld
Where as file2.csv is the new version of file1.csv with some added fields in the end of each line and some additional lines.
lfj, eru, 98, jkldj, 39, jdkj9
abc, tdf, 223, tpx,... (3 Replies)
EDIT: My problems have been solved thanks to the help of bartus11 and pravin27
This code is just to help me learn. It serves no purpose other than that.
Here's a sample csv that I'm working with -
#listofpeeps.csv
Jackie Chan,1954,M
Chuck Norris,1930,M
Bruce Lee,1940,M
This code is... (13 Replies)
Hi!
I'm just new to shell scripting n simple tasks looks so tough in initial stage. i need to write a script which will read a property file, property file will be containing count of the csv files, and in a folder(same folder) there will be respective csv files.
like Property file
data1=100... (3 Replies)
Hi All,
I want to remove the rows from File1.csv by comparing a column/field in the File2.csv. If both columns matches then I want that row to be deleted from File1 using shell script(awk). Here is an example on what I need.
File1.csv:
RAJAK,ACTIVE,1
VIJAY,ACTIVE,2
TAHA,ACTIVE,3... (6 Replies)
Hello,
I have about 10 csv files which range from csv1 - csv10.
Each csv file has same type/set of tabs and we have around 5-6 tabs for each of the csv file which have slightly different content(data).
A sample of CSV1 is shown below:
Joins: Data related to Joins, it can be any number of... (2 Replies)
Hi All,
My requirement is to write a shell script to compare two large csv files.
I've created sample files for explaining my problem
i.e., a.csv and b.csv
contents of files:
-----------------
a.csv
------
Type,Memory (Kb),Location HD,Size (Mb),Serial #
XT,640,D402,0,MG0010... (2 Replies)
Hi , I want to compare first 3 columns of File A and File B and create a new file File C which will have all rows from File B and will include rows that are present in File A and not in File B based on First 3 column comparison.
Thanks in advance for your help.
File A
A,B,C,45,46... (2 Replies)
Hello all,
I have searched high and low for a solution to this, many have come really close but not quite what I'm after.
I have 2 files. One contains GUID's, for example:
8121E002-96FE-4C9C-BC5A-6AFF20DACECD
84468F30-F3B7-418B-81F0-0908E80792BF
A second file, contains a path to the... (8 Replies)
Discussion started by: tirmUK
8 Replies
LEARN ABOUT BSD
mv
MV(1) General Commands Manual MV(1)NAME
mv - move or rename files
SYNOPSIS
mv [ -i ] [ -f ] [ - ] file1 file2
mv [ -i ] [ -f ] [ - ] file ... directory
DESCRIPTION
Mv moves (changes the name of) file1 to file2.
If file2 already exists, it is removed before file1 is moved. If file2 has a mode which forbids writing, mv prints the mode (see chmod(2))
and reads the standard input to obtain a line; if the line begins with y, the move takes place; if not, mv exits.
In the second form, one or more files (plain files or directories) are moved to the directory with their original file-names.
Mv refuses to move a file onto itself.
Options:
-i stands for interactive mode. Whenever a move is to supercede an existing file, the user is prompted by the name of the file followed
by a question mark. If he answers with a line starting with 'y', the move continues. Any other reply prevents the move from occur-
ring.
-f stands for force. This option overrides any mode restrictions or the -i switch.
- means interpret all the following arguments to mv as file names. This allows file names starting with minus.
SEE ALSO cp(1), ln(1)BUGS
If file1 and file2 lie on different file systems, mv must copy the file and delete the original. In this case the owner name becomes that
of the copying process and any linking relationship with other files is lost.
4th Berkeley Distribution April 29, 1985 MV(1)