Visit Our UNIX and Linux User Community


Adding extra word from file1 to file2


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Adding extra word from file1 to file2
# 1  
Old 06-08-2011
Adding extra word from file1 to file2

I need to add a word from file1 to file2 accordinggly... file1 contains name of servers and file2 version of server

I need that information in a single file so that the format is

server_name : version

I been trying but havent been able to figure out how to search for a file using sed...

PLEASE HELP!!
# 2  
Old 06-08-2011
if we do not know how your file1 and file2 look like, we cannot help to parse it.

Code:
paste file1 file2 >mergedfile

???
# 3  
Old 06-08-2011
Code:
file1                    file2
word1            sentence1
word2            sentence2
word3            sentence3

and i need to end in separate file or file1 or 2, whatever is easier in this format
Code:
word1;sentence1
word2;sentence2


Last edited by Franklin52; 06-09-2011 at 04:27 AM.. Reason: Please use code tags
# 4  
Old 06-08-2011
Code:
man paste

Code:
paste -d";" file1 file2

This User Gave Thanks to ctsgnb For This Post:
# 5  
Old 06-08-2011
what about if i have my file1 in this format
word1
word2
word3

and my file2 is always going to be in this format
sentece2

so I need a for loop so that whenever a file2 file3 filex comes will add that 1 sentence to my file1. Or is it just easier to paste with 2 separate files.

Thank you,
# 6  
Old 06-08-2011
All depends on what you have and what you want.

I don't understand what kind of things you have nor what kind of this you want to achieve, i need more infos as well as full example of input you have and output you want.

I may then be able to help you further.
# 7  
Old 06-08-2011
ok...so here is my script

# Logs to each server using file, gets relase information into a file, copies
#it to harp server, deletes file.
for host in `cat $PATH_TEMP/name_of_file`
do
ssh $host sh lsb_release -a >> $host/tmp/$host_release.info
scp -p $host:/tmp/$host_release.info $PATH_TEMP/release.info
rm /tmp/$host_release.info
done




So when the script is executed for the fist time...this will be the result in the local host

list_file
server1
server2
server3

server1_file
version

final_file
server1;version

if we keep going this is what I want to have in the final_file
list_file
server1
server2
server3

server2_file
version

final_file
server1;version
server2;version

and the only thing that will change as the script uses the list file would be the serverX file, which willl have a different version and that will be combined with the 2nd entry of file 1 to be entered in final_file as the second entry.

Does that help

Last edited by eponcedeleonc; 06-08-2011 at 05:26 PM.. Reason: code was not legible

Previous Thread | Next Thread
Test Your Knowledge in Computers #851
Difficulty: Medium
Angular is a TypeScript-based open-source web application framework.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk to search field2 in file2 using range of fields file1 and using match to another field in file1

I am trying to use awk to find all the $2 values in file2 which is ~30MB and tab-delimited, that are between $2 and $3 in file1 which is ~2GB and tab-delimited. I have just found out that I need to use $1 and $2 and $3 from file1 and $1 and $2of file2 must match $1 of file1 and be in the range... (6 Replies)
Discussion started by: cmccabe
6 Replies

2. UNIX for Dummies Questions & Answers

Compare file1 and file2, print matching lines in same order as file1

I want to print only the lines in file2 that match file1, in the same order as they appear in file 1 file1 file2 desired output: I'm getting the lines to match awk 'FNR==NR {a++}; FNR!=NR && a' file1 file2 but they are in sorted order, which is not what I want: Can anyone... (4 Replies)
Discussion started by: pathunkathunk
4 Replies

3. Shell Programming and Scripting

If file1 and file2 exist then

HI, I would like a little help on writing a if statement. What i have so far is: #!/bin/bash FILE1=path/to/file1 FILE2=path/to/file2 echo ${FILE1} ${FILE2} if ] then echo file1 and file2 not found else echo FILE ok fi (6 Replies)
Discussion started by: techy1
6 Replies

4. Shell Programming and Scripting

look for line from FILE1 at FILE2

Hi guys! I'm trying to write something to find each line of file1 into file2, if line is found return YES, if not found return NO. The result can be written to a new file. Can you please help me out? FILE1 INPUT: WATER CAR SNAKE (in reality this file has about 600 lines each with a... (2 Replies)
Discussion started by: demmel
2 Replies

5. UNIX for Dummies Questions & Answers

if matching strings in file1 and file2, add column from file1 to file2

I have very limited coding skills but I'm wondering if someone could help me with this. There are many threads about matching strings in two files, but I have no idea how to add a column from one file to another based on a matching string. I'm looking to match column1 in file1 to the number... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

6. Shell Programming and Scripting

grep -f file1 file2

Hi I started to learn bash a week ago. I need filter the strings from the last column of a "file2" that match with a column from an other "file1" file1: chr10100036394-100038350AK077761 chr10100041065-100046547AK032226 chr10100041065-100046547AK016270 chr10100041065-100046547AK078231 ...... (6 Replies)
Discussion started by: geparada88
6 Replies

7. Shell Programming and Scripting

file1 newer then file2

Hello, I am new to shell scripting and i need to create a script with the following directions and I can not figure it out. Create a shell script called newest.bash that takes two filenames as input arguments ($1 and $2) and prints out the name of the newest file (i.e. the file with the... (1 Reply)
Discussion started by: mandylynn78
1 Replies

8. Shell Programming and Scripting

Read each word from File1 and search each file in file2

file1: has all words to be searched. 100007 200999 299997 File2: has all file names to be searched. C:\search1.txt C:\search2.txt C:\search3.txt C:\search4.txt Outfile: should have all found lines. Logic: Read each word in file1 and search each file in the list of File2; if the... (8 Replies)
Discussion started by: clem2610
8 Replies

9. Shell Programming and Scripting

grep -f file1 file2

Wat does this command do? fileA is a subset of fileB..now, i need to find the lines in fileB that are not in fileA...i.e fileA - fileB. diff fileA fileB gives the ouput but the format looks no good.... I just need the contents alone not the line num etc. (7 Replies)
Discussion started by: vijay_0209
7 Replies

10. Shell Programming and Scripting

match value from file1 in file2

Hi, i've two files (file1, file2) i want to take value (in column1) and search in file2 if the they match print the value from file2. this is what i have so far. awk 'FILENAME=="file1"{ arr=$1 } FILENAME=="file2" {print $0} ' file1 file2 (2 Replies)
Discussion started by: myguess21
2 Replies

Featured Tech Videos