Hello everyone,

I have a field named CityStateZip. It has a value like Milwaukee, WI 53203. I need to pull the first, second and third words separately using VBscript. Is there a way to do this if you don't always know the number of characters?

Thank you in advance.