Extracting 6 characters in a field 1

[julius1]

I am trying to work the mid function in the query. I have a column that has a list of text entries. The entries look like this:
E.123456.c, but with many different sets of numbers.
I am trying to run the mid function like this:
Mid([Object],3,6)
Object being the title of the field, 3 being 3 digits in, and 6 being the count of digits extracted.

I am not sure what I am missing, all my runs come up blank, no entries in the result.

julius.gazdag@centurytel.com
Im a Telco guy, I can get you where you want to go, but I can't guarantee it will work when you get there!

 

[julius1]

Correction the field I have set up is expr: object
in my criteria I have it set up as:
Mid([Object],3,6)

julius.gazdag@centurytel.com
Im a Telco guy, I can get you where you want to go, but I can't guarantee it will work when you get there!

 

[KenReay]

Hi

"Correction the field I have set up is expr: object
in my criteria I have it set up as:
Mid([Object],3,6) "

Why in the Criteria?

Could you explain what youa re trying to do?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[PaulBricker]

Just put the expression on the Field line of your query.
MyVal:Mid([Object],3,6)

That should do what you want.

Paul

 

[julius1]

Paul, thats the ticket. Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!

julius.gazdag@centurytel.com
Im a Telco guy, I can get you where you want to go, but I can't guarantee it will work when you get there!