Delete everything after a string
sed 's/\.com.*/.com/'

example: sed 's/\.com.*/.com/' filename >> filename

Delete everything before a certain word

example: sed 's/^.*can/can/' filename >> filename