I am at a loss here and would be grateful for any help:

I have a string variable "Other-specify." Several respondents provided text responses to this "Other-specify" variable (e.g., "farming"). I want to "move" the values of the "Other-specify" variable to existing categories of another variable "Industry," which is numeric (e.g., 1- Agriculture). I have tried this:

replace Industry = 1 if Otherspecify_TEXT=="farming"

but got the message "(0 real changes made)."

Not sure what I am doing wrong?

Any advice would be much appreciated!