I have previous program experience and I officially have no clue what is going on.
I am paring something that follows this pattern "STREETNAME|CITY, STATEABRREVIATION ZIP" (Currently my address parsing tool doesn't exist in the .dll on the server). So I successfully parsed the Street name, abbreviation and zip. The problem is with the City.
It only works on some and I have no idea why. I found the position of "|" and the position of "," . And took the substring between those. It works for some. But for other it will list the first position as 28 (I made it it's own field for troubleshooting) the second is 35. But the substring given is 15 characters long.
Any ideas will be helpful (the inconsistency is what is tripping me up)