How can I split a text field such as St. Address

I am dealing with specific way to work on an a text field with a “street address”

(if P.O or PO) next record else split the ‘stNumber’ from the ‘stName’.

I have used samples from microsoft and others.
Help!!!!