|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
Compare 2 lists using a full and/or partial match at beginning of line?
Post 302461161 by Garrred on Friday 8th of October 2010 05:08:38 PM
10-08-2010
thanks for all the replies, it's appreciated 
kurumi - it is solaris that i am using and it does not have ruby installed
scrutinizer - i get the followong when i try your suggestion ...
sed 's/^/^/' file2 | grep -f- file1
BTWsed: Command not found
grep: illegal option -- f
grep: illegal option -- -
Usage: grep -hblcnsviw pattern file . . .
rdcwayx - doe s not produce the output i desire, and seems to duplicate items ...
xargs -i grep ^{} file1 < file2
234GH
5234BTW
89er
678tfg
234
234YT
tfg456
wert
78gt
gh23444
234GH
5234BTW
89er
678tfg
234
234YT
tfg456
wert
78gt
gh23444
234GH
5234BTW
89er
678tfg
234
234YT
tfg456
wert
78gt
gh23444
234GH
5234BTW
89er
678tfg
234
234YT
tfg456
wert
78gt
gh23444
Apologies if i have misunderstood any of you, newbie here so its all new to me.
Thanks
kurumi - it is solaris that i am using and it does not have ruby installed
scrutinizer - i get the followong when i try your suggestion ...
sed 's/^/^/' file2 | grep -f- file1
BTWsed: Command not found
grep: illegal option -- f
grep: illegal option -- -
Usage: grep -hblcnsviw pattern file . . .
rdcwayx - doe s not produce the output i desire, and seems to duplicate items ...
xargs -i grep ^{} file1 < file2
234GH
5234BTW
89er
678tfg
234
234YT
tfg456
wert
78gt
gh23444
234GH
5234BTW
89er
678tfg
234
234YT
tfg456
wert
78gt
gh23444
234GH
5234BTW
89er
678tfg
234
234YT
tfg456
wert
78gt
gh23444
234GH
5234BTW
89er
678tfg
234
234YT
tfg456
wert
78gt
gh23444
Apologies if i have misunderstood any of you, newbie here so its all new to me.
Thanks
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am having file which contains around 15 columns, i need to fetch column 3,12,14 based on the condition that column 3 starts with 40464
this is the sample data
how to achieve that (3 Replies)
Discussion started by: aemunathan
3 Replies
2. Shell Programming and Scripting
Hello, this is probably a simple request but I've been toying with it for a while.
I have a large list of devices and commands that were run with a script, now I have lines such as:
a-router-hostname-C#show ver
I want to print everything up to (and excluding) the # and everything after it... (3 Replies)
Discussion started by: ippy98
3 Replies
3. UNIX for Dummies Questions & Answers
Here is my file:
700 7912345678910
61234567891234567891
700 8012345678910
61234567891234567891
I want to pull all lines that begin with '700' only if columns 11-12 are '79'.
My code so far only pulls the '79', not the whole line:
grep ^700 file1 | cut -c 11,12 |... (7 Replies)
Discussion started by: Scottie1954
7 Replies
4. UNIX for Dummies Questions & Answers
Hi, I was trying to figure this out but failed so I hope someone here can help me, thank you in advance.
I have two files.
file1: aa M
bb N
cc O
dd P
ee Q file2: aa A_87_P254063
cc A_87_P016532
bb A_87_P104793
dd A_87_P055331
ee A_87_P059706
aa A_87_P071636
ee A_87_P028302... (2 Replies)
Discussion started by: yuejian
2 Replies
5. UNIX for Dummies Questions & Answers
Hi I have a question and hope I can get answer here. Thank you in advance.
I have two files:
file1:
aa X
bb Y
cc Z
file2:
cc A
bb B
dd C
aa D
bb E
If the 1st column match in both file1 and file2, the 2nd column in file2 will be replaced by the 2nd column in file1. If there is no... (2 Replies)
Discussion started by: yuejian
2 Replies
6. Shell Programming and Scripting
I posted the incorrect files yesterday and apologize. I also modified the awk script but with no luck. There are two text files in the zip (name.txt and output.txt). I am trying to match $2 in name.txt with $1 in output.txt and if they match then $1 of name.txt is copied to $7 of output.txt. ... (7 Replies)
Discussion started by: cmccabe
7 Replies
7. Shell Programming and Scripting
Hi, I have a tab delimited text file like this one. I need to do a partial match of a particular cell and then replace matches with an empty cell. So here is a sample:
Smith FordMustang ChevroletCamaro
Miller FordFiesta
Jones KiaSorrento
Davis ChevroletCamaro
Johnson ToyotaHighlander
I... (4 Replies)
Discussion started by: mikey11415
4 Replies
8. Shell Programming and Scripting
I am trying to create a cronjob that will run on startup that will look at a list.txt file to see if there is a later version of a database using database.txt as the source. The matching lines are written to output.
$1 in database.txt will be in list.txt as a partial match. $2 of database.txt... (2 Replies)
Discussion started by: cmccabe
2 Replies
9. UNIX for Beginners Questions & Answers
I would like to insert n number of characters at the beginning of each line that starts with a given character. If possible, I would be most appreciative for a sed or awk solution.
Given the data below, I would like to be able to insert either 125 spaces or 125 "-" at the beginning of every line... (6 Replies)
Discussion started by: jvoot
6 Replies
10. Shell Programming and Scripting
In the below I am trying to rename the contents within each data subfolder in a specific run, based on a partial match of the IonCode_0000_ in each file in the data subdirectory to $1 in f1. There will be multiple runs in f1 but each run in $uniq is unique and will be found in f1 and the rename... (27 Replies)
Discussion started by: cmccabe
27 Replies
LEARN ABOUT SUNOS
wscrl
scrl(3XCURSES) X/Open Curses Library Functions scrl(3XCURSES) NAME
scrl, scroll, wscrl - scroll a window SYNOPSIS
cc [ flag... ] file... -I /usr/xpg4/include -L /usr/xpg4/lib -R /usr/xpg4/lib -lcurses [ library... ] c89 [ flag... ] file... -lcurses [ library... ] #include <curses.h> int scrl(int n); int scroll(WINDOW *win); int wscrl(WINDOW *win, int n); PARAMETERS
n number and direction of lines to scroll win pointer to the window in which to scroll DESCRIPTION
The scroll() function scrolls the window win up one line. The current cursor position is not changed. The scrl() and wscrl() functions scroll the window stdscr or win up or down n lines, where n is a positive (scroll up) or negative (scroll down) integer. The scrollok(3XCURSES) function must be enabled for these functions to work. RETURN VALUES
On success, these functions return OK. Otherwise, they return ERR. ERRORS
None. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Interface Stability |Standard | +-----------------------------+-----------------------------+ |MT-Level |Unsafe | +-----------------------------+-----------------------------+ SEE ALSO
clearok(3XCURSES), libcurses(3XCURSES), attributes(5), standards(5) SunOS 5.10 5 Jun 2002 scrl(3XCURSES)