Please help.
I want to read a file line by line (only 1 column) and print all corresponding rows from a second file (2 columns) . Only first column of second file has to be matched with only column of first file. Order of lines in output doesn't matter.
Simplified example
Code:
Input 1
A
B
Ca
D
Input 2
A Apple
B Bat
Ba Bad
Ax Axe
Ca Cat
C Cab
B Bag
Desired output
A Apple
B Bat
Ca Cat
B Bag
---------- Post updated at 04:42 PM ---------- Previous update was at 04:13 PM ----------
never mind..figured this out myself..thank you ...joy of being a biologist able to do this..
Moderator's Comments:
edit by bakunin: very good! Congrats. We would be overjoyed if you would have posted your solution because this would help all who have the same or a similar problem like you.
I changed the thread's title to [Solved].
Hi Eveyone,
I am working on one shell script to find the specific records from data file and add the totals into variables and print them. you can find the sample data file below for more clarification.
Sample Data File:
PXSTYL00__20090803USA
CHCART00__20090803IND... (7 Replies)
How can I find the biggest file in a branch?
I tried
find / \*.\* | xargs du | sort -n 1,1 | head 1
but shell do nothings :(
---------- Post updated at 03:07 PM ---------- Previous update was at 02:41 PM ----------
Solved:
find / -name \*.\* | xargs du | sort -nr | head -n 1 (0 Replies)
I am familiar with using tar and exclude/include files:
tar zcf backup.dirs.tgz --files-from=include.mydirs --exclude-from=exclude.mydirs --no-recursion
but was wondering if I could use find in the same way. I know that you can just specify the directories to exclude but my list is... (2 Replies)
Trying to locate files less than xx days old, throughout all directories/subdirectories, but excluding certain types of directories and files.
The directories I want to search all contain the same characteristic (dbdef, pldef, ghdef, etc), and there are subdirectories within that I need to... (2 Replies)
Can somebody help me with the following syntax? I want to find all
files that end with *.arc
SUFFIX=".arc"
find /tmp -name "\*$SUFFIX" -print 2>/dev/null
---------- Post updated at 03:45 PM ---------- Previous update was at 03:41 PM ----------
got it thanks
-name... (0 Replies)
hi All,
I am using the command
find /home/mqm/check/ -mtime +1|wc -l
to get a count of the files older than a day under the check directory. But instead of getting the count of the files under check directory I m getting a count including the check directory itself. Can someone please tell... (0 Replies)
Hi,
On my system, I have about 75 users. Some uers have two or three sessions on the same systems. when I do w, it shows all the sessions. Is there any way to find only the users and not worry about how many sessions. For example: you can see sshe has four connection. I only want to know... (5 Replies)
Hi i have two directories and files inside them
Directory 1:
Directory 2:
These files are the same but song.mp3 in Directory 1 is newer than song.mp3 in Directory 2, and work.txt in Directory 2 is newer than work.txt in Directory 1.
Now is my question. How i can compare these files... (10 Replies)
Hello Friends,
I have a problem about a little script,
when i run the following two lines one by one on CLI then they work well:
/usr/bin/mkdir `perl -e 'use POSIX qw(strftime); print strftime "%Y-%m-%d",localtime(time() - 30*24*60*60);'`
find . -type f -name "fuseesb.log.*" -mtime 30... (5 Replies)
Discussion started by: EAGL€
5 Replies
LEARN ABOUT LINUX
colrm
COLRM(1) BSD General Commands Manual COLRM(1)NAME
colrm -- remove columns from a file
SYNOPSIS
colrm [start [stop]]
DESCRIPTION
The colrm utility removes selected columns from the lines of a file. A column is defined as a single character in a line. Input is read
from the standard input. Output is written to the standard output.
If only the start column is specified, columns numbered less than the start column will be written. If both start and stop columns are spec-
ified, columns numbered less than the start column or greater than the stop column will be written. Column numbering starts with one, not
zero.
Tab characters increment the column count to the next multiple of eight. Backspace characters decrement the column count by one.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7).
EXIT STATUS
The colrm utility exits 0 on success, and >0 if an error occurs.
SEE ALSO awk(1), column(1), cut(1), paste(1)HISTORY
The colrm command appeared in 3.0BSD.
BSD August 4, 2004 BSD
04-21-2013
