How to Split One Column Into Two in Access Using the Split Function

In this video we're going to learn how to split one column into two by using the Split function in Microsoft Access and VBA. As long as there is a definite pattern in the source column, it is easy to use the split pattern to separate elements into their own columns. This can be used with any delimiters; for example , ~ | or even multi-character delimiters like ", " or a word with spaces " and " etc. Because you're using a custom function, it gives powerful results because you can add extensive programming to handle exceptions, muddy data, complex transformations, and more. I use this one all the time in transformations. It can also be used in vb.Net for batch transformations etc. Use it to just split one column into two, or walk through a 50 column CSV file and split up data row by row for intricate transformations. The possibilities are endless. Related Videos: How to Use Union Queries in MS Access    • How to Use Union Queries in MS Access   How to Split One Column Into Two in Access Using the Split Function You are watching this video now! How to Query the Last Row in a Series in Microsoft Access    • How to Query the Last Row in a Series in M...   How to Format Dates in MS Access Queries, Forms, and VBA Code    • How to Format Dates in MS Access Queries, ...   How to Use Nz in Microsoft Access to Handle Null and Empty Values    • How to Use Nz in Microsoft Access to Handl...   How to Use Crosstab Queries in MS Access    • How to Use Crosstab Queries in MS Access   How to Use Functions in MS Access Queries    • How to Use Functions in MS Access Queries   Follow us on social media:   / mackenziedataanalytics     / seamacke     / seamacke     / seamacke     / psmackenzie   Thank you to my viewers! Mention Promo Code SMDE25TWELVE for 25% off a twelve-month virtual machine subscription at: https://beaverdamtechnologies.ca Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenz... how to split one column into two in access using the split function split one column into two in access access vba split function vba split function vba split function example how to split a delimited string in access data analytics data analysis data transformation data science microsoft access split function visual basic for applications sean mackenzie