Covert string to date, etc
Hi guys, just can't figure this out:
1. Suppose I have 100 rows of data, rows are such as:
"ABMAR99", "ABMAR02", "ABDEC03", etc.
How to convert for example, "ABMAR99" to the first wednesday
in March 1999, which is, "1999-03-03"?
2. Suppose other than rows like "ABMAR99", "ABMAR02", "ABDEC03", I also
have rows like "AB_MLTE", "ABMAR2C0",etc, and I only want to keep the
rows
in the format ("ABMAR99", "ABMAR02", "ABDEC03").
In other words:
(1) I only want to keep rows with the exact length of 7.
(2) For rows with the exact length of 7, I want to delete rows whose
third letter is "_".
Thanks a lot, appreciate your help!
|