Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to insert new line in xml?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to insert new line in xml?
# 1  
Old 04-07-2014
How to insert new line in xml?
Code:
 I have an xml like below and wanted to insert a new line between end of the tag and start of the new tag.
<partyaddress><addressline1>gandhi  stree</addressline1><city>hyderbad</city><state>AP</state><addressline1>xyz  stree</addressline1><city>bangalore</city><state>Karnataka</state> </partyaddress>

I wanted the output like below

<partyaddress>
<addressline1>gandhi  stree</addressline1><city>hyderbad</city <state>AP</state>
<addressline1>xyz   stree</addressline1><city>bangalore</city><state>Karnataka</state>  </partyaddress>
I am trying the code like below but in vain
sed "s/</\state>/<\/stae>\n/g" a.xml
rather than getting a new line, "n" is being added to it.
OS: HP UNIX
SHELL: ksh

Could you please help me out to get the output as specified above?

# 2  
Old 04-07-2014
Try puting the sed expression in single quotes instead of double quotes.
# 3  
Old 04-07-2014
Code:
sed "s/</\state>/<\/stae>\\
/g" a.xml

This User Gave Thanks to anbu23 For This Post:
D_Sethi
# 4  
Old 04-07-2014
or try
Code:
# sed 's/<addressline1/\
> <addressline1/g'

# 5  
Old 04-07-2014
Quote:
Originally Posted by anbu23
Code:
sed "s/</\state>/<\/stae>\\
/g" a.xml

Thanks, it is working with \\, but not working with single codes.Thanks
Once again
# 6  
Old 04-07-2014
You may try awk

Code:
$ awk '{sub("<"tag">","&\n");sub("</"tag">","\n&")}1' tag="partyaddress" file.xml

<partyaddress>
<addressline1>gandhi  stree</addressline1><city>hyderbad</city><state>AP</state><addressline1>xyz  stree</addressline1><city>bangalore</city><state>Karnataka</state> 
</partyaddress>

# 7  
Old 04-07-2014
Quote:
Originally Posted by D_Sethi
Thanks, it is working with \\, but not working with single codes.Thanks
Once again
Code:
sed 's/</\state>/<\/stae>\
/g' a.xml

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to insert subnode in xml file using xmlstarlet or any other bash command?

I have multiple xml files where i want to update a subnode if the subnode project points to different project or insert a subnode if it doesn't exist using a xmlstarlet or any other command that can be used in a bash script. I have been able to update the subnode project if it doesn't point to... (1 Reply)
Discussion started by: Sekhar419
1 Replies

2. Shell Programming and Scripting

How to insert a CSV within xml element tag using Python?

Hi Team, I have a CSV file which I have to read through and needs to insert the content within an XML file using Python ONLY ( as most of the code base we have in python only). I managed to find the first part, missing how to insert to XML under "specific" tags. cat input.csv... (0 Replies)
Discussion started by: panyam
0 Replies

3. Shell Programming and Scripting

Insert text after match in XML file

Having a little trouble getting this to work just right. I have xml files that i want to split some data. I have 2 <name> tags within the file I would like to take only the first tag and split the data. tag example. From this. TAB<Name>smith, john</Name> to TAB<Name>smith,... (8 Replies)
Discussion started by: whegra
8 Replies

4. Shell Programming and Scripting

awk command to insert a tag in XML

Hi All, I need a help on inserting a XML tag. Actual input <var> <nam>abcd</nam> <a1>.</a1> </var> if tag <a1>.</a1> is getting missed in XML like below <var> <nam>abcd</nam> </var> i need to insert wherever it is missed after <nam> tag and before </var> tag. Could anyone... (3 Replies)
Discussion started by: mohanalakshmi
3 Replies

5. Shell Programming and Scripting

Insert a newline in XML

Hi guys, I got a requirement that ... (5 Replies)
Discussion started by: mohanalakshmi
5 Replies

6. Shell Programming and Scripting

From sql Insert Query to XML format

Hi How do I translate Let say Cat inserts.sql gives Insert into PM9_TAXATION_ROUNDING (STATE_GECODE, TAX_TYPE, TAX_AUTHORITY, SYS_CREATION_DATE, SYS_UPDATE_DATE, APPLICATION_ID, DL_SERVICE_CODE, ROUNDING_METHOD) Values ('xx', 'xx', 'x', TO_DATE('10/26/2012 13:01:20',... (3 Replies)
Discussion started by: anuj87in
3 Replies

7. Shell Programming and Scripting

Insert a new subnode in a xml file

Hi, i have an xml file and i want to edit a new sub node in a file like val="<activity android:label="@string/app_name" android_name=".MainActivity1" android:launchMode="singleTask" android:screenOrientation="portrait" ... (1 Reply)
Discussion started by: gautamshrm3
1 Replies

8. Shell Programming and Scripting

Insert a new line between the XML tags?.

<TestLog> <TriggerAPI> <StartDate>Nov 16, 2012 6:34:02 AM com.satttest01.Response() </StartDate> <RequestType>SUCCESS: Send :</RequestType> <TranNumber>5210203</TranNumber> <TranId>8585319731207148</TranId> </TriggerAPI> <TriggerAPI> <StartDate>Nov 16, 2012 6:34:02 AM... (3 Replies)
Discussion started by: laknar
3 Replies

9. Shell Programming and Scripting

Insert value of env variable in xml file

Hello, I have the following variables set in my env echo $MY_XSD_FILE /home/jak/sample.xsd echo $MY_INTERVAL_VALUE 4 I want to insert them between the xml tags in my xml file cat sample.xml ::::::::::::::: ::::::::::::::: <property name="FILE"></property> :::::::::::::::::::::::... (2 Replies)
Discussion started by: jakSun8
2 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