[AccessD] Remove Beginning & Ending Quotes of a string

Stuart McLachlan stuart at lexacorp.com.pg
Mon Sep 6 17:17:59 CDT 2004


On 6 Sep 2004 at 17:51, Robert Gracie wrote:

> 
> Example "This is a "Fine" Day we are having to day"
> 
> I need to remove only the first and last quotes.
> 
>    This is a "Fine" Day we are having to day
> 

Mid$(myString,2,Len(myString)-2) will drop the first and last character, 
whatever they are.


-- 
Stuart





More information about the AccessD mailing list