Delete some text from a field with other text

[mchadwick]

I am trying to delete some text from a text field. There are almost 8000 records and almost all of them are like this.



Example: johnsmith-2.network.home.com

I want to delete everything after the dot and including the dot, to end up with "johnsmith-2". How do I do that? I think I can do it in a query, but don't remember how.

[June7]

String manipulation functions.

Left([fieldname], InStr([fieldname], ".") - 1)

[mchadwick]

thank you that did the trick, how do I resolve this?

[June7]

Mark Solved with Thread Tools dropdown above first post. Appears to be already done.