awk pattern matching problem -not recognizing a column
Hi all,
I am new to awk.
I want to print the line numbers if the column has a particular value.
For example I have:
I want to print the lines having value 1 in column 2.
My output should be
I tried:
But it didnot produce any output.
After trying for a long time, I just added aother column to this file (in excel) with zeros. ie;
Now when I do:
I am getting the correct output.
can anyone help me on why awk is not working for FILE1. I have to do the same in 100 files. I am not sure what mistake I had made when working on FILE1 format
Your reply will be very helpful. Thanks in advance
Last edited by Franklin52; 06-18-2010 at 01:47 PM..
Reason: Please use code tags
I have a file with the following contents;
NEW 85174 MP081 /29OCT07
CNL 85986 MP098 /28OCT07
NEW 86014 MP098 /28OCT07
NEW 86051 MP097 /27OCT07
CNL 86084 MP097 /27OCT07
Now I have to retrieve all lines that start with NEW and where the next line starts with CNL and where the MP codes are... (8 Replies)
I am using ksh on a HP Ux. I have a simple script but am having problem with the case statement:-
#!/usr/bin/sh
Chl=”SM.APPLE_SWIFT_DV”
LoConfirm=””
case $chl in
)
LoConfirm=”Using channel at Building 1”
echo “test conditon1”
echo $LoConfirm;;
)
LoConfirm=”Using... (2 Replies)
if abc.sh is
192.168.1.41
then the output that i get is v5c01
my code is
sed 's/192.168.1.4/v5c0/g
s/192.168.1.41/acc1/g' abc.sh 2>&1 | tee abc.sh
i want to find 192.168.1.4 and replace it with v5c0
and find 192.168.1.41 and replace it with acc1
and i want to do it using sed (5 Replies)
# cat email.txt | grep -i "To:"
To: <test@example.com>
# cat email.txt | grep -i "Subject"
Subject: Test
Subject: How are you.
I need to print only test@example.com from To field need to eliminate "< & >" from To field and need to print entire subject after Subject:
It should be
#... (7 Replies)
hi everyone
i am facing a strange problem
declare
v_var number(10);
begin
if( regexp_like('RCDORMS_MMS_*_DAR','RCDORMS_MMS_*_DAR'))
then
v_var:=20;
dbms_output.put_line(v_var);
end if;
end;
/
please tell me what's the wrong thing in this expression..
as i am not able to get... (1 Reply)
Hi I need a bash script that can search through a text file for all lines starting with 71502FSC1206 on every line it finds starting with this I need to place a letter F at the 127 position on that line.
Thanks
Paul (6 Replies)
Hi All,
I have the following output file created as a result of one script called pattern_daily.log
$ cat pattern_daily.log
Approved|2|Wed, Oct 24, 2012 11:21:09 AM
Declined|1|Wed, Oct 24, 2012 11:21:15 AM
Approved|2|Wed, Oct 24, 2012 11:24:08 AM
Declined|1|Wed, Oct 24, 2012 11:24:18 AM... (4 Replies)
if i have to do pattern match for file name with digit alphanumeric value like this
File_1234.csv
File_12sd45rg.csv
i am using this File_*.csv
and File_*.csv for digit pattern match.
when i am doing pattern match for the digit then both alphanumeric match
and digit match is coming.
... (3 Replies)
Hi,
I have 2 csv files.
a.csv
HUAWEI,20LMG011_DEKET_1296_RTN-980_IDU-1-11-ISV3-1(to LAMONGAN_M),East_Java,20LMG011_DEKET_1296_RTN-980_IDU-1,20LMG011,20LMG
027_1287_LAMONGAN_RTN980_IDU1,20LMG027,1+1(HSB),195.675,20LMG011-20LMG027,99.9995,202.6952012... (7 Replies)
Discussion started by: tententen
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