There is no good way to do this. But if you are sure that the data will always be in this format, then here is the basic algorithm to follow.

1. Replace CRLF with comma.
2. Split on comma.
3. First part of the splitted string is Street, second is City.
4. Split the third part on space.
5. The first part of this splitted string is your State and second part is the Zip.

You can use the Split function and Replace function to do this job.