We have an XML database with 44,000 separate items. I need to take an existing number in each entry, and repeat it on a separate line within a new line added to each separate item. See below:
<link>[url removed, login to view]</link>
<g:image_link>[url removed, login to view]</g:image_link>
<g:price>[url removed, login to view]</g:price>
<description>Big labor savers All welded construction Built tough and durable Heavy duty rocker stops; Dumps itself, rights itself, locks itself. Steel Surcharge May Apply </description>
<g:product_type>Tilt Trucks & Hoppers</g:product_type>
<title>HEAVY DUTY HOPPERS FORMED BASE - (STACKABLE) - 12 GA. BODY (211761)</title>
What I need is the number in the parenthesis put in a new line, called MPN.
This needs to be done throughout the entire 43,000 item database.
Pretty simple, but I don't have the software to do it.