GessWurker
asked on
Need transform that will remove ALL id information
I need a transform which will remove all id information from zillions of xml records in the format below. I don't know how to do this. I want to retain just the names, no ids. Who knows how to do this?
<?xml version="1.0" encoding="UTF-8"?>
<Import>
<ImportSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ImportFileFormat="Xml" MatchFoundAction="Unspecif ied" MatchNotFoundAction="Unspe cified" UnrecognizedPropertyOption ="Unspecif ied" ContentDetailExceptionOpti on="Unspec ified" BubbleEventsOption="Unspec ified" IsUpgradeOption="IsUpgrade " FileDispositionOption="Uns pecified" BinaryFileDispositionOptio n="Unspeci fied" SkipRecordCount="0" MaximumRecordCount="0" UseSaxon="false">
<SinkPath />
<ExceptionFilePath />
<AltBinariesPath />
<TransformURL />
<TransformFileWrapper />
<LocalizablePropertyLocale >en-US</Lo calizableP ropertyLoc ale>
</ImportSettings>
<ContentTypes>
<ContentType name="Staff Publication" id="Staff_Publication_1075 9">
<Records>
<Record>
<PropertyValues>
<PropertyValue name="Record ID" id="Record_ID_10760">14505 </Property Value>
<PropertyValue name="Author" id="Author_10761">Vader, Darth</PropertyValue>
<PropertyValue name="Found In" id="Found_In_10762">Galaxy News</PropertyValue>
<PropertyValue name="Title" id="Title_10763">The Force: Why it makes me rule</PropertyValue>
<PropertyValue name="Source" id="Source_10764">Dark Side Inc</PropertyValue>
<PropertyValue name="Publication Number" id="Publication_Number_107 65">000000 00</Proper tyValue>
<PropertyValue name="Publication Year" id="Publication_Year_10766 ">1970</Pr opertyValu e>
<PropertyValue name="Subject" id="Subject_10767">High potentials</PropertyValue>
<PropertyValue name="In Print" id="In_Print_10769">Yes?</ PropertyVa lue>
<PropertyValue name="Location" id="Location_10770">Archiv es</Proper tyValue>
<PropertyValue name="Notes" id="Notes_10772">This is a really important document</PropertyValue>
<PropertyValue name="Full Text" id="Full_Text_10773">Blah blah blah</PropertyValue>
<PropertyValue name="Doc Import" id="Doc_Import_10774">How do you do this?</PropertyValue>
<PropertyValue name="Entry Date" id="Entry_Date_10776">Augu st 1, 2012</PropertyValue>
<PropertyValue name="Abstract" id="Abstract_10778">Blah blah blah blah blah (shortened)</PropertyValue >
<PropertyValue name="Type" id="Type_10780">Kit</Prope rtyValue>
<PropertyValue name="External Link" id="External_Link_10782">http://www.weather.com/< /PropertyV alue>
<PropertyValue name="Last Modified" id="Last_Modified_10783">8 /1/2012 7:02:00 PM</PropertyValue>
<PropertyValue name="Rating" id="Rating" UserName="admin" EntryDate="8/1/2012 7:02:00 PM">5.00</PropertyValue>
<PropertyValue name="Voting" id="Voting" UserName="admin" EntryDate="8/1/2012 7:02:00 PM">1.00</PropertyValue>
<PropertyValue name="Tags" id="Tags" UserName="admin" EntryDate="8/1/2012 5:45:00 PM">awesomeness, world domination, mind control</PropertyValue>
<PropertyValue name="Category" id="Category">Competency|C ompetency Collection|Leading Function|Leading Change|Fosters a climate of experimentation.</Property Value>
<PropertyValue name="Category" id="Category">Competency|C ompetency Collection|Leading Function|Create a Common Vision</PropertyValue>
<PropertyValue name="ContentItemLanguage" id="ContentItemLanguage" />
<PropertyValue name="Active" id="Active">True</Property Value>
<PropertyValue name="inmCreatedBy" id="inmCreatedBy">admin</P ropertyVal ue>
<PropertyValue name="inmCommunity" id="inmCommunity" />
</PropertyValues>
</Record>
</Records>
</ContentType>
</ContentTypes>
</Import>
<?xml version="1.0" encoding="UTF-8"?>
<Import>
<ImportSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ImportFileFormat="Xml" MatchFoundAction="Unspecif
<SinkPath />
<ExceptionFilePath />
<AltBinariesPath />
<TransformURL />
<TransformFileWrapper />
<LocalizablePropertyLocale
</ImportSettings>
<ContentTypes>
<ContentType name="Staff Publication" id="Staff_Publication_1075
<Records>
<Record>
<PropertyValues>
<PropertyValue name="Record ID" id="Record_ID_10760">14505
<PropertyValue name="Author" id="Author_10761">Vader, Darth</PropertyValue>
<PropertyValue name="Found In" id="Found_In_10762">Galaxy
<PropertyValue name="Title" id="Title_10763">The Force: Why it makes me rule</PropertyValue>
<PropertyValue name="Source" id="Source_10764">Dark Side Inc</PropertyValue>
<PropertyValue name="Publication Number" id="Publication_Number_107
<PropertyValue name="Publication Year" id="Publication_Year_10766
<PropertyValue name="Subject" id="Subject_10767">High potentials</PropertyValue>
<PropertyValue name="In Print" id="In_Print_10769">Yes?</
<PropertyValue name="Location" id="Location_10770">Archiv
<PropertyValue name="Notes" id="Notes_10772">This is a really important document</PropertyValue>
<PropertyValue name="Full Text" id="Full_Text_10773">Blah blah blah</PropertyValue>
<PropertyValue name="Doc Import" id="Doc_Import_10774">How do you do this?</PropertyValue>
<PropertyValue name="Entry Date" id="Entry_Date_10776">Augu
<PropertyValue name="Abstract" id="Abstract_10778">Blah blah blah blah blah (shortened)</PropertyValue
<PropertyValue name="Type" id="Type_10780">Kit</Prope
<PropertyValue name="External Link" id="External_Link_10782">http://www.weather.com/<
<PropertyValue name="Last Modified" id="Last_Modified_10783">8
<PropertyValue name="Rating" id="Rating" UserName="admin" EntryDate="8/1/2012 7:02:00 PM">5.00</PropertyValue>
<PropertyValue name="Voting" id="Voting" UserName="admin" EntryDate="8/1/2012 7:02:00 PM">1.00</PropertyValue>
<PropertyValue name="Tags" id="Tags" UserName="admin" EntryDate="8/1/2012 5:45:00 PM">awesomeness, world domination, mind control</PropertyValue>
<PropertyValue name="Category" id="Category">Competency|C
<PropertyValue name="Category" id="Category">Competency|C
<PropertyValue name="ContentItemLanguage"
<PropertyValue name="Active" id="Active">True</Property
<PropertyValue name="inmCreatedBy" id="inmCreatedBy">admin</P
<PropertyValue name="inmCommunity" id="inmCommunity" />
</PropertyValues>
</Record>
</Records>
</ContentType>
</ContentTypes>
</Import>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
welcome
ASKER