Link to home
Start Free TrialLog in
Avatar of patsylipp
patsylipp

asked on

parse out string field in crystal

I have a string field that holds city, state zip I need to parse out state for a crystal reprot
ASKER CERTIFIED SOLUTION
Avatar of JayConverse
JayConverse
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of James0628
James0628

mlmcc,

 That won't work so well with city names that are 2 or more words.  But, then again, what are the odds of that happening?  ;-)

 James
It woudl be far simpler to help you if you at least provided a sample of your data format rather than having to guess.