Split("25/12/1" ,"/")
Result "25","12","1"
I would probably use the split function.
Code:Split("25/12/1" ,"/") Result "25","12","1"
More here https://www.techonthenet.com/access/functions/string/split.php
Hi kolait. If you're trying to do this in a query, as the forum title implies, then; unfortunately, you won't be able to use the Split() function directly. If you only have three elements to split, then you might be able to use a combination of the Left(), Mid(), and InStr() functions. Otherwise, you will have to create a custom function to wrap the Split() function in that you can use in your query.
Try this one:thank you.
I just got this out. I couldn't do it for the rest
Left([feild],InStr([feild,"/")-1)
Mid([field],InStr([field],"/")+1,InStr(Mid([field],InStr([field],"/")+1),"/")-1)
Try this one:
(untested)Code:Mid([field],InStr([field],"/")+1,InStr(Mid([field],InStr([field],"/")+1),"/")-1)
It does exist in all versions of Office including 2019/365.
However its VBA only. it can't be used directly in a query (unless called from another function).
thank you
I wish they could be used directly in the query
Hi. I'm surprised that worked without testing. For the right, it's much easier.thank you so much
What to do for the right?
Mid([field],InStrRev([field],"/")+1)
So do we all. But I have good news for you
See https://www.devhut.net/2018/04/22/access-using-split-in-a-query/
Hi. I'm surprised that worked without testing. For the right, it's much easier.
Code:Mid([field],InStrRev([field],"/")+1)
So do we all. But I have good news for you
See https://www.devhut.net/2018/04/22/access-using-split-in-a-query/
Hi. You're welcome. We were all happy to assist. Good luck with your project.thank you so much..
It was great..
I tried this but it made an error
It does work. Perhaps you used it incorrectly.
Even though you have a solution, I would recommend trying it again as it is so useful.
If you still get an error please provide details / screenshots