4 Part Extract - Fields are not in the same order

F

Fly_Paper

New Member
Joined
Mar 25, 2014
Messages
1
I am getting a 4 part extract from an enterprise tool which come out in XML, that was irritating but I can work around that, but whats weird is that when I import the data into excel the fields are moving around (see screen shot). No one can seem to either explain to me why this is happening or fix it so I guess I am stuck with the problem.

My question is (drum roll) is there a way to normalizse the fields so that "Landscape_name" always goes to column A and "Landscape_handle" always goes to column B for example? I have highlighted the fields below which seem to be in motion. My assumption is that if I were to pull this extract again diffrent fields would move around which is why I would like to "fix" their position if possible

[TABLE="width: 544"]
<colgroup><col style="width: 136pt; mso-width-source: userset; mso-width-alt: 6619;" span="4" width="181"> <tbody>[TR]
[TD="class: xl63, width: 181, bgcolor: transparent"]landscape_name[/TD]
[TD="class: xl63, width: 181, bgcolor: transparent"]landscape_name[/TD]
[TD="class: xl63, width: 181, bgcolor: transparent"]landscape_name[/TD]
[TD="class: xl63, width: 181, bgcolor: transparent"]landscape_name[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]landscape_handle[/TD]
[TD="class: xl63, bgcolor: transparent"]landscape_handle[/TD]
[TD="class: xl63, bgcolor: transparent"]landscape_handle[/TD]
[TD="class: xl63, bgcolor: transparent"]landscape_handle[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]name[/TD]
[TD="class: xl63, bgcolor: transparent"]name[/TD]
[TD="class: xl63, bgcolor: transparent"]name[/TD]
[TD="class: xl63, bgcolor: transparent"]name[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]model_type[/TD]
[TD="class: xl63, bgcolor: transparent"]model_type[/TD]
[TD="class: xl63, bgcolor: transparent"]model_type[/TD]
[TD="class: xl63, bgcolor: transparent"]model_type[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]model_handle[/TD]
[TD="class: xl63, bgcolor: transparent"]model_handle[/TD]
[TD="class: xl63, bgcolor: transparent"]model_handle[/TD]
[TD="class: xl63, bgcolor: transparent"]model_handle[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Network_Address[/TD]
[TD="class: xl63, bgcolor: transparent"]Network_Address[/TD]
[TD="class: xl63, bgcolor: transparent"]Network_Address[/TD]
[TD="class: xl63, bgcolor: transparent"]Network_Address[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Security_String[/TD]
[TD="class: xl63, bgcolor: transparent"]Security_String[/TD]
[TD="class: xl63, bgcolor: transparent"]Security_String[/TD]
[TD="class: xl63, bgcolor: transparent"]Security_String[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Value_When_Orange[/TD]
[TD="class: xl63, bgcolor: transparent"]Value_When_Orange[/TD]
[TD="class: xl63, bgcolor: transparent"]Value_When_Orange[/TD]
[TD="class: xl63, bgcolor: transparent"]Value_When_Orange[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Value_When_Yellow[/TD]
[TD="class: xl63, bgcolor: transparent"]Value_When_Yellow[/TD]
[TD="class: xl63, bgcolor: transparent"]Value_When_Yellow[/TD]
[TD="class: xl63, bgcolor: transparent"]Value_When_Yellow[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]subnet_mask[/TD]
[TD="class: xl63, bgcolor: transparent"]subnet_mask[/TD]
[TD="class: xl63, bgcolor: transparent"]subnet_mask[/TD]
[TD="class: xl63, bgcolor: transparent"]subnet_mask[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Value_When_Red[/TD]
[TD="class: xl63, bgcolor: transparent"]Value_When_Red[/TD]
[TD="class: xl63, bgcolor: transparent"]Value_When_Red[/TD]
[TD="class: xl63, bgcolor: transparent"]Value_When_Red[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]network_address2[/TD]
[TD="class: xl63, bgcolor: transparent"]network_address2[/TD]
[TD="class: xl63, bgcolor: transparent"]network_address2[/TD]
[TD="class: xl63, bgcolor: transparent"]network_address2[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]name3[/TD]
[TD="class: xl63, bgcolor: transparent"]name3[/TD]
[TD="class: xl63, bgcolor: transparent"]name3[/TD]
[TD="class: xl63, bgcolor: transparent"]name3[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]model_type4[/TD]
[TD="class: xl63, bgcolor: transparent"]model_type4[/TD]
[TD="class: xl63, bgcolor: transparent"]model_type4[/TD]
[TD="class: xl63, bgcolor: transparent"]model_type4[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]model_handle5[/TD]
[TD="class: xl63, bgcolor: transparent"]model_handle5[/TD]
[TD="class: xl63, bgcolor: transparent"]model_handle5[/TD]
[TD="class: xl63, bgcolor: transparent"]model_handle5[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]sysUpTime[/TD]
[TD="class: xl64, bgcolor: yellow"]TopologyModelNameString[/TD]
[TD="class: xl63, bgcolor: transparent"]sysUpTime[/TD]
[TD="class: xl63, bgcolor: transparent"]sysUpTime[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: yellow"]USER_AssetOwner[/TD]
[TD="class: xl64, bgcolor: yellow"]sysUpTime[/TD]
[TD="class: xl64, bgcolor: yellow"]community_string[/TD]
[TD="class: xl64, bgcolor: yellow"]USER_AssetOwner[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: yellow"]community_string[/TD]
[TD="class: xl64, bgcolor: yellow"]USER_AssetOwner[/TD]
[TD="class: xl64, bgcolor: yellow"]TopologyModelNameString[/TD]
[TD="class: xl64, bgcolor: yellow"]community_string[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: yellow"]TopologyModelNameString[/TD]
[TD="class: xl64, bgcolor: yellow"]community_string[/TD]
[TD="class: xl64, bgcolor: yellow"]USER_AssetOwner[/TD]
[TD="class: xl64, bgcolor: yellow"]TopologyModelNameString[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]sysLocation[/TD]
[TD="class: xl63, bgcolor: transparent"]sysLocation[/TD]
[TD="class: xl63, bgcolor: transparent"]sysLocation[/TD]
[TD="class: xl63, bgcolor: transparent"]sysLocation[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
You must log in or register to reply here.

Similar threads

A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
1K
AndyEd
A
A
  • Solved
Calendar issue
Replies
1
Views
2K
AndyEd
A
L
  • Question Question
VBA works on work PC but not home PC
Replies
3
Views
2K
rollis13
rollis13
Gerald Higgins
  • Question Question
VBA, make code move across from main file to extract file
Replies
9
Views
2K
Gerald Higgins
Gerald Higgins
J
  • Question Question
Calculate smallest number of adjustments to get columns in correct order
Replies
1
Views
682
Eric W
Eric W

Forum statistics

Threads
1,223,236
Messages
6,170,906
Members
452,366
Latest member
TePunaBloke

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top