12-06-2013
Thanks and Noted Sir Don. I'm Sorry i'm newbie in unix. i'll try harder next tym. may i know on how to retain the records if it's not equal?
Please advise,
Thanks,
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
First off, this is as much as I know about Unix: its an operating system. Now, I know it goes a tad deeper than that, so first off, what exactly is Unix? Next, im freakin sick of everything microsoft crashing on me, so Id like to make Unix my OS, but I dont want to lose anything but internet... (5 Replies)
Discussion started by: gc_wyo_dave
5 Replies
2. Shell Programming and Scripting
Hi,
I need some help in knowing how I can append tabs at the end of each line...
The data looks something like this:
field1, field2, field3, field4
1 2
3 4 5
I have values in field1 and field 2 in the first row and I would like to append tab on field3 and field4 for the first row..and in... (6 Replies)
Discussion started by: madhunk
6 Replies
3. Shell Programming and Scripting
I need to write a program to do something like a 'vlookup' in excel. I want to match data from file2 based on two fields (where both match) in file1, and for matching lines, add the data from two of the fields from file2 to file1.
If anyone knows something in perl or awk that can do this, I'd be... (20 Replies)
Discussion started by: jamessmith01
20 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I need help on appending certain field in my file1.txt based on matched patterns in file2.txt using awk or sed.
The blue color need to match with one of the data in field $2 in file2.txt. If match, BEGIN and FINISHED value in red will have a new value from field $3 and $4 accordingly.
... (1 Reply)
Discussion started by: redse171
1 Replies
5. Shell Programming and Scripting
I have a csv dump from sql server that needs to be converted so it can be feed to another program. I already sorted on field 1 but there are multiple columns with same field 1 where it needs to be compared against and if it is same then append field 5.
i.e from
ANG SJ,0,B,LC22,LC22(0)
BAT... (2 Replies)
Discussion started by: nike27
2 Replies
6. UNIX for Dummies Questions & Answers
Hi Everyone,
Good Day, I'm a newbie on scripting, I would like to seek you for assistance regarding on how to bash the 1st file into 2nd file and output the match record.
Sample:
File1.csv
JuanDelaCrus<tab>USA<tab>CANADA
TwoDelaCrus<tab>SG<tab>California
File2.csv... (2 Replies)
Discussion started by: znesotomayor
2 Replies
7. Shell Programming and Scripting
Hi Everyone,
Seeking for your assistance on how to bash the file 1 to file 2 records and output the same records with specific field to display to file3.
Example: Imagine we have many Files and records in File 1 and the File2 is only 1 file but many records.
File1... (3 Replies)
Discussion started by: znesotomayor
3 Replies
8. Shell Programming and Scripting
Hi All,
Seeking for your assistance on how to bash 2 files and then print if the condition met.
Ex.
file1.txt:
Field1 Field2 Field 3 Field 4
usa <blank> <blank> INDIA
file2.txt:
Field1 Field2 Field 3 Field 4
canada jap INDIA utah... (7 Replies)
Discussion started by: znesotomayor
7 Replies
9. Shell Programming and Scripting
Hi guys,
I have problem to append new data at the end of each line of the files where it takes whole value of the nth column. My expected result i just want to take a specific value only. This new data is based on substring of 11th, 12th 13th column that has comma seperated value.
My code:
awk... (4 Replies)
Discussion started by: null7
4 Replies
10. Shell Programming and Scripting
I am trying to parse two csv files and make a match in one column then print the entire file to a new file and append an additional column that gives description from the match to the new file. If a match is not made, I would like to add "NA" to the end of the file
Command that Ive been using... (6 Replies)
Discussion started by: dis0wned
6 Replies
mv(1) General Commands Manual mv(1)
Name
mv - move or rename files
Syntax
mv [-i] [-f] [-] file1 file2
mv [-i] [-f] [-] file... directory
Description
The command 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, prints the mode and reads the
standard input to obtain a line. If the line begins with y, the move takes place. If it does not, exits. For further information, see
In the second form, one or more files (plain files or directories) are moved to the directory with their original file-names.
The command refuses to move a file onto itself.
Options
- Interprets all following arguments as file names to allow file names starting with a minus.
-f Force. This option overrides any mode restrictions or the -i switch.
-i Interactive mode. If a move is to supersede an existing file, the system prompts youw with the name of the file fol-
lowed by a question mark. If you type a string that begins with y, the move occurs. If you type any other response,
the move does not occur.
Restrictions
If file1 and file2 lie on different file systems, 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.
See Also
cp(1), ln(1)
mv(1)