Trim last 2 letters of a word and leave the preceding letters

[jpkeller55]

I have a table that stores spanish verbs wordsAll.tbl. I am trying to make a query that will delete the last two letters of the word leaving the "root". For example:

Word Remove Root
caminar -ar camin
hablar -ar habl
comer -er com
vivir -ir viv

I am guessing it would take a combination of Trim or Left/Right commands but am unsure how to go about since the root may have different lengths. The amount to be removed would always be the same...the last two letters.

Thanks for any help!

 

[IGPCS]

mid(word,1,len(word,1)-2)

this should give it to you

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[jpkeller55]

I am getting a error message saying the expression has the wrong number of arguments...any ideas?

 

[jpkeller55]

Mid([Word],1,(Len([Word])-2))

This worked for me...removed the second 1

Thanks again for your help!!!

 

[IGPCS]

sorry for misspelling

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[PHV]

query that will delete the last two letters of the word
Root: Left([Word],Len([Word])-2)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jpkeller55]

Thanks PHV!