need help finding lower case characters (1 Viewer)

[RUDOLFSUN]

hello if any one can help me create a query that pick out lower case characters from the beggining of words, and the beggining of each word in a sentance , my christmas would be made!



Thanks in advance

 

[llkhoutx]

you don't give enough information for a query.

Lower case alpha characters have values between 97 and 122 inclusive.

A query column would be istch:ASC(left(fieldName,1)); the criteria for that column would be >= 97 AND <= 122 to display them, or < 97 OR > 122 to omit them.

The ASC function converts a character to a numeric value.

 

[RUDOLFSUN]

great thanks for that my job has become so much easier!

 

[RUDOLFSUN]

right I tried this out in xp and I get a Data Missmatch error.

what am I doing wrong

 

[llkhoutx]

What does

this

mean?

Post what you tried.

 

[RUDOLFSUN]

the code that is mentioned above ASCleft([fieldname],2))>97<***

 

[Fifty2One]

you are missing a (
ASCleft([fieldname],2))>97

in your query put
Expr1: ASC(left(fieldName,1))
in the criteria put
>= 97 AND <= 122

 

[RUDOLFSUN]

that's just a typo, I still get the error

 

[DALeffler]

Try this:

expr1: IIf(Val([fieldname]),1,Asc(Left([fieldname],1)))
in the criteria put
> 96 AND < 123

 

[RUDOLFSUN]

Ok tried that last post and I still get the same error,'data type missmatch'

the query then spits out just the value #name?

 

[DALeffler]

Do you have empty records in your table?

If so, try this:
Expr1: IIf(IsNull([YourTableFieldNameGoesHere]),1,Asc(Left([YourTableFieldNameGoesHereAlso],1)))

and the criterea as before.

 

[RUDOLFSUN]

same thins happens, now if i take the criteria out, it works fine and gives me the ASCII value

 

[DALeffler]

Can you post your SQL statement?

The one I'm using for my query looks like this:

SELECT TRefs.tRef, IIf(IsNull([tref]),1,Asc(Left([tref],1))) AS expr1
FROM TRefs
WHERE (((IIf(IsNull([tref]),1,Asc(Left([tref],1))))>64 And (IIf(IsNull([tref]),1,Asc(Left([tref],1))))<91));

It works fime for me...

 

[RUDOLFSUN]

aha you absolute beauty i was just about to post the sql and ran it again and it worked fine!!

I could kiss you

now if I want to do that but for various words such as ,"Systems engineer cisco"

How would you pull the last two words out of the field

does this make sense?