I am importing text files and then delete unwanted rows.
I only want to keep rows where the value in column A is:
94816 (any combination of 5 numbers)
VO219MX41100 (length 12, 2 letters, 3 numbers, 2 letters, 5 numbers)
The lines to be deleted can be blank, unprintable chars, words.
Can somebody please help with code to do the cleanup?
I only want to keep rows where the value in column A is:
94816 (any combination of 5 numbers)
VO219MX41100 (length 12, 2 letters, 3 numbers, 2 letters, 5 numbers)
The lines to be deleted can be blank, unprintable chars, words.
Can somebody please help with code to do the cleanup?