I have several fields in my file which contain both numeric and null/empty values. These fields are initially string and I would like to convert them to numeric, changing the null/empty values to zero. I have tried replace and isnull function but can't seem to get anything to work. Any advice?
Please sign in to leave a comment.