splitting a string 1

[scotchjc]

I'm sure this is easy but I'm having a block....

I've got a string with "city, st zip" and I need to break it into three strings, one each for city state and zip.



John Crystal

http://www.jcrystalconsulting.com

 

[bdreed35]

here is an example on how to do it:

stringvar array Address := split(replace(replace({table.field}," ","/"),",",""),"/");

stringvar city := Address[1];
stringvar state := Address[2];
stringvar zip := Address[3];

~Brian