08-19-2011
@alister - thanks for the detailed reply. Actually it was a typo from my side in the first post - "acg" should count twice. My original file has only alphabets in both columns and no other characters or metacharacters. So, the codes seem to be work fine.
Yes the string of 2nd column should be searched in all the rows of 1st column.
By 30000 lines I meant the maximum number of lines in any column. Yes the 2nd column has far fewer rows/lines than the first.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
can we do substring fuctionality using AWK
say I have string "sandeep"
can i pick up only portion "nde" from it.
Thanks and Regards
Sandeep Ranade (3 Replies)
Discussion started by: mahabunta
3 Replies
2. UNIX for Dummies Questions & Answers
Hi All,
I have 2 programs running by the following names:
a_testloop.sh
testloop.sh
I read these programs names from a file and store each of them into a variable called $program.
On the completion of the above programs i should send an email.
When i use grep with ps to see if any of... (3 Replies)
Discussion started by: albertashish
3 Replies
3. Shell Programming and Scripting
I am trying to get a substring from a string stored in a variable. I tried sed with a bit help from this forum, but not successful. Here is my problem.
My string is: "REPLYFILE=myfile.txt"
And I need: myfile.txt (everything after the = symbol).
My string is: "myfile.txt.gz.20091120.enc... (5 Replies)
Discussion started by: jamjam10k
5 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I have a file with the following contents:
I need to create a script or search command that will search for this string 'ENDC' in the file. This string is unique and only occurs in one record. Once it finds the string, I would like it to return positions 101-109 ( this is the date of... (0 Replies)
Discussion started by: Lenora2009
0 Replies
5. Shell Programming and Scripting
Hi Team,
How to get the last 3 characters of a String irrespective of their length using awk?
Thanks
Kinny (5 Replies)
Discussion started by: kinny
5 Replies
6. UNIX for Advanced & Expert Users
Hi All,
I need some help with an awk command:
What I'm trying to do is append "MYGROUP: " to text with the substring "AT_"
the input file follows this format:
AT_xxxxxx
Name1
Name2
AT_xxxxxx
NameA
NameB
I want the output to be:
MYGROUP: AT_xxxxx
Name1
Name2
MYGROUP:... (2 Replies)
Discussion started by: bikecraft
2 Replies
7. Shell Programming and Scripting
Hi All,
I have a log file in which name and version of applications are coming in the following format
name
It may look like following, based on the name of the application and version:
XYZ OR xyz OR XyZ OR xyz
I want to separate out the name and version and store them into variables.... (4 Replies)
Discussion started by: bhaskar_m
4 Replies
8. Shell Programming and Scripting
I have the following data in a text file.
"A",1,"MyTextfile.CSV","200","This is ,line one"
"B","EFG",23,"MyTextfile1.csv","5621",562,"This is ,line two"
I want to extract the fileNames MyTextfile.CSV and MyTextfile1.csv.
The problem is not all the lines are delimited with ","
There are... (3 Replies)
Discussion started by: AshTrak
3 Replies
9. Shell Programming and Scripting
Hi all,
I have 2 files, the first one containing a list of ids and the second one is a master file. I want to search each id from the first file from the 5th col in the second file. The 5th column in master file has values separated by ';', if not a single value is present.
Each id must occur... (2 Replies)
Discussion started by: ritakadm
2 Replies
10. Shell Programming and Scripting
i have this data where i am looking for a two digit number 01,03,05 or 07.
if not found i should detect that .
this sed command gives me the matching rows . I want the opposite , i want the rows if the match is NOT found .
also the sed command is only looking for 01, can i add 03, 05, 07 to... (7 Replies)
Discussion started by: boncuk
7 Replies
LEARN ABOUT FREEBSD
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