Man you saved me so much time in the past converting .txt files into a single excel sheet I was hoping you could help me again. I have machine recipe's that are in .xml format that I'd like to get only portions of the .xml file put into excel so I can modify it and then take the modified data and re make the .xml file in the same format as the original. below I have copied 1 of over a thousand actual recipe's that I would love to get into excel and then after making changes to the data re make the .xml file the same way. so using below as the data that I need to convert I have shown below that the way I would want the data to appear in 1 row of excell data.
THIS IS THE .XML FILE DATA. THE NAME OF THE FILE WILL NEED TO BE THE FIRST COLUMN IN THE ROW OF EXCELL DATA
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="recipe.xsl"?>
<TAGLIST>
<TAG>
<NAME>hmi_Spin_at_Dip</NAME>
<VALUE>1</VALUE>
</TAG>
<TAG>
<NAME>hmi_Hopper_Lower</NAME>
<VALUE>1</VALUE>
</TAG>
<TAG>
<NAME>hmi_Double_Cycle</NAME>
<VALUE>0</VALUE>
</TAG>
<TAG>
<NAME>hmi_Double_Dip</NAME>
<VALUE>0</VALUE>
</TAG>
<TAG>
<NAME>hmi_Numb_Dump</NAME>
<VALUE>0</VALUE>
</TAG>
<TAG>
<NAME>hmi_Batch_Weight</NAME>
<VALUE>150</VALUE>
</TAG>
<TAG>
<NAME>hmi_Dip_Speed</NAME>
<VALUE>10</VALUE>
</TAG>
<TAG>
<NAME>hmi_Spin_Speed</NAME>
<VALUE>400</VALUE>
</TAG>
<TAG>
<NAME>hmi_Dip_Time</NAME>
<VALUE>10</VALUE>
</TAG>
<TAG>
<NAME>hmi_Spin_Time</NAME>
<VALUE>30</VALUE>
</TAG>
<TAG>
<NAME>hmi_Number_of_Spins</NAME>
<VALUE>3</VALUE>
</TAG>
<TAG>
<NAME>hmi_InVibe_Speed</NAME>
<VALUE>0</VALUE>
</TAG>
<TAG>
<NAME>hmi_Conveyor_Speed</NAME>
<VALUE>0</VALUE>
</TAG>
<TAG>
<NAME>hmi_Customer_Name</NAME>
<VALUE>INFASTECH</VALUE>
</TAG>
<TAG>
<NAME>hmi_Part_Description</NAME>
<VALUE>M8</VALUE>
</TAG>
<TAG>
<NAME>Recipe_Top_Coat_Type</NAME>
<VALUE>TNT-12</VALUE>
</TAG>
</TAGLIST>
AN EXAMPLE OF HOW THIS RECIPE ABOVE WOULD BE PUT INTO EXCELL WOULD BE BELOW: THE FILE NAME IN COLUMN A THEN THE DATA BETWEEN <VALUE> ????</VALUE> IN COLUMNS AFTER THAT. THEN i WOULD NEED TO CHANGE SOME OF THE DATA A RE-CREATE ALL THE NEW XML FILES USING THE DATA FROM EACH ROW IN THE EXCELL FILE. DOES THIS MAKE SENSE?
FILENAME , 1,1,0,0,0,150,10,400,10,30,3,0,0,INFASTECH,M8,TNT-12
IF YOU COULD HELP ME i WOULD BE SO APPRECIATIVE.
Thanks, David
THIS IS THE .XML FILE DATA. THE NAME OF THE FILE WILL NEED TO BE THE FIRST COLUMN IN THE ROW OF EXCELL DATA
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="recipe.xsl"?>
<TAGLIST>
<TAG>
<NAME>hmi_Spin_at_Dip</NAME>
<VALUE>1</VALUE>
</TAG>
<TAG>
<NAME>hmi_Hopper_Lower</NAME>
<VALUE>1</VALUE>
</TAG>
<TAG>
<NAME>hmi_Double_Cycle</NAME>
<VALUE>0</VALUE>
</TAG>
<TAG>
<NAME>hmi_Double_Dip</NAME>
<VALUE>0</VALUE>
</TAG>
<TAG>
<NAME>hmi_Numb_Dump</NAME>
<VALUE>0</VALUE>
</TAG>
<TAG>
<NAME>hmi_Batch_Weight</NAME>
<VALUE>150</VALUE>
</TAG>
<TAG>
<NAME>hmi_Dip_Speed</NAME>
<VALUE>10</VALUE>
</TAG>
<TAG>
<NAME>hmi_Spin_Speed</NAME>
<VALUE>400</VALUE>
</TAG>
<TAG>
<NAME>hmi_Dip_Time</NAME>
<VALUE>10</VALUE>
</TAG>
<TAG>
<NAME>hmi_Spin_Time</NAME>
<VALUE>30</VALUE>
</TAG>
<TAG>
<NAME>hmi_Number_of_Spins</NAME>
<VALUE>3</VALUE>
</TAG>
<TAG>
<NAME>hmi_InVibe_Speed</NAME>
<VALUE>0</VALUE>
</TAG>
<TAG>
<NAME>hmi_Conveyor_Speed</NAME>
<VALUE>0</VALUE>
</TAG>
<TAG>
<NAME>hmi_Customer_Name</NAME>
<VALUE>INFASTECH</VALUE>
</TAG>
<TAG>
<NAME>hmi_Part_Description</NAME>
<VALUE>M8</VALUE>
</TAG>
<TAG>
<NAME>Recipe_Top_Coat_Type</NAME>
<VALUE>TNT-12</VALUE>
</TAG>
</TAGLIST>
AN EXAMPLE OF HOW THIS RECIPE ABOVE WOULD BE PUT INTO EXCELL WOULD BE BELOW: THE FILE NAME IN COLUMN A THEN THE DATA BETWEEN <VALUE> ????</VALUE> IN COLUMNS AFTER THAT. THEN i WOULD NEED TO CHANGE SOME OF THE DATA A RE-CREATE ALL THE NEW XML FILES USING THE DATA FROM EACH ROW IN THE EXCELL FILE. DOES THIS MAKE SENSE?
FILENAME , 1,1,0,0,0,150,10,400,10,30,3,0,0,INFASTECH,M8,TNT-12
IF YOU COULD HELP ME i WOULD BE SO APPRECIATIVE.
Thanks, David