CONTACT US: 778-373-4422 | info@mackenziemackenzie.com


Photo by John Finkelstein and Fotografiende from Pexels

How to Use Left, Mid, Right, and Split to Slice and Dice Strings in vb.Net

25-December-2020
In this episode, we’re going to learn how to use vb.Net’s Left, Mid, Right, and Split to get parts of our strings for all kinds of purposes. Learning these four functions is critical to having an ability to manipulate string data for many purposes, including custom ETL procedures. We’ll use some examples of part numbers that need to be split up, like “ABC-111-4444”, and we’ll cover splitting these values when each substring is of a uniform length, and when it is of a variable length.



Need help on an ETL Project? Contact me today!

3 Reasons Why You Should Learn Data Techniques

Find 3 big reasons why you should learn data techniques if you are a professional or business person.

Read article

About our workshop

The Professional Problem, 3 Things They Need, and 1 They Don't Have

Why do people constantly run into problems with their data, even when they are highly trained in their area?

Read article

About our workshop

Why Finding Uniqueness is the Key: 6 Methods to Help

Find out why keys and uniqueness are so important for data transformation and data analysis.

Read article

About our workshop

When to Excel and When Not To: Why Specialists Don't Use Excel for Data Transformations

Start your journey in data transformation, and learn why specialists don't use Excel to transform raw data for analysis.

Read article

About our workshop