I have a field (called cateid) which contain the record eg. "ABCDF31211 PRDIT : 1212111221"

How to trancate from this field starting from PRDIT onward til the end of record to another field (called prodid)
I am trying to convert data from excel file to fox's table.

Sorry for my english,Coding will be appreciated. thanks