Replacing empty string cells with specific value

Question

as you can see I have a database in SPSS and I encountered a problem where one of the columns has empty cells. Now the problem is that the type of data in that column is string. If it was numeric/integer there are tons of videos showing how to do it but none for string cells. I want to fill the empty string cells with the word "null" or "none" but I can't find a way to do it. Help!

Answer 1

You can use the following syntax:

IF V13 = '' V13 = 'Null'.
EXECUTE.

This syntax translates to something like: "If V13 is blank, make V13 equal to the string value 'Null'.