Microsoft Access - Insert part of a string up until a specific character
I'll keep this simple:
I have three textboxes and a button.
textbox1 is used as user input
button1 is pressed and this gives textbox2 and textbox3 a specific value based on the string from textbox1.
For example- User input: 'Hello & welcome everybody'
textbox2.Value = 'Hello'
textbox3.Value = 'welcome'
So basically, how do I go about selecting part of a string up until a certain character?
And also, how do I go about selecting part of a string between a certain character/words (In this case, between '&' and 'everybody'
I know I could dim two variables as strings to store them, then set the value of the textboxes to equal the variables. But I don't know what code to use to obtain the specific parts of the string in the first place. Any ideas?