XML edit tags based on attribute

VB2008

this is the xml:

<UserParams>
  <userName name="User 1" active="0">
    <Login>
      <Locations>
        <Location name="Dogwood">
          <Files>\\Dogwood\ppmp\data</Files>
          <SQLname>dogwood\DOGWOOD</SQLname>
          <DatabaseName>dbname</DatabaseName>
        </Location>
        <Location name="SUP0001 (NPI)">
          <Files>\\npi-server\ppmp\data</Files>
          <SQLname>npi-server\SQLNPI</SQLname>
          <DatabaseName>ppmp</DatabaseName>
        </Location>
        <Location name="SUP0002 (TS)">
          <Files>\\d14byhd1\ppmp\Data</Files>
          <SQLname>d14byhd1\DBTS</SQLname>
          <DatabaseName>ppmp</DatabaseName>
        </Location>
        <Location name="SUP0003 (JB)">
          <Files>\\ppmp\ppmp\data</Files>
          <SQLname>PPMP\DBJB</SQLname>
          <DatabaseName>ppmp</DatabaseName>
        </Location>
      </Locations>
      <RememberCurrent>1</RememberCurrent>
    </Login>
    <Toolbars>
      <leftLists>True</leftLists>
      <snapShot>True</snapShot>
    </Toolbars>
    <Splitters>
      <mainDistance>335</mainDistance>
      <leftDistance>320</leftDistance>
    </Splitters>
    <Options>
      <Option name="General">
      </Option>
      <Option name="Data">
      </Option>
      <Option name="Display">
        <listDefault>Items</listDefault>
        <listOnLeft>Billing Groups|Items|Vendors</listOnLeft>
        <listOpenOnly>Marketing Orders|Purchase Orders|Vendors</listOpenOnly>
      </Option>
      <Option name="Files and Printers">
      </Option>
      <Option name="Privileges and Security">
      </Option>
    </Options>
  </userName>
  <userName name="User 2" active="1">
    <Login>
      <Locations>
        <Location name="Office">
          <Files>\\Officeppmp\data</Files>
          <SQLname>office\SQLDB</SQLname>
          <DatabaseName>namedb</DatabaseName>
        </Location>
        <Location name="SUP0002 (TTS)">
          <Files>\\tts-server\ppmp\data</Files>
          <SQLname>tts-server\SQLTTS</SQLname>
          <DatabaseName>ppmpDB</DatabaseName>
        </Location>
        <Location name="SUP0002 (TS)">
          <Files>\\d14byhd1\ppmp\Data</Files>
          <SQLname>d14byhd1\DBTS</SQLname>
          <DatabaseName>ppmp</DatabaseName>
        </Location>
        <Location name="SUP0003 (JB)">
          <Files>\\ppmp\ppmp\data</Files>
          <SQLname>PPMP\DBJB</SQLname>
          <DatabaseName>ppmp</DatabaseName>
        </Location>
      </Locations>
      <RememberCurrent>1</RememberCurrent>
    </Login>
    <Toolbars>
      <leftLists>True</leftLists>
      <snapShot>True</snapShot>
    </Toolbars>
    <Splitters>
      <mainDistance>335</mainDistance>
      <leftDistance>320</leftDistance>
    </Splitters>
    <Options>
      <Option name="General">
      </Option>
      <Option name="Data">
      </Option>
      <Option name="Display">
        <listDefault>Items</listDefault>
        <listOnLeft>Billing Groups|Items|Vendors</listOnLeft>
        <listOpenOnly>Marketing Orders|Purchase Orders|Vendors</listOpenOnly>
      </Option>
      <Option name="Files and Printers">
      </Option>
      <Option name="Privileges and Security">
      </Option>
    </Options>
  </userName>
</UserParams>

How do I change / edit tag "listOnLeft" based on the user name?

Thanks,

S
Start Free Trial