string – 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 – How to write string into a matrix. Printing a matrix.

Posted on January 25, 2020 by

Vitosh Posted in Python

Writing string into a matrix seems like a non-interesting and somehow trivial task. Anyway, manipulating with matrices and strings in Python is actually somehow interesting, thus I have decided to present a small algorithmic challenge. The task is pretty much…

Tag: string

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

Python – How to write string into a matrix. Printing a matrix.