March 2022 – Useful code

Python – Plotting a circle with matplotlib

Posted on March 30, 2022 by

Vitosh Posted in Python

Plotting a circle with matplotlib library in python is an interesting task. If you google it, you will find quite good answers, but anyway, I am here because I want to summarize my point of view. Pretty much, the idea…

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…

Month: March 2022

Python – Plotting a circle with matplotlib

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