A thought occurred: I could copy the raw data into a new field (so it can be manipulated) and then delete everything before shipping_street and that way the first ", would always be the first occurrence. Not 100% sure on how, but I'm looking to see what function might help me out with this one.
My Parsing Links
end = Position ( T ; "\"," ; start ; 1 ) +2
to find the first instance after the search text instead of the 16th from the beginning.
David: Thanks for the reading, I'll check those out for sure. The API I'm getting the info from gives it to me in JSON so that first link should be helpful.
Phil: Thanks, it didn't occur to me to change that parameter. It works perfectly.