allredkj
New member
I am trying to extract the street type portion from an address string. Following is a sample of the data:
0000899 |
0001108W Division St |
0001231Colorado Ln |
0002112W Division St |
0001400Blue Danube St |
0000359Russell Ln |
0002313W Arkansas Ln # 111 |
0000615Stadium Dr These are the expected results after the formula is applied: (null row) St Ln St St Ln Ln Dr Your assistance is appreciated. Thanks, Kellu |