String search and print next all lines in one line until blank line


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting String search and print next all lines in one line until blank line
# 1  
Old 08-24-2013
String search and print next all lines in one line until blank line

Dear all

I want to search special string in file and then print next all line in one line until blank lines come. Help me plz for same. My input file and desire op file is as under.

i/p file:

Code:
A1/EXT "BSCABD1_21233G1" 757 130823   1157
RADIO X-CEIVER ADMINISTRATION
BTS EXTERNAL FAULT

MO                RSITE            CLASS
RXOCF-493         ABD193+          1

EXTERNAL ALARM
HIGH TEMPERATURE
BOTH AC FAULTY

A1/EXT "BSCABD1_21233G1" 866 130823   1355
RADIO X-CEIVER ADMINISTRATION
BTS EXTERNAL FAULT

MO                RSITE            CLASS
RXOCF-170         ABD170           1

EXTERNAL ALARM
 AC FAULTY

op fileSmilie2 line)

Code:
"BSCABD1_21233G1" 757 130823   1157 RXOCF-493       ABD193+  HIGH TEMPERATURE BOTH AC FAULTY

"BSCABD1_21233G1" 866 130823   1355 RXOCF-170         ABD170 AC FAULTY

Thanks in advance.

Regards
Jaydeep Sadaria

Last edited by Scrutinizer; 08-24-2013 at 09:08 AM.. Reason: code tags
# 2  
Old 08-24-2013
Try something like:
Code:
awk 'sub("A1/EXT ",x){ p=$0 } /MO/{getline; p=p OFS $1 OFS $2} /EXTERNAL ALARM/{while(getline && NF) p=p OFS $0; print p}' file

Or
Code:
awk '/A1\/EXT/{ p=$2 OFS $3 OFS $4 OFS $5 } /MO/{p=p OFS $4 OFS $5} /EXTERNAL ALARM/{$1=$2=x; p=p OFS $0; print p}' RS= file

otherwise, what is the "special string" ?
This User Gave Thanks to Scrutinizer For This Post:
# 3  
Old 08-24-2013
Second code is working.....
# 4  
Old 08-24-2013
Hi All,

Please help with the following. From the following:

Code:
oats1oob 12651 12598  5 Aug21 ?        03:28:48 /apps/ts1oob/product/fmw11gR1/jrockit-jdk1.6.0_37/bin/java -jrockit -Xms768m -Xmx1536m -Dweblogic.Name=ts1oob_domain_AdminServer -Djava.security.policy=/apps/ts1oob/product/fmw11gR1/wlserver_10.3/server/lib/weblogic.policy -Xverify:none -da -Dplatform.home=/apps/ts1oob/product/fmw11gR1/wlserver_10.3 -Dwls.home=/apps/ts1oob/product/fmw11gR1/wlserver_10.3/server -Dweblogic.home=/apps/ts1oob/product/fmw11gR1/wlserver_10.3/server -Dcommon.components.home=/apps/ts1oob/product/fmw11gR1/oracle_common -Djrf.version=11.1.1 -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger -Ddomain.home=/apps/ts1oob/admin/ts1oob_domain/aserver/ts1oob_domain -Djrockit.optfile=/apps/ts1oob/product/fmw11gR1/oracle_common/modules/oracle.jrf_11.1.1/jrocket_optfile.txt -Doracle.server.config.dir=/apps/ts1oob/admin/ts1oob_domain/aserver/ts1oob_domain/config/fmwconfig/servers/ts1oob_domain_AdminServer -Doracle.domain.config.dir=/apps/ts1oob/admin/ts1oob_domain/aserver/ts1oob_domain/config/fmwconfig -Digf.arisidbeans.carmlloc=/apps/ts1oob/admin/ts1oob_domain/aserver/ts1oob_domain/config/fmwconfig/carml -Digf.arisidstack.home=/apps/ts1oob/admin/ts1oob_domain/aserver/ts1oob_domain/config/fmwconfig/arisidprovider -Doracle.security.jps.config=/apps/ts1oob/admin/ts1oob_domain/aserver/ts1oob_domain/config/fmwconfig/jps-config.xml -Doracle.deployed.app.dir=/apps/ts1oob/admin/ts1oob_domain/aserver/ts1oob_domain/servers/ts1oob_domain_AdminServer/tmp/_WL_user -Doracle.deployed.app.ext=/- -Dweblogic.alternateTypesDirectory=/apps/ts1oob/product/fmw11gR1/oracle_common/modules/oracle.ossoiap_11.1.1,/apps/ts1oob/product/fmw11gR1/oracle_common/modules/oracle.oamprovider_11.1.1 -Djava.protocol.handler.pkgs=oracle.mds.net.protocol|oracle.fabric.common.classloaderurl.handler|oracle.fabric.common.uddiurl.handler|oracle.bpm.io.fs.protocol -Dweblogic.jdbc.remoteEnabled=false -da:org.apache.xmlbeans... -Dsoa.archives.dir=/apps/ts1oob/product/fmw11gR1/Oracle_SOA1/soa -Dsoa.oracle.home=/apps/ts1oob/product/fmw11gR1/Oracle_SOA1 -Dsoa.instance.home=/apps/ts1oob/admin/ts1oob_domain/aserver/ts1oob_domain -Dtangosol.coherence.clusterport=5656 -Dtangosol.coherence.wka1=c3-a1-oa2-ipts-144 -Dtangosol.coherence.wka2=c3-a1-oa2-ipts-145 -Dtangosol.coherence.wka3=c3-a2-oa2-ipts-144 -Dtangosol.coherence.wka4=c3-a2-oa2-ipts-145 -Dtangosol.coherence.localhost=c3-a1-oa2-ipts-144 -Dtangosol.coherence.localport=9099 -Dtangosol.coherence.wka1.port=9099 -Dtangosol.coherence.wka2.port=9099 -Dtangosol.coherence.wka3.port=9099 -Dtangosol.coherence.wka4.port=9099 -Dtangosol.coherence.log=jdk -Djavax.xml.soap.MessageFactory=oracle.j2ee.ws.saaj.soap.MessageFactoryImpl -Dweblogic.transaction.blocking.commit=true -Dweblogic.transaction.blocking.rollback=true -Djavax.net.ssl.trustStore=/apps/ts1oob/product/fmw11gR1/wlserver_10.3/server/lib/DemoTrust.jks -Dem.oracle.home=/apps/ts1oob/product/fmw11gR1/oracle_common -Djava.awt.headless=true -Dums.oracle.home=/apps/ts1oob/product/fmw11gR1/Oracle_SOA1 -Dweblogic.management.discover=true -Dwlw.iterativeDev= -Dwlw.testConsole= -Dwlw.logErrorsToConsole= -Dweblogic.ext.dirs=/apps/ts1oob/product/fmw11gR1/patch_wls1036/profiles/default/sysext_manifest_classpath -Xverify:none -da -Dplatform.home=/apps/ts1oob/product/fmw11gR1/wlserver_10.3 -Dwls.home=/apps/ts1oob/product/fmw11gR1/wlserver_10.3/server -Dweblogic.home=/apps/ts1oob/product/fmw11gR1/wlserver_10.3/server -Dcommon.components.home=/apps/ts1oob/product/fmw11gR1/oracle_common -Djrf.version=11.1.1 -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger -Ddomain.home=/apps/ts1oob/admin/ts1oob_domain/aserver/ts1oob_domain -Djrockit.optfile=/apps/ts1oob/product/fmw11gR1/oracle_common/modules/oracle.jrf_11.1.1/jrocket_optfile.txt -Doracle.server.config.dir=/apps/ts1oob/admin/ts1oob_domain/aserver/ts1oob_domain/config/fmwconfig/servers/ts1oob_domain_AdminServer -Doracle.domain.config.dir=/apps/ts1oob/admin/ts1oob_domain/aserver/ts1oob_domain/config/fmwconfig -Digf.arisidbeans.carmlloc=/apps/ts1oob/admin/ts1oob_domain/aserver/ts1oob_domain/config/fmwconfig/carml -Digf.arisi

I need to get the output as follows:

Code:
-Dweblogic.home=/apps/ts1oob/product/fmw11gR1/wlserver_10.3/server
-Dsoa.instance.home=/apps/ts1oob/admin/ts1oob_domain/aserver/ts1oob_domain
..
..

All the *.home=<<PATH>> Information is required.
Let me know if you can get it.


Regards
Smarlaku
# 5  
Old 08-24-2013
@smarlaku, please start a new thread for this...
# 6  
Old 09-13-2013
String search and print next all lines in one line until blank LINE

Dear all

one more of similir proble. i used below code but it does not give complete result to me.

Code:
awk '/A1\/EXT/{ p=$2 OFS $3 OFS $4 OFS $5 } /EXTERNAL ALARM/{$1=$2=x; p=p OFS $0; print p}' RS = i/pfile

-- this give only first line op.(*** ALARM 584 A1/EXT "BSCABD1_21233G1"U 130908 0120)

i/p file:

Code:
*** ALARM 584 A1/EXT "BSCABD1_21233G1"U 130908 0120
EXTERNAL ALARM

AP    APNAME         NODE      NODENAME
 1    AP080428645C   B         AP080428645B

AMAPP
FIRE
MANISFAIL


DEV
EXAL-1-26


output neededSmilieIN ONE LINE)
Code:
*** ALARM 584 A1/EXT "BSCABD1_21233G1"U 130908 0120 AMAZONEPP FIRE MANIS FAIL

Guide for same.

Regards
jaydeep

Last edited by Scrutinizer; 09-14-2013 at 01:12 PM.. Reason: additional code tags for data
# 7  
Old 09-13-2013
Code:
sed -n '/pattern/,/^$/p' <FIELNAME>

This wil print from the pattern to the empty line.

Moderator's Comments:
Mod Comment Please use code tags!

Last edited by radoulov; 09-13-2013 at 06:34 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Search string and print the above line and below lines?.

if the first string matches then print the previous line and current line and also print the following lines if the other string search matches. Input ------ TranTime 2012 10 12 The Record starts here Accountnumber: 4632473431274 TxnCode 323 TranID 329473242834 ccsdkcnsdncskd... (7 Replies)
Discussion started by: laknar
7 Replies

2. Shell Programming and Scripting

Search words in a line and print next 15 lines.

I have a text file ( basically a log file) and i have 2 words (alpha, beta), Now i want to search these two words in one line and then print next 15 lines in a temp file. there would be many lines with alpha and beta But I need only last occurrence with "alpha" and "beta" and next 15 lines. ... (4 Replies)
Discussion started by: kashif.live
4 Replies

3. Shell Programming and Scripting

Print lines between a regExp & a blank line

Hi, I have a file, say files_list, as below (o/p of ls -R cmd) $ cat files_list /remote/dir/path/to/file: sub-dir1 sub-dir2 sub-dir3 ... /remote/dir/path/to/file/sub-dir1: remote_file1.csv.tgz <blank line 1> /remote/dir/path/to/file/sub-dir2: remote_file2.csv.tgz <blank... (3 Replies)
Discussion started by: dips_ag
3 Replies

4. Shell Programming and Scripting

Search for string and print top and bottom line

Hi Folks I need a one liner to parse through a log and if the string is found print the line above, the line with the string and the line below. example: The ball is green and blue Billy through the ball higer. Jane got hurt with the ball. So if I search for Billy I would need the 3... (1 Reply)
Discussion started by: bombcan
1 Replies

5. Shell Programming and Scripting

search string in a file and retrieve 10 lines including string line

Hi Guys, I am trying to write a perl script to search a string "Name" in the file "FILE" and also want to create a new file and push the searched string Name line along with 10 lines following the same. can anyone of you please let me know how to go about it ? (8 Replies)
Discussion started by: sukrish
8 Replies

6. Shell Programming and Scripting

Print lines after the search string until blank line is found

All I want is to look for the pattern in the file...If I found it at # places... I want print lines after those pattern(line) until I find a blank line. Log EXAMPLE : MT:Exception caught The following Numbers were affected: 1234 2345 2346 Error java.lang.InternalError:... (3 Replies)
Discussion started by: prash184u
3 Replies

7. Shell Programming and Scripting

awk print second line after search string

I have multiple config files where I need to pull the ip address from loopback3. The format is the same in every file, the ip is the second line after interface loopback3. interface loopback2 loopback description router ID ip address 192.168.1.1 interface loopback3 loopback description... (3 Replies)
Discussion started by: numele
3 Replies

8. Shell Programming and Scripting

Search a string and print the rest of line

Hi Guys, I need to search a string and print the rest of the lines... input: 8 0 90 1 0 59 20 2488 96 30006dde372 S ? 0:00 /etc/opt/SUNWconn/atm/bin/atmsnmpd -n output: 00 /etc/opt/SUNWconn/atm/bin/atmsnmpd -n Actually i don even need the first "00".. any suggestions is appreciated..... (13 Replies)
Discussion started by: mac4rfree
13 Replies

9. Shell Programming and Scripting

Unix help to find blank lines in a file and print numbers on that line

Hi, I would like to know how to solve one of my problems using expert unix commands. I have a file with occasional blank lines; for example; dertu frthu fghtu frtty frtgy frgtui frgtu ghrye frhutp frjuf I need to edit the file so that the file looks like this; (10 Replies)
Discussion started by: Lucky Ali
10 Replies

10. Shell Programming and Scripting

How to use sed to search for string and Print previous two lines and current line

Hello, Can anybody help me to correct my sed syntax to find the string and print previous two lines and current line and next one line. i am using string as "testing" netstat -v | sed -n -e '/test/{x;2!p;g;$!N;p;D;}' -e h i am able to get the previous line current line next line but... (1 Reply)
Discussion started by: nmadhuhb
1 Replies
Login or Register to Ask a Question