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

Published: 25 March 2020
on channel: Sean MacKenzie Data Engineering

15,850

168

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

On this page of the site you can watch the video online How to Split One Column Into Two in Access Using the Split Function with a duration of hours minute second in good quality, which was uploaded by the user Sean MacKenzie Data Engineering 25 March 2020, share the link with friends and acquaintances, this video has already been watched 15,850 times on youtube and it was liked by 168 viewers. Enjoy your viewing!

766