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

asked on

Access query split function

Hello,

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,
Joel
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
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

ASKER

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!