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
<colgroup><col style="width: 136pt; mso-width-source: userset; mso-width-alt: 6619;" span="4" width="181"> <tbody>
</tbody>
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
landscape_name | landscape_name | landscape_name | landscape_name |
landscape_handle | landscape_handle | landscape_handle | landscape_handle |
name | name | name | name |
model_type | model_type | model_type | model_type |
model_handle | model_handle | model_handle | model_handle |
Network_Address | Network_Address | Network_Address | Network_Address |
Security_String | Security_String | Security_String | Security_String |
Value_When_Orange | Value_When_Orange | Value_When_Orange | Value_When_Orange |
Value_When_Yellow | Value_When_Yellow | Value_When_Yellow | Value_When_Yellow |
subnet_mask | subnet_mask | subnet_mask | subnet_mask |
Value_When_Red | Value_When_Red | Value_When_Red | Value_When_Red |
network_address2 | network_address2 | network_address2 | network_address2 |
name3 | name3 | name3 | name3 |
model_type4 | model_type4 | model_type4 | model_type4 |
model_handle5 | model_handle5 | model_handle5 | model_handle5 |
sysUpTime | TopologyModelNameString | sysUpTime | sysUpTime |
USER_AssetOwner | sysUpTime | community_string | USER_AssetOwner |
community_string | USER_AssetOwner | TopologyModelNameString | community_string |
TopologyModelNameString | community_string | USER_AssetOwner | TopologyModelNameString |
sysLocation | sysLocation | sysLocation | sysLocation |
<colgroup><col style="width: 136pt; mso-width-source: userset; mso-width-alt: 6619;" span="4" width="181"> <tbody>
</tbody>