All characters left of a number

[swaink]

Hi All

I wonder if you can assist me please

I am in the process of cleaning up some date (1.5m records) its a slow process but i'm getting there

However I have become stuck on a query for one field, the field should only contain names but in some instances I am seeing address details too

I have been running update queries to tidy up but I am not stuck as to how I can look foir all the characters to the left of a number

for example Mr Jon Do 43 terrace gardens I only want to see Mr Jon Do

I have tried this Expr1: Left([contact],(InStr(1,[contact],'1')-1)) but I wondered if there is anyway to get the left of any numeric value rather than do this one at a time

Any advice appreciated

All the best

Kevin

 

[swaink]

Hi Joe

Not sure if you would have approached this in the same way but think I got there ir appears to work ok

GetText = Trim(Right(myEntry, myLen - i + 1))

All the best

Kev

 

[Joe4]

Perfectly done. Nice job!

 

[swaink]

Morning Joe

Thank you bud it got the grey cells working, appreciate your time

Kev