mid – Useful code

VBA – Get Substring Between 2 Substrings – Locate value of Nth XML

Posted on March 18, 2022 by

Vitosh Posted in Just Tricks, VBA \ Excel

Getting N-th string between two substrings might sound a bad idea, until you do not need it. And with VBA, you better have something prepared. So, imagine the following XML (from this article here):

<FootballInfo>
  <row>
    <ID>1</ID>
    <FirstName>Peter</FirstName>
    <LastName>The Keeper</LastName>
    <Club name ="NorthClub">
		<ClubCoach>Pesho</ClubCoach>
		<ClubManager>Partan</ClubManager>
		<ClubEstablishedOn>1994</ClubEstablishedOn>
	</Club>
    <CityID>1</CityID>
  </row>
  <row name="Row2">
    <ID>2</ID>
    <FirstName>Ivan</FirstName>
    <LastName>Mitov</LastName>
    <Club name = "EastClub">
		<ClubCoach>Gosho</ClubCoach>
		<ClubManager>Goshan</ClubManager>
		<ClubEstablishedOn>1889</ClubEstablishedOn>
	</Club>
    <CityID>2</CityID>
  </row>
</FootballInfo>

<row>

<FirstName>Peter</FirstName>

<LastName>The Keeper</LastName>

<ClubCoach>Pesho</ClubCoach>

<ClubManager>Partan</ClubManager>

</Club>

</row>

<LastName>Mitov</LastName>

<ClubCoach>Gosho</ClubCoach>

<ClubManager>Goshan</ClubManager>

</Club>

</row>

</FootballInfo>

Your task is to get…

Tag: mid

VBA – Get Substring Between 2 Substrings – Locate value of Nth XML