Removing Period from list of names (1 Viewer)

[mike.molina]

I have a query which contains a list of names; ex: MOLINA, MSGT MIKE D.

I want to be able to remove the period; however, not all names contain a period because some users do not have a middle initial. The code I used to remove the period worked but I now have an error in the field which did not contain a period. Below is the formula used...please help:

Resource Name: Trim(Left([Expr3],(InStr(1,[Expr3],".")-1)))

Thanks for the help!!

R/s,
Michael Molina

 

[jdraw]

You could use the Replace function and replace the period with a space or nothing.
See Replace

 

[mike.molina]

Thanks JDraw I will try that out.

R/s,
Mike