str – 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…

Python – Difference between str and repr

Posted on March 21, 2021 by

Vitosh Posted in Python

__repr__ and __str__ dunders are quite similar in Python. If you need a quick summary of these 2, then these 3 points will be enough: __repr__ dunder presents the class object, whenever it is called by the terminal __str__ dunder…

Tag: str

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

Python – Difference between __str__ and __repr__

Python – Difference between str and repr