AnsweredAssumed Answered

remove the last word in a string

Question asked by derklauer on Aug 16, 2012
Latest reply on Aug 16, 2012 by bruce.nielsen
How does one remove the last word in a string if the field I am querying has variable character lengths?  I.e:

1234 S Man 77025
123 Main 00865

I want to remove the zip code here but the character counts vary.

Outcomes