This is in one column. I would like to be able to separate the city state and zip to their own columns. Below is an example of what comes into one column

example
4768 LOGAN AVE A | SAN DIEGO 921133759