I have a process that needs to identify a record based on their current address. I am trying to find an easy way to parse an address string into its individual components. For example:
123 MAIN ST
For this example, it is clear you could just split on a space and have what I need. However, let’s say I have this:
123 N MAIN ST APT 2103
For this, I would need the address split like this:
123, N MAIN, ST APT 2103 (this is just how our query system needs it)
How would I go about doing this easily? I assume I would need some mechanism that knows all of the street types and somehow split by that, but can’t figure out how to implement it.