Do you have the following settings?
First split at comma and then split the state / zip at the space?
Would that do the trick?
How do you import the result from Google Maps? Do you get the first result in a string value or are you receiving the JSON result?
I would suggest to use the JSON output from Google because then you can use the object types that Google provides. https://developers.google.com/maps/documentation/geocoding/intro.
But off course you can also use default Mendix string operations: https://docs.mendix.com/refguide7/string-function-calls.