parse a field

[aspnetuser]

I have a field
san fransisco, CA 19111


I need to create three formulas, C S Z

The delimiters are always , space, space]

what is the best way to do this?

 

[bdreed35]

Here is one way to do it:

//@City
stringvar array address := split({table.address},", ");
address[1]

//@State
stringvar array address;
split(address[2]," ")[1]

//@Zip
stringvar array address;
split(address[2]," ")[2]

~Brian