I have the value "N/A" that is applied to any field that doesn't have an entry. I need to change this to a numerical value in order to do my charting. How would I accomplish this? 'fillnull' would almost do it if it would accept the value (N/A) I'm looking for.
Thanks, Mike
EDIT: Better idea.
Use the Replace function to replace the string "N/A" with whatever numerical value you desire in whatever fields you want. Far more efficient than my original suggestion.
EDIT: Better idea.
Use the Replace function to replace the string "N/A" with whatever numerical value you desire in whatever fields you want. Far more efficient than my original suggestion.