Ok,
If you inbound data is presented as you have described, it appears that the field may be getting used inappropriately.
How would 123 Main ST, Apt 207, Fargo ND 58108 be presented.
Generally this would be
123 Main St^Apt 207^Fargo^ND^58108
If your inbound data is actually being sent as described, then there is no uniformity within your data. This could be next to impossible to code for. At least based on the example you have given.
I would recommend verifying your inbound data, and have the vendor or application responsible give you consistantly placed data.
Ryan
