09-09-2008
Extract info from csv
I have some input file, which contains some lines which are comma separated. Eg.
a,b,id=999],d
d,f,g,id=345],x
x,y,x,s,id=677],y
I run a loop to read the lines one by one. What i want is to extract the value on the right of id=. I cannot do it by Awk, since the column number is not fixed. So what i need is to first search and match "id=" pattern, and then print the number following it, until ']' is encountered.
Any way to do this??
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
a simple question,
how can i use cut (after using grep) to extract the last four digits on a line.
so say i had a string http://blabla:9020, how would I extract the port??
-Fez (4 Replies)
Discussion started by: hafhaq
4 Replies
2. AIX
hi guys i need to extract information from log files generated by an application.
log file has the following lines for each process..
----------------------------------------------
Fri Aug 03 12:06:43 WST 2007 INFO: Running project PROJECT1
Fri Aug 03 12:06:43 WST 2007 INFO: Source Files... (7 Replies)
Discussion started by: kirantalla
7 Replies
3. AIX
Anyone have a better idea to automate extraction of info like ...
"uname"
"ifconfig"
"ps efl"
"netstat -ao"
etc.
from several hundred aix, solaris, red hat boxes? without logging into each box and manually performing these tasks and dumping them to individual files?
thanks for any input (1 Reply)
Discussion started by: chm0dvii
1 Replies
4. IP Networking
Hi all,
I am working on a networking project that requires me to find out the NIC on that particular machine and many more things.
Now Given the IP and the subnet.
I would like to know how we can extract such informations?
I am talking in exclusivity to Solaris boxes!!
The required... (6 Replies)
Discussion started by: wrapster
6 Replies
5. Shell Programming and Scripting
Dear all
I have a file call interfaces.txt
Filename: interfaces.txt
How can I extract the information at below?
ABC_DB_001 hostname1 20901
ABC_DB_002 hostname2 20903
ABC_DB_003 hostname3 20905
Currently I am using a very stupid method
grep ^ABC interfaces.txt > name.txt
grep... (3 Replies)
Discussion started by: on9west
3 Replies
6. Shell Programming and Scripting
Hi guys, new to this forum. I am currently trying to extract the times from pinging a domain and list the top 3 and then also do the opposite i.e. list the bottom 3.
so if I had this as a ping result (the bold part is what I want):
64 bytes from 193.120.166.90: icmp_seq=10 ttl=128 time=34.8... (5 Replies)
Discussion started by: acoding
5 Replies
7. Shell Programming and Scripting
Hello,
I have two files which look like this
File 1
Name test1 status P
Gene1 0.00236753 1 1.00E-01
Gene2 0.134187 2 2.00E-01
Gene3 0.000608716 2 3.00E-01
Gene4 0.0016234 1 4.00E-01
Gene5 0.000665868 2 5.00E-01and file 2
No Pos ... (2 Replies)
Discussion started by: nans
2 Replies
8. Shell Programming and Scripting
Hi
I have an output of sarcommand which is as follows:
10:22:18 bread/s lread/s %rcache bwrit/s lwrit/s %wcache pread/s pwrit/s
10:23:18 0 398 100 5 13 64 0 0
10:24:18 0 332 100 5 15 65 0 0
10:25:18 0 ... (7 Replies)
Discussion started by: fretagi
7 Replies
9. Shell Programming and Scripting
Hi
I use multipath linux command to get LUNs info and find out if any failed.
# multipath -ll >/tmp/mpfail
# cat /tmp/mpfail
multipath.conf line 109, invalid keyword: user_friendly_names
multipath.conf line 153, invalid keyword: user_friendly_names
multipath.conf line 193, invalid... (4 Replies)
Discussion started by: prvnrk
4 Replies
GREP(1) General Commands Manual GREP(1)
NAME
grep - search a file for lines containing a given pattern
SYNOPSIS
grep [-elnsv] pattern [file] ...
OPTIONS
-e -e pattern is the same as pattern
-c Print a count of lines matched
-i Ignore case
-l Print file names, no lines
-n Print line numbers
-s Status only, no printed output
-v Select lines that do not match
EXAMPLES
grep mouse file # Find lines in file containing mouse
grep [0-9] file # Print lines containing a digit
DESCRIPTION
Grep searches one or more files (by default, stdin) and selects out all the lines that match the pattern. All the regular expressions
accepted by ed and mined are allowed. In addition, + can be used instead of * to mean 1 or more occurrences, ? can be used to mean 0 or 1
occurrences, and | can be used between two regular expressions to mean either one of them. Parentheses can be used for grouping. If a
match is found, exit status 0 is returned. If no match is found, exit status 1 is returned. If an error is detected, exit status 2 is
returned.
SEE ALSO
cgrep(1), fgrep(1), sed(1), awk(9).
GREP(1)