Read file excluding XML in it


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Read file excluding XML in it
# 1  
Old 04-09-2012
Read file excluding XML in it

Hi ,

I have a file like below.I want all the content in a single line excluding the XML.How can i proceed?
Code:
 
[xxx]
t=21
y=23
 
[jjj]
rg=xyz
.....
<xmlstarts>
.
.
<xmlends>
 
[ppp]
lk=99
lo=09

Thanks,
Chetan.C

---------- Post updated at 09:42 AM ---------- Previous update was at 09:39 AM ----------

The output im expecting is like this [xxx]t=21y=23[jjj]rg=xyz[ppp]lk=99lo=09
# 2  
Old 04-09-2012
Code:
sed '/<xmlstarts>/,/<xmlends>/d' inputfile | tr -d '\n'

# 3  
Old 04-10-2012
Hi m
Thanks for the response.It is working fine as expected.The script is now like below
Code:
#!/bin/bash
cd /Extracted
for i in *.txt
do
echo `sed '/</,/>/d' "$i" | tr -d '\n'`"^"$i
echo -e '\n'
done

Since i need filename in front of each line i have used the for loop.
But the script runs very slow.total rows is round 900000 for 9000 files.Is there any better way than the script above to improve the performance?
Thanks,
Chetan.C

---------- Post updated 04-10-12 at 01:50 AM ---------- Previous update was 04-09-12 at 10:38 AM ----------

Any sugestions?

---------- Post updated at 03:02 AM ---------- Previous update was at 01:50 AM ----------

Is there a perl option where i can be doing it?

Last edited by chetan.c; 04-09-2012 at 12:48 PM..
# 4  
Old 05-01-2012
Hi,

Wanted to know if i can use awk for this as i'm using echo to print filename for each file ans this is making the script very slow.

Thanks,
Chetan.c

---------- Post updated at 06:44 AM ---------- Previous update was at 02:31 AM ----------

Hi,

I have the script like below after some modifications.
Code:
awk -v ORS="" 'FNR==1 {printf("\n"FILENAME"\n")} ;{ sub(/<.*/,"");print }' *.txt


But this code prints a lot of Blank lines and i do not know why.
can somebody please let me know if this code is right.?

Thanks,
Chetan.C
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Red Hat

How to read an xml file through shell script?

Hey , can we read an xml file and make changes in it through shell script. Thanks (4 Replies)
Discussion started by: ramsavi
4 Replies

2. Shell Programming and Scripting

Shell Script to read XML file

Hi unix Gurus, I am really new to Unix Scripting. Please help me to create a shell script which reads the xml file and from that i need to fetch a particular information. For example <SOURCE BUSINESSNAME ="" DATABASETYPE ="Teradata" DBDNAME ="DWPROD3" DESCRIPTION ="" NAME... (5 Replies)
Discussion started by: SmilePlease
5 Replies

3. Shell Programming and Scripting

To read a flat file containing XML data

I have a file something like this:aaaa.xml content of the file is 0,<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <storeInformation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <s> <BRANCH_NO>3061</BRANCH_NO> <BRANCH_NAME>GREEN EXPRESS</BRANCH_NAME> ... (4 Replies)
Discussion started by: kmanivan82
4 Replies

4. Shell Programming and Scripting

Help on awk to read xml file

Hello, I have a xml file as shown below. I want to parse the file and store data in variables. xml file looks like: <TEST NAME="DataBaseurl">jdbc:oracle:thin:@localhost:1521:ora10</TEST> <TEST NAME="Databaseuser">Pradeep</TEST> ...... and many other such lines i want to read this file and... (2 Replies)
Discussion started by: pradeepmacha
2 Replies

5. Shell Programming and Scripting

script to read XML file

Dear All, I have one log file and it contains lot of XML as below. ... (1 Reply)
Discussion started by: murtujak
1 Replies

6. Shell Programming and Scripting

read and write to xml file

hi i am quite new to shell scripting and need help in reading and writing in xml file i have an xml file with format: <main> <store> <name>ABC</name> <flag>0</flag> <size>123<size> </store> <store> <name>DEF</name> ... (2 Replies)
Discussion started by: kichu
2 Replies

7. Shell Programming and Scripting

Read data in XML file

Hello Everybody, I have a question on reading the data from XML file through KSH shell script. In the below file I need to collect the patient control no and its respective insured id. I need to have pair of these values in single line separated by some special character, so that I could use... (2 Replies)
Discussion started by: swame_sp
2 Replies

8. Shell Programming and Scripting

Read block of lines from xml file

Hi I am new to this forum. I have few XML files and from each xml file I want to copy some specific 50 no of lines and copy them to some other file. how to do that? pls help.. (5 Replies)
Discussion started by: pritam1980
5 Replies

9. Shell Programming and Scripting

Read elements of a xml file??????

Hi, What is a good way to read elements of an xml file? i did try xmllint it doesnt provide a function to output values of a tree. In the below example when i specify from Family2 I need the name of the father then the output should be DAVE. Appreciate any help provided in this regards. Many... (6 Replies)
Discussion started by: ahmedwaseem2000
6 Replies

10. Shell Programming and Scripting

Read xml file

Iam new to shell script. How to read xmlfile using shellscript(without awk),and Store record by record in file . My xml file: <root> <header> <HeaderData1>header1</HeaderData1> <HeaderData2>header2</HeaderData2> </header> <detailsRecord> ... (2 Replies)
Discussion started by: ram2s2001
2 Replies
Login or Register to Ask a Question