Using the Split Function in Microsoft Access VBA to Break Apart Strings into Individual Field Values
Вставка
- Опубліковано 19 вер 2024
- In this Microsoft Access tutorial I'm going to teach you how to use the split function in VBA to break apart a text string into its individual component fields.
LEARN MORE:
599cd.com/Spli...
PRE-REQUISITES:
Intro to VBA: 599cd.com/Intr...
TextSplit in Excel: 599cd.com/Text...
LINKS:
MS Split Page: tinyurl.com/2p...
RECOMMENDED COURSES:
Arrays in Access Developer 21: 599cd.com/ACD21
BECOME A MEMBER:
UA-cam: / @599cd
or My Site: 599cd.com/THMe...
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, ms access vba split function example, use VBA to split a string from a text box, Parse a String into Multiple Fields, How to Split One Column Into Two, Undefined function 'Split' in expression
Until this morning, I've always heard and spoken *array* as *uh-ray* and not *air-ray* as you are. 🤔 Props though, for consistency through the tech help.
Potato, potato. :)
@@599CD No, no, no. No one says "potato", It's "array". I had to create a button on my form to mute the video every time you said array and play the proper pronunciation from google. So thanks for the inspiration and great video!🙃🙃
Simply excellent RR!
thanks
Nice and useful.... Thanks again Richard Sir.
welcome
Me ha ayudado mucho. Muchas gracias.
this is very helpful, thanks!
You're welcome
thanks
welcome
I have two questions. I have a concatenated string. I want the first half to be italicied and the second half regular. How do I do that? (or can it be done?)... Also Can you do more videos on PUBLIC SUB (). I always go with Private and I am very interested on how you send a value and a value comes back.
Would you use a trim to get rid of the space at the begining of City, State, and Zip? Sorry it's my OCD..
Sure
Hello, great vid once again!
can this be done for a multi- valued field?
Trying it out, it screams at me saying “is not valid in the expression”
Nope. We do not use multi-valued fields. See 599cd.com/MVF
Hello, Is that possible to use this function if I have two delimiters : and /
cool trick
Thanks
The most important part, "globalMod" is still a mystery
Air-ay? Seriously?
It's a-ray.
You know, when you learn to say a word a certain way when you're young, and then it sticks with you the rest of your life, well, that's how I learned how to say array. Potato, potato; tomato, tomato. That doesn't quite have the same effect in written form, LOL.
@@599CD Still, quite an informative video.