I need to copy part of a field to another field. For example, the field where I am going to copy from has the content "SAN PABLO CITY 4000." I only want to copy "4000." Other contents of the field where I am copying from has similar pattern such as "STA ROSA 4023", "NAGA 5400", etc. I just need to copy the number in that field and paste it in another field. So the one to be the pasted is the number only.
Appreciate any help.