alecgreen said:
I have a text field within my query that I want to display part of:
for example "microsoft" and I just want to display "micro"
Use:
- Left() if you want the left-most characters;
- Mid() if you want characters from the middle;
- Right() if you want the right-most characters.
You may also need to use:
- Len() to calculate how long it is;
- Instr() to locate where one string is found in another.
If you are trying to parse particular words from the string, this may help:
http://allenbrowne.com/func-10.html
For example, after copying the function into your database, you would type
this expression into the Field row in query design to parse the last word
from a field named F1:
ParseWord([F1], -1)
