Delete text

[Guest]

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!

 

[John Vinson]

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]

 

[Guest]

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?

 

[John Vinson]

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]

 

[Guest]

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!!