Re: Reduce the string length ...keystrokes over the last few years. ... > Erma and Rick,... > No need to calculate the actual length of the string.... > number of characters to show is entered, ... (microsoft.public.access.queries)
Re: Reduce the string length ... That is why I used the LEN function to take the string from character number ... >> Rick B ... >>> I want to delete the first three characters in the string ... >>> Erma... (microsoft.public.access.queries)
Re: Carriage return removal ... Thank you for that detailed reply Rick.... The operator compares the String on the left side to a patterned ... > metacharacter (a metacharacter is a character which has a functionality ... > by zero or more text characters.... (microsoft.public.vb.syntax)
Re: Reduce the string length ... > the string length is variable - we are importing from a ticketing system ... > need to remove the first three characters for a mail merge ... >> Rick B ... >>> Erma... (microsoft.public.access.queries)
Re: Reduce the string length ...Erma..."Rick B" wrote: ... >> I want to delete the first three characters in the string... (microsoft.public.access.queries)