Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

grep

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting grep
# 1  
Old 06-06-2007
grep
Hi,

I have some files (650) each file has some information like subs number, hardware ID1, Hardware ID2, Hardware ID3 and 4. how can I get this informations from all files using a script ? I want to write those info to a file. like column1 (subs number) column2 (HwID1)......column4(HwID4)

how can I do this ??

thanks

Alice
# 2  
Old 06-06-2007
AlisevA3,
Please, include all relevant information in your question.
If we do not have a sample of the file, we will not be able
to help you.
# 3  
Old 06-06-2007
member
memberNumber=09700104;
IDNumber="";
AreaC="";
Status=0;
Global_Synchro="2007-06-05 15:13:13";
Hw1
Hardware{
SerialN="011-001-000229";
Version=0101;
Hw2
Hardware{
SerialN="011-001-000225";
Version=0101;

Hw3
Hardware{
SerialN="011-001-000255";
Version=0101;

--------------------
Files looks above.I have a lot of files (more than 650)

I would like to have

member Hw1 Hw2 Hw3
9700104 229 229 255
# 4  
Old 06-06-2007
AlisevA,
Here is one solution:
Code:
mCmdA1='/memberNumber=/p'
mCmdA2='/^Hw/p'
mCmdA3='/SerialN/p'
mCmdB1='s/memberNumber=\(.*\);/\1/'
mCmdB2='s/SerialN.*-\(.*\)";/\1/'
sed -n -e ${mCmdA1} -e ${mCmdA2} -e ${mCmdA3} input_file | sed -e ${mCmdB1} -e ${mCmdB2}

Although, it will print the results like this:
Code:
09700104
Hw1
000229
Hw2
000225
Hw3
000255

# 5  
Old 06-06-2007
Try the following awk program:
Code:
#!/usr/bin/awk -f
# Awk file: h.awk

function print_datas() {
   if (member) print member,serials;
}

BEGIN {
   FS = "[=;]";
}

/^member/ {
   print_datas();
   member  = "";
   serials = "";
}

$1=="memberNumber" {
   member = $2;
}

$1=="SerialN" {
   sub(/^.*-0*/, "", $2);
   sub(/".*$/,   "", $2);
   serials = (serials ? serials OFS : "") $2;
}

END {
   print_datas();
}

Input File:
Code:
$ cat h.txt
member
memberNumber=09700104;
IDNumber="";
AreaC="";
Status=0;
Global_Synchro="2007-06-05 15:13:13";
Hw1
Hardware{
SerialN="011-001-000229";
Version=0101;
Hw2
Hardware{
SerialN="011-001-000225";
Version=0101;

Hw3
Hardware{
SerialN="011-001-000255";
Version=0101;
member
memberNumber=09700777;
IDNumber="";
AreaC="";
Status=0;
Global_Synchro="2007-06-05 15:13:13";
Hw1
Hardware{
SerialN="011-001-000123";
Version=0101;
Hw2
Hardware{
SerialN="011-001-000456";
Version=0101;
$

Output:
Code:
$ awk -f h.awk h.txt
09700104 229 225 255
09700777 123 456
$

Jean-Pierre.
# 6  
Old 06-06-2007
thank you Shell Life. works well
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Inconsistent `ps -eaf -o args | grep -i sfs_pcard_load_file.ksh | grep -v grep | wc -l`

i have this line of code that looks for the same file if it is currently running and returns the count. `ps -eaf -o args | grep -i sfs_pcard_load_file.ksh | grep -v grep | wc -l` basically it is assigned to a variable ISRUNNING=`ps -eaf -o args | grep -i sfs_pcard_load_file.ksh |... (6 Replies)
Discussion started by: wtolentino
6 Replies

2. UNIX for Dummies Questions & Answers

Piping grep into awk, read the next line using grep

Hi, I have a number of files containing the information below. """"" Fundallinfo 6.3950 14.9715 14.0482 """"" I would like to grep for Fundallinfo and use it to read the next line? I ideally would like to read the three numbers that follow in the next line and... (2 Replies)
Discussion started by: Paul Moghadam
2 Replies

3. UNIX for Dummies Questions & Answers

Bash - CLI - grep - Passing result to grep through pipe

Hello. I want to get all modules which are loaded and which name are exactly 2 characters long and not more than 2 characters and begin with "nv" lsmod | (e)grep '^nv???????????? I want to get all modules which are loaded and which name begin with "nv" and are 2 to 7 characters long ... (1 Reply)
Discussion started by: jcdole
1 Replies

4. Shell Programming and Scripting

AWK/GREP: grep only lines starting with integer

I have an input file 12.4 1.72849432773174e+01 -7.74784188610632e+01 12.5 9.59432114416327e-01 -7.87018212757537e+01 15.6 5.20139995965960e-01 -5.61612429666624e+01 29.3 3.76696387248366e+00 -7.42896194101892e+01 32.1 1.86899877018077e+01 -7.56508762501408e+01 35 6.98857157014640e+00... (2 Replies)
Discussion started by: chrisjorg
2 Replies

5. UNIX for Dummies Questions & Answers

Advanced grep'in... grep for data next to static element.

I have a directory I need to grep which consists of numbered sub directories. The sub directory names change daily. A file resides in this main directory that shows which sub directories are FULL backups or INCREMENTAL backups. My goal is to grep the directory for the word "full" and then... (2 Replies)
Discussion started by: SysAdm2
2 Replies

6. UNIX for Dummies Questions & Answers

Difference between grep, egrep & grep -i

Hi All, Please i need to know the difference between grep, egrep & grep -i when used to serach through a file. My platform is SunOS 5.9 & i'm using the korn shell. Regards, - divroro12 - (2 Replies)
Discussion started by: divroro12
2 Replies

7. Shell Programming and Scripting

grep for certain files using a file as input to grep and then move

Hi All, I need to grep few files which has words like the below in the file name , which i want to put it in a file and and grep for the files which contain these names and move it to a new directory , full file name -C20091210.1000-20091210.1100_SMGBSC3:1000... (2 Replies)
Discussion started by: anita07
2 Replies

8. UNIX for Dummies Questions & Answers

| help | unix | grep (GNU grep) 2.5.1 | advanced regex syntax

Hello, I'm working on unix with grep (GNU grep) 2.5.1. I'm going through some of the newer regex syntax using Regular Expression Reference - Advanced Syntax a guide. ls -aLl /bin | grep "\(x\)" Which works, just highlights 'x' where ever, when ever. I'm trying to to get (?:) to work but... (4 Replies)
Discussion started by: MykC
4 Replies

9. UNIX for Dummies Questions & Answers

| help | unix | grep - Can I use grep to return a string with exactly n matches?

Hello, I looking to use grep to return a string with exactly n matches. I'm building off this: ls -aLl /bin | grep '^.\{9\}x' | tr -s ' ' -rwxr-xr-x 1 root root 632816 Nov 25 2008 vi -rwxr-xr-x 1 root root 632816 Nov 25 2008 view -rwxr-xr-x 1 root root 16008 May 25 2008... (7 Replies)
Discussion started by: MykC
7 Replies

10. Shell Programming and Scripting

MEM=`ps v $PPID| grep -i db2 | grep -v grep| awk '{ if ( $7 ~ " " ) { print 0 } else

Hi Guys, I need to set the value of $7 to zero in case $7 is NULL. I've tried the below command but doesn't work. Any ideas. thanks guys. MEM=`ps v $PPID| grep -i db2 | grep -v grep| awk '{ if ( $7 ~ " " ) { print 0 } else { print $7}}' ` Harby. (4 Replies)
Discussion started by: hariza
4 Replies
Login or Register to Ask a Question