data conversion - stripping data

[dsqspro]

answer for filed 2:

if Count(B, " cat") > 0 then Change(B, " cat","") else if Count(B, " dog") > 0 then Change(B, " dog","") else ''

answer for Field 3:

if Count(B, " cat") > 0 then 'cat' else if Count(B, " dog") > 0 then 'dog' else ''