How to remove left side of text

[galsaba]

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

[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

[limpid lizzard]

try
left$
mid$
right$

ie:

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

[Randy Harris]

"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

[Douglas J. Steele]

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