search file and print results with shell script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting search file and print results with shell script
# 1  
Old 02-06-2009
Network search file and print results with shell script

input file

1.<CRMSUB:MSIN=0100004735,BSNBC=TELEPHON-9814060328-TS11&TS21&TS22,NDC=9814,MSCAT=ORDINSUB,SUBRES=ALLPLMN-SPICE,BAOC=OIC,BAPRC=INFO,ACCSUB=BSS,NUMTYP=MULTI;
2.<CRMSUB:MSIN=0100004928,BSNBC=TELEPHON-9814060893-TS11&TS21&TS22,NDC=9814,MSCAT=ORDINSUB,SUBRES=ALLPLMN-AIRSIMLA,BAOC=OC,ACCSUB=BSS,NUMTYP=MULTI;
3.<CRMSUB:MSIN=0100006946,BSNBC=TELEPHON-9814061751-TS11&TS21&TS22,NDC=9814,MSCAT=ORDINSUB,SUBRES=ALLPLMN-AIRSIMLA,BAOC=OIC,ACCSUB=BSS,NUMTYP=MULTI;

i hav this file contain lack of lines. here i want to seach BAOC that is highlited But BAOC hav mltiple values like OC & OIC. i want to print these values. BAOC is not in a specific field it may be changed

o/p should be
MSIN # telephon #BAOC
0100004735#9814060328#OC
0100004928#9814060893#OIC
0100006946#9814061751#OC
# 2  
Old 02-06-2009
nawk -f dod.awk myInputFile

dod.awk:
Code:
BEGIN {
  FS="[:=,;-]"
  OFS="#"
}
{
  for(i=1; i<=NF; i++) {
     if ($i=="MSIN")
        msin=$(i+1)
     if ($i=="TELEPHON")
        tele=$(i+1)
     if ($i=="BAOC")
        baoc=$(i+1)
  }
  print msin, tele, baoc
}

# 3  
Old 02-07-2009
Thanks dear
it gives me result that i want
just one thing more if BAOC is present it gives its vaue liKE OC but if not present then it shoud print "no"

o/p should be some thing like

0100004735#9814060328#OC
0100004928#9814060893#no
0100006946#9814061751#OC


plz yaar gives me its solution

Thanks !
# 4  
Old 02-07-2009
Code:
BEGIN {
  FS="[:=,;-]"
  OFS="#"
}
{
  msin=tele=baoc="no"
  for(i=1; i<=NF; i++) {
     if ($i=="MSIN")
        msin=$(i+1)
     if ($i=="TELEPHON")
        tele=$(i+1)
     if ($i=="BAOC")
        baoc=$(i+1)
  }
  print msin, tele, baoc
}

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Search for names in one list in another and print results

Hi All , New to the Bash / Shell programming world and looking for some help I have two files 1: Contains a list of names : eg STEVE BOB CRAIG 2: Contains information with those included names but also others that are not in the list (1 Reply)
Discussion started by: Lonerg550
1 Replies

2. Shell Programming and Scripting

Script to search every file in a directory and print last few lines

Hi everyone, I need to write a script to search a directory, output the name of a file to an ouput file and print the last few lines of the files to the output file such that I would have something like this: FILE1: LINE LINE LINE FILE2: LINE LINE LINE FILE3: LINE LINE LINE... (2 Replies)
Discussion started by: mojoman
2 Replies

3. UNIX for Dummies Questions & Answers

Search file and print everything except multiple search terms

I'm trying to find a way to search a range of similar words in a file. I tried using sed but can't get it right:sed 's/\(ca01\)*//'It only removes "ca01" but leaves the rest of the word. I still want the rest of the information on the lines just not these specific words listed below. Any... (3 Replies)
Discussion started by: seekryts15
3 Replies

4. Shell Programming and Scripting

Perl - use search keywords from array and search a file and print 3rd field when matched

Hi , I have been trying to write a perl script to do this job. But i am not able to achieve the desired result. Below is my code. my $current_value=12345; my @users=("bob","ben","tom","harry"); open DBLIST,"<","/var/tmp/DBinfo"; my @input = <DBLIST>; foreach (@users) { my... (11 Replies)
Discussion started by: chidori
11 Replies

5. Shell Programming and Scripting

Can ctag and cscope support recording search results and displaying the history results ?

Hello , When using vim, can ctag and cscope support recording search results and displaying the history results ? Once I jump to one tag, I can use :tnext to jump to next tag, but how can I display the preview search result? (0 Replies)
Discussion started by: 915086731
0 Replies

6. Shell Programming and Scripting

Print some results in a text file using script in linux

hello everyone, i really need your help to write a script which would just print following kind of result into a text file (result.txt) XYZ test Results ID: <unique-id> Date: <date> ------------------------------------------------- | Task | Result | Time |... (3 Replies)
Discussion started by: viriimind
3 Replies

7. Shell Programming and Scripting

Script template for inputting filenames and print results

Hi, Hope you are all well. New to scripting, and all those characters are all a new language for me. Though hoping to get my little head round it all sooner or later. I was wondering whether anyone could help with a script template example. What I would like to happen is to run the script... (8 Replies)
Discussion started by: loky27
8 Replies

8. Shell Programming and Scripting

Shell script to search through numbers and print the output

Suppose u have a file like 1 30 ABCSAAHSNJQJALBALMKAANKAMLAMALK 4562676268836826826868268468368282972982 2863923792102370179372012792701739729291 31 60... (8 Replies)
Discussion started by: cdfd123
8 Replies

9. Shell Programming and Scripting

search for the contents in many file and print that file using shell script

hello have a file1 H87I Y788O T347U J23U and file2 J23U U887Y I99U T556U file3 I99O J99T F557J file4 N99I T666U R55Y file5 H87I T347U file6 H77U R556Y E44T file7 Y788O K98U H8I May be using script we can use file1 to search for all the files and have the output H87I file5... (3 Replies)
Discussion started by: cdfd123
3 Replies

10. Shell Programming and Scripting

script to run shell command and insert results to existing xml file

Hi. Thanks for any help with this. I'm not new to programming but I am new to shell programming. I need a script that will 1. execute 'df -k' and return the volume names with specific text 2. surround each line of the above results in opening and closing xml tags 3. insert the results of step... (5 Replies)
Discussion started by: littlejon
5 Replies
Login or Register to Ask a Question