Recent content by yangya

OK, first, many thanks to all of you who posted. I finally found something that works. From a post by sxschech in a thread called, "Split text into a new column" (post #3), I put the function in Excel and then just created columns in my table using that. I put the [Barcode] field in my access...

I think I wasn't really clear with my terminology, so I'll try again. I'm trying to use Excel to pull data from the query in my Access db (that query is using the custom function called 'TextSplit' - which by the way works perfectly when its run inside Access). It's Excel that's throwing the...

Need to extend this post... The issue I'm having now is when I try to import the data by using excel, I get the following error message "Undefined function 'TextSplit' in expression.

I thought I sent this reply in before, but here it is again: Thank you all for your help. I finally got the jist of what I need to do (June7's answer - slightly tweaked from ridders code) did the trick. Again, many thanks to all who replied!!!

Thank you ridders. Problem is that the strText will change on each record. PS: I don't mind "messy" using Mid & InStr if it will just give me the answer. There's a need to just get the expression in a saved query. Thanks again.

Thank you NauticalGent for your help, but as a newbie I'm just not getting it. Isn't there just simply a modification to: Mid([Barcode],InStr([Barcode],"-")+1,(InStr(InStr([Barcode],"-")+1,[Barcode],"-") -InStr([Barcode],"-"))-1) to get me what I need?

Not really following you. I thought just some of the things in the query statement would need to be slightly modified?

I've seen this answered before but it was always for the text between the first and second hyphen (I need the text that's between the second and third hyphen). This is what I found that returns the text between first and second hyphen...