Link to home
Start Free TrialLog in
Avatar of Joel Allen
Joel Allen

asked on

Access query split function


In an Access query in design mode, I need a simple way to split a string.  It will have more than three values.

Let's say my field Apple = "Hello,my,name,is,joel"

I want to do this:

Field A: Split ([Apple], "," 4)

The result should be "is".

Thanks for your help,
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Joel Allen
Joel Allen


I'm sorry, I forgot how to get the following inserted into a function.  Can you help me?  I understand the second part though.

Public Function ParseText(TextIn As String, SplitChar As String, X) As Variant
On Error Resume Next
Dim var As Variant
var = Split(TextIn, SplitChar, -1)
ParseText = var(X - 1)
End Function
Oh wait!  I figured it out.  Thank you!
Thank you.  It worked!