How to Use Left, Mid, Right, and Split to Slice and Dice Strings in vb.Net
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!