Delete text

's Computer Specifications

Hi,
I have a query with result "Your name is XYZ". I would like to put command
which could delete text "Your name is " and as final result I want just
"XYZ".
Please help.

Thnx!

's Computer Specifications

On Fri, 8 Sep 2006 23:53:16 +0200, <John> wrote:

>Hi,
>I have a query with result "Your name is XYZ". I would like to put command
>which could delete text "Your name is " and as final result I want just
>"XYZ".
>Please help.
>
>Thnx!
>
>

A calculated field

JustName: Mid([fieldname], 14)

will trim off the first 13 characters ("Your name is ").

John W. Vinson[MVP]

's Computer Specifications

"John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:(E-Mail Removed)...
> On Fri, 8 Sep 2006 23:53:16 +0200, <John> wrote:
>
>>Hi,
>>I have a query with result "Your name is XYZ". I would like to put command
>>which could delete text "Your name is " and as final result I want just
>>"XYZ".
>>Please help.
>>
>>Thnx!
>>
>>
>
> A calculated field
>
> JustName: Mid([fieldname], 14)
>
> will trim off the first 13 characters ("Your name is ").
>
> John W. Vinson[MVP]

Thnx, but could you be more specific? How can I add this command?

's Computer Specifications

On Sat, 9 Sep 2006 00:43:00 +0200, <John> wrote:

>Thnx, but could you be more specific? How can I add this command?
>

It's not a "command". It's a calculated Field in a Query.

Edit your Query. In a vacant Field cell type

JustName: Mid([fieldname], 14)

using the name of the field which you're trying to truncate in place
of "fieldname". Or, base a new query on your existing query and do the
same.

John W. Vinson[MVP]

's Computer Specifications

"John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:(E-Mail Removed)...
> On Sat, 9 Sep 2006 00:43:00 +0200, <John> wrote:
>
>>Thnx, but could you be more specific? How can I add this command?
>>
>
> It's not a "command". It's a calculated Field in a Query.
>
> Edit your Query. In a vacant Field cell type
>
> JustName: Mid([fieldname], 14)
>
> using the name of the field which you're trying to truncate in place
> of "fieldname". Or, base a new query on your existing query and do the
> same.
>
>
> John W. Vinson[MVP]

Thnx, that's it!!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I delete selected text? I don't see(find) an edit delete	csuu	Microsoft Word Document Management	1	29th Oct 2009 08:38 AM
my delete button doesn't delete highlighted text	=?Utf-8?B?Z3lwc3k=?=	Microsoft Word Document Management	2	27th Mar 2006 04:49 AM
delete key doesn't delete highlighted text in Word; help!	=?Utf-8?B?YWxlZW4=?=	Microsoft Word Document Management	1	10th Jan 2006 05:36 PM
How can I delete blocks of text without being propted "delete y/n.	=?Utf-8?B?QnJvb2tlYXRNYWM=?=	Microsoft Word Document Management	1	15th Feb 2005 04:55 PM
Re: When I highlight a sentence to delete, Word won't let me. I have to backspace. How can I deleted selected text with my delete key?	Bill Foley	Microsoft Word Document Management	1	4th Feb 2004 11:06 PM