I've got a complex If/Then statement that may require the use of "Select Case". However I'm not familiar with how "Select Case" actually works. Needless to say, I'm not sure if you can use it within an "If/Then" statement. Here's what I need to do:
If row > 7 And IsNumeric(Microsoft.VisualBasic.Left(txtLine, 2))_ And (Microsoft.VisualBasic.Mid(txtLine, 18, 1)).Contains("G", "T", "C", "W") Then_ Go Do something constructive Else Go do something else End If.
To explain, I'm reading some specific characters from a line in a text file. In the second part, I'm reading one (1) character and need to determine if it is a "G, T, C or W". I suspect that "Select Case" may be the way to do this. Needless to say the above code is incorrect. Would there be a proper way to write this.
This line will actually be an "ElseIf" line as it is part of a bigger If/Then statement.
In advance, thanks for your help.