I tried to respond on your other post, but my response is pending approval for some reason. I’ll try again here…

Remove and keep first value (street) in its own field:

IF(FIND(",",{Address Field}&''),TRIM(SUBSTITUTE(LEFT({Address Field}&'',SEARCH(",",{Address Field}&'')),",","")),{Address Field})

Remove and keep everything after the street in its own field:

IF(FIND(",",{Address Field}&''),TRIM(MID({Address Field}&'',SEARCH(",",{Address Field}&'')+1,500)))

Remove and keep the next value (city) in its own field:

IF(FIND(",",{Address Street Removed}&''),TRIM(SUBSTITUTE(LEFT({Address Street Removed}&'',SEARCH(",",{Address Street Removed}&'')),",","")),{Address Street Removed})

Remove and keep everything after the city in its own field:

IF(FIND(",",{Address Street Removed}&''),TRIM(MID({Address Street Removed}&'',SEARCH(",",{Address Street Removed}&'')+1,500)))

Remove and keep next value (state) in its own field:

IF(FIND(",",{Address Street & City Removed}&''),TRIM(SUBSTITUTE(LEFT({Address Street & City Removed}&'',SEARCH(",",{Address Street & City Removed}&'')),",","")),{Address Street & City Removed})

Remove and keep everything after state (zip) in its own field:

IF(FIND(",",{Address Street & City Removed}&''),TRIM(MID({Address Street & City Removed}&'',SEARCH(",",{Address Street & City Removed}&'')+1,500)))

You can likely stop there… if you have more comma-separated values to split out, just continue the pattern.

Hi,

I can help. Please check PM.

Thanks,

Jennifer J

Thanks everyone this has been resolved!