Reg. Expression to replace a list of names with a single character.
I have a column that is in a string format, and of course contains names. Majority of the rows are an empty string. What I am looking for is to take the rows that do contain a name and replace them with a 1.
i have been trying to use replace text tile then trying to use a regular expression in the 2nd step, then replace found term with a 1. I am not sure of a reg. ex. that would identify all the different names.