is there any way to know when I picked up this nasty infection?
No.

Install Panda USB Vaccine, or BitDefender’s USB Immunizer on your computer to protect it from any infected USB device.
Now you can safely connect your external drive and scan it with your AV program.
Scan all CDs as well.