Trans-ethyl methyl ether in space. A new look at a complex molecule in selected hot core regions