[SOLVED] Requesting help to modify simple XML with SED script

-=ALS=- · 03-01-2012, 05:16 PM

I have this:

<parent id="111111"><child>222222</child><child>333333</child><child>444444</child></parent>

I need this:

<parent id="111111"><child parentid="111111">222222</child><child parentid="111111">333333</child><child parentid="111111">444444</child></parent>

The number of child tags will vary and ID's won't be fixed length nor sequential.

I'm preparing this for import into a database.

Thanks for any help!

Al

Dark_Helmet · 03-01-2012, 05:44 PM

Assuming that the data is all on one line:

Code:

sed -r ':a s@(<parent id=)("[0-9]+")(.*)<child>(.*)@\1\2\3<child parentid=\2>\4@ ; ta'

-=ALS=- · 03-01-2012, 08:54 PM

Wow ... Thats what label is for! Awesome, Thank you.

syg00 · 03-01-2012, 09:20 PM

In which case I trust you added to Dark_Helmet's reputation.

It's always interesting to see the way (greedy) regex can sometimes seem counter-intuitive. Remove the "; ta" to see what I mean.