Extract Text from Equation 1

[Knicks]

I have a field where the data is

John Smith(4321)
Adrian Bellows(5432)
William Grey(123)

I need to extract the name portion only stripping out "(", ")", and the numeric portion. There is very few examples of where the numeric portion is 3 digits instead of 4 but it would be great if it is flexible enough to always strip the Parentheses and numbers. Any help would be great,

Thank you

 

[SkipVought]

Hi,

Use the Split() function on the OPEN PARENTHESIS

msgBox Split(YourFld, "(")(0)

 

[dhookom]

Try something like:

Left([YourUnnamedField] & "(", Instr([YourUnnamedField] & "(","(")-1)

Duane
Hook'D on Access
MS Access MVP

 

[Knicks]

Dhookom

Perfect! Thanx