@Sri_devi wrote: For data values with blank Max and Min can be ignored. Rule in converting character to numeric. DO you mean to write a code to convert those. Can you please provide details on how to do it please. thanks!
No. You need to explain how you want the code to work. Then we can help you with the code. Since some of the values of MAX are not numbers you need to explain what number you want them converted into. And what the meaning of the extra characters that make them not actual numbers means. For example what is the difference in meaning between MAX='<5' and MAX='5' ? What does it mean in MAX is populated and MIN is not? What do you want to do with those non numeric values of VALUE?
... View more