Left function

sameersabri

New member
Local time
Today, 17:15
Joined
Jan 14, 2016
Messages
5
Hey Everyone!

How can I take two or three words from left side of a field in access 2007 query, where it is separate with comma, dash, space or double space
thanks!
 
use split() function.
 
Please provide some samples to work with. When do you need two and when do you need three words?

Here a rough sketch on how to do it.
Replace comma, dash, space and/or double space with a unique character like a comma.
using the split command you can separate the second or third word from the query result.

HTH:D
 

Users who are viewing this thread

Back
Top Bottom