No i really dont want to do this manually
Try this on a small set of data. You can use regular expressions.