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 ...
I've brought in a fixed format file and many columns have leading zeros. Some should be string and some should be converted to numeric format. How can I selectively assign data types by column?