ETL and Data Integration tools - Modern ETL software for everyone

I am using Visual Importer version 4.5.10 and need to convert data from one Excel row to three SQL Server rows. Here is an example of what I'm trying to do:

Spreadsheet row is city/state/zip: "Houston, TX 77025"
Needs to be split to three SQL table columns: City, State, and Zip. All these columns are String types.

Is there a way to do this?

You may use SubString and Pos functions
Following example will return City

SubString("Houston, TX 77025",1,pos(",","Houston, TX 77025")-1)

Oh, I overlooked the POS. That's exactly what I was looking for. Thanks.