If I have data as below :
1,ABC,XXXX
2,ABC000,YYYY
3,DEF,AAAA
4,ABC0,ZZZZ
I want to get records whose 2nd col exactly match with word 'ABC'
I am using command below :
awk -F"," '$2~/ABC/' Filename
It is retrieving records as -
1,ABC,XXXX
2,ABC000,YYYY
4,ABC0,ZZZZ
But in... (8 Replies)
Hi guys,I m new one in awk scripting....i want to search a word with in a directory...in that directory haviing many files...if i give a work ,it should open the directory and open each file for to search that particular word....is it possible in awk...tell me guys its really urgent.... (2 Replies)
Can anyone help me how I will extract all lines in a file where the word "worker" or "co-worker" in 2nd column exist. There are also word in 2nd column like "workers" or "worker2" but I don't want to display those lines.
Appreciate any help in advance! Thank you! (5 Replies)
Hi friends ,
I am new to unix ,need your help to fix this
there is a ~ deliminated file. how to find the 5th column of the row.
awk 'print $5 ' abc.txt
it doesnot work . it works for table deliminated file. My data file is like the following manner.
abc.txt
--------
a~b~c~d~e~f... (3 Replies)
Hi,
I have list of directory paths in a variable and i want to delete those dirs and if dir does not exist then search that string and get the correct path from xml file after that delete the correct directory. i tried to use grep and it prints the entire line from the search.once i get the entire... (7 Replies)
Hi Guys,
Please help me out in my situation of writing a shell script
Exampl:I have a output like
asnapply 1 2 3 apply_server=1 apply_schema=ASN
asnapply 1 2 3 apply_server=2 apply_schema=ASN
Now i need output like
asnacmd applysever=1 applyschema=ASN stop
asnacmd applysever=2... (16 Replies)
How to search for a word like "computer" in a column (eg: 4th field) of a '***' delimited file and add a column at the end of the record which denotes 'Y' if present and 'N' if not. After this, we need to again check for words like 'Dell' but not 'DellXPS' in 5th field and again add another column... (5 Replies)
Hi, I have a file with +/- 13000 lines and 4 column. I need to search the 3rd column for a word that begins with "SAP-" and move/skip it to the next column (4th). Because the 3rd column need to stay empty.
Thanks in advance.:)
89653 36891 OTR-60 SAP-2
89653 36892 OTR-10 SAP-2... (2 Replies)
Hi- I have issue with the code to get the input file reformat
--Goal is reformat and print out only column name one per line, leading space or trailing space will be removed...
--TABLE1.DDL as input file, and content of file as show below
REPLACE VIEW TABLE1
(
ID
,COL1
... (3 Replies)
I have a multicolumn text file with header in the first row like this
The headers are stored in an array called . which contains I want to search for each elements of this array from that multicolumn text file. And I am using this awk approach
for ii in ${hdr}
do
gawk -vcol="$ii" -F... (1 Reply)