I want to remove everything following "by"

Hi I want to remove the words after by .... for example
50 Cent - In da club by Richard
The Game - Hate or lovw it by www.mp3gold.tk
To
50 Cent - In da club
The Game - Hate it or love it
Somebody can help me please

Create an action of the type "Replace with regular expression" for whatever field that is.
Search string: by .*
Replace with:
(leave empty)
(insert a space in front of the "by" - the forum parser always eats them up)

Thank yo you re the man