Take a look at the StringSplit action in the Community Commons module in the Marketplace.
https://docs.mendix.com/appstore/modules/community-commons-function-library/#39-stringutils
You pass a String in, and you get a list of Objects with a single string attribute in it. These are returned in the same order as the String you passed in, so you can go through this list and extract the values for latitude and longitude for your different entity.
Hope this helps.