I have a character date variable of format dd-MMM-yyyy in which some of the values are in the format -MMM-yyyy. i want to remove the first "-" only from these values. I tried using this code if length(date1) ne 11 then col1 = substr(date1,2,8);
else col1 = date1; But I couldn't get the desired result. The sample date values are as below.
... View more
