2,892 questions
Try something like this:
If File.ReadLines(txtFilePath).Any(Function(line) txtInput.TrimEnd.EndsWith(line.TrimEnd, StringComparison.CurrentCultureIgnoreCase)) Then
. . .
End If
How to Validate text box entry ends data from .txt file
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 54%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
Fairwinds
1
Reputation point
Newbie question:
I am new to using Visual Studio (I was decent with MS Access) and I'm trying to validate user entries into a textbox, and there are a number of conditions, but I'm only really struggling with the last part.
I need to ensure that the entry ends with any of the strings that are stored in a .txt file (which supervisors can edit at any time to keep up with future updates)
Can I compare against the file or do I need to somehow open it first? Do I need to store them in an array before I can compare against them? How do I write my code to use the file/array like a wildcard?
I assume the comparison part could look similar to this:
If (txtInput Like "*[<.txtfile>]" = True) Then
Developer technologies | VB
3 answers
Sort by: Most helpful
-
Viorel 122.6K Reputation points2021-08-10T19:57:02.9+00:00 -
Fairwinds 1 Reputation point
2021-08-10T21:13:32.957+00:00 That is almost exactly what I was missing. However I need it to only return a true result if the end of txtInput is the exact same as an entire line from the text file, and currently it will accept a portion of a line.
i.e. I need it to only take "supervisor", and not allow "ervis"
I can probably do more research on what you've given me and come up with what I need though. Thank you so much, you've helped immensely!
Sign in to comment -
-
Fairwinds 1 Reputation point
2021-08-10T23:04:49.843+00:00 Sadness. I was wrong. I am still getting stumped, and now I realize that it has to match exactly with the entire portion of the txtInput(user entry) that follows "00", which is another layer of complexity I wasn't expecting.
i.e. with LEAD in the text file, "...00LEAD" would be accepted, but "...00SLEAD", "...00LEADS", "...00EAD", and "..00LEA" would all fail.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 28.999999999999996%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXZ%3C/text%3E%3C/svg%3E)
Xingyu Zhao-MSFT 5,381 Reputation points2021-08-11T02:17:58.217+00:00 Hi @Fairwinds ,
with LEAD in the text file, "...00LEAD" would be accepted
You can splice 00 to LEAD directly, the code looks like
Dim line As String = "00" + txtInput 'LEADIf I have any misunderstanding, please provide more details here.
Sign in to comment -
-
Fairwinds 1 Reputation point
2021-08-11T05:00:45.413+00:00 I figured it out eventually, and I was thinking about it wrong. I needed to trim my entry data down to just the part I needed to compare, then treat each line in the text file as an .equals test against the trimmed entry as a whole.
-
Xingyu Zhao-MSFT 5,381 Reputation points
2021-08-26T02:26:37.66+00:00 Hi @Fairwinds ,
I'm glad your problem has been solved. Please click "Accept Answer" to your solution, so that it will help others find the answer quickly if they meet similar problems.
Sign in to comment -