Find Function in Excel not in Access

[christopher007]

Does anyone know, how you can search for a character in a string like the Find function in Excel. I have a field Full Name that is first name and surname together; I need to strip out the first letter of the surname to sort on.

 

[WildHare]

Ok, are you talking substringing (stripping out n letters) or FINDING a character IN a string? Your post is unclear.

Access can do either:

Left({somestring},1) - gives you the first character of a string.

Instr({somestring}, {character}) returns the postion of {character} in the string {string}

Instr("Bellicose", "c&quot returns 6

There is also a seldom used REVSTR() function to return the position of {character} in {string}, starting from the END of the string and working LEFTwards.

Hope this is what you're looking for.. ??

Jim


Don't be sexist - Broads hate that.
Another free Access forum:

http://www.forumco.com/jmhare

More Access help stuff at

http://www.jmhare.com/wildhare.htm

 

[christopher007]

Instr({somestring}, {character}) returns the postion of {character} in the string {string}

Is exactly what i was looking for so will give it a go, i couldnt find this in access anywaere builder help ect

Much appricated Jim
Regards

 

[WildHare]

Good. Plus, note a boo-boo in my first post:

Backwards find is RevInStr(), not RevStr()

Don't be sexist - Broads hate that.
Another free Access forum:

http://www.forumco.com/jmhare

More Access help stuff at

http://www.jmhare.com/wildhare.htm