By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,089 Members | 2,254 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,089 IT Pros & Developers. It's quick & easy.

How to remove left side of text

P: n/a
What would be the function to remove a portion of a text?
For example, if the text is:"Me John Smith"
or : "Me James Alexander"

RemoVe("Me James Alexander, 3) will return "James Alexander"

Thanks,

galsaba

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
jim
hi galsaba

There are several ways - depending on what you want.

If it is always 3 characters you want to remove, you can use the function
right([Field];len([Field])-3)

Best regards
JJ

"galsaba" <ga*****@aol.com> skrev i en meddelelse
news:11**********************@z14g2000cwz.googlegr oups.com...
What would be the function to remove a portion of a text?
For example, if the text is:"Me John Smith"
or : "Me James Alexander"

RemoVe("Me James Alexander, 3) will return "James Alexander"

Thanks,

galsaba

Nov 13 '05 #2

P: n/a
try
left$
mid$
right$

ie:

mid$("Me James Alexander",1,3)

Nov 13 '05 #3

P: n/a
"limpid lizzard" <go**********@vkam.net> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
try
left$
mid$
right$

ie:

mid$("Me James Alexander",1,3)


I think Mid is the right function to use, but I think it needs to be
slightly different.

Mid("Me James Alexander", 4)

will discard the first three characters and return:

James Alexander

The only difference between Mid and Mid$ - the first returns a variant, the
second a string

Nov 13 '05 #4

P: n/a
Mid([YourField], 4)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"galsaba" <ga*****@aol.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
What would be the function to remove a portion of a text?
For example, if the text is:"Me John Smith"
or : "Me James Alexander"

RemoVe("Me James Alexander, 3) will return "James Alexander"

Thanks,

galsaba

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.