I'm looking for a way to delete lines that don't meet a criteria in VB.net. I'll just give a example of what I want done below.
Basically, I want the program to go through a text document (Each line) and if the line doesn't contain a certain string it would get erased.
how to highlight a row when it meet certain criteria??
my sql statement is slightly like this:
sql = "SELECT * FROM Product WHERE Quantity<= minOrder"
then i need to highlight the row item which the quantity reach to the minimum order.
Ok so basically heres what i need to do: Extract text from the webpage that meets a certain criteria. There will be a ton of these on 1 page and i would like to add them to a rich textbox on sperate lines.
I know that it needs to be in a loop and its needs to Parse the wepage(Dim web1 As String = Me.WebBrowser1.Document.Body.InnerText)
The criteria is: Starts with 1 to 4(random) integers, Followed by "my" then 13(random) numbers and letters. Or if it starts with "167my" + 6(random) number and letters.
Edit: Also im going to try to make it loop through a list of webpages to do this.
I am working on a utility to reformat a text file. Working on language to remove duplicate record entries. However there are desirable ("keeper") duplicates and then those I want to remove. I handled the problem by temporarily assigning a unique number to each @D line, then stripping them off after I've removed duplicates. So far so good, except in removing unwanted duplicates I have an extra of the "keeper" duplicates left that doesn't get removed. See below. I am wondering if there is a way to search for a line in a textbox starting with a certain character, but is also proceeded by 2 blank lines and followed by 1 blank line. CODE IM USING TO REMOVE DUPS yet keep formatting with blank line separators, etc.:
[Code]...
Is there anyway way to delete those rows not matching certain criteria?For example, required rows in Column A - always have either xxxxx-x formatted Account# or Date or word begins with "Total :" anything other then this- those rows are not useful and i want to automatically delete all those unwanted rows.Delete the the rows which has value other then xxxxx-x formatted account# or date or word "Total :"[Account# could be xxxxx-x or xxxx-x or xxx-x or xx-x or x-x means 5digit-1digit or 4digit-1digit or 3digit-1digit or 2digit-1digit or 1digit-1digit.[code]
View 5 RepliesIs there anyway way to delete those rows not matching certain criteria? For example, required rows in Column A - always have either xxxxx-x formatted Account# or Date or word begins with "Total :" anything other then this- those rows are not useful and i want to automatically delete all those unwanted rows. Delete the the rows which has value other then xxxxx-x formatted account# or date or word "Total :"
[Account# could be xxxxx-x or xxxx-x or xxx-x or xx-x or x-x means 5digit-1digit or 4digit-1digit or 3digit-1digit or 2digit-1digit or 1digit-1digit
====INPUT====
Column A
56981-3
1459-3
10/25/2010
69655-9
Apple
Orange
Total:
01/02/2009
Paint1
987-1
Yellow
Total:
====OUTPUT===
Column A
56981-3
1459-3
10/25/2010
69655-9
Total:
01/02/2009
987-1
Total:
I have database with table called "Konzultacije" with field "Vrijeme" (Date/Time). I have datagridview (DGKonzultacije) with columns. Column (1) data format is set to date/time. I want to delete record from "Konzultacije" table depending on selected cell in datagridview but only I can get is error.
This is my code:
Dim iSql As String = "DELETE FROM Konzultacije WHERE Vrijeme = " & DGKonzultacije.CurrentRow.Cells(1).Value
conn.Open()
[CODE]...
If i add apostrophe like this:
Dim iSql As String = "DELETE FROM Konzultacije WHERE Vrijeme = '" & DGKonzultacije.CurrentRow.Cells(1).Value & "'"
error is raised: Data type mismatch in criteria expression.
i have lines like this in my text files.
2.0 28 Blue (2 14.00 63.0) [2 12.43 54.3] 42111 9275 55111 -1725
2.0 28 Blue (2 14.00 64.0) [2 13.50 55.3] 40611 9275 53611 5775
2.0 28 Blue (2 14.00 58.0) [2 12.21 54.3] 49611 9275 55111 -3225
5.5 28 Blue (2 20.00 17.0) [2 13.50 26.3] 111111 51275 97111 5775
[code]....
This are some of lines in my text file.they are duplicate lines in the tex file. I want to delete the duplicate lines because i only want the lines which have [T1],[T2....]... i higlight all the matching lines.
I am writing a click event to delete an item selected from a list view which will utlimately be deleted from the csv file the information is coming from.Currently I am having streamreader read each line and then replace the selected line with a blank line. This creates blank lines in my csv files. Is there a way to delete a line using sr or sw without creating blank lines?Or is there a way to have them read/write a file skipping any empty lines?
My
If ListView1.SelectedItems.Count = 0 Then
MessageBox.Show("Please select a class from the upcoming schedule list.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
Else
[code]....
I want Split @ and " " and Chr(13) From RichTextBox? How do I delete the spaces and lines and @ From RichTextBox?
View 4 RepliesI have a RichTextBox.
I want to input an integer and the RichTextBox to go to that line and delete all lines above it.
For example, if I have 100 lines in the RTB, and I specify "25" as the integer, I want lines 1-25 deleted and for the RTB to keep 26-100.
i have a code that reads text from a source and put the source into a textbox. But i want to delete line 7 and 6 auto. How do i do that?
View 6 RepliesI have a textbox that reads like so:
Line 1
Line 2
Line 3
[code]....
How can I use VB to loop through the textbox, deleting Lines 1, 2, and 3, skipping the fourth, and repeat? Or, rather, record every fourth line into a new textarea?
Using this [URL] to retrieve both address and place name at the same time ("//span[@class='listingTitle']|//div[@class='address']/text()[normalize-space(.)]"), I can get a list of placenames and addresses like this in a richtextbox:
jh ryder machinery limited
convenience storage ltd 3344 rideau
rd, gloucester, on, k1g3n4
kitchen interiors 146 colonnade rd,
nepean, on, k2e7y1
The first line is bad, it doesnt have an address. Line 2 and 4 are good, they have addresses. So what I could do is:Check each line,if the following line doesnt contain "numbers + ON" then delete line. This will leave me with PlaceNames followed by addresses, which I will then split every other line into a new textbox, (so I have one textbox with placenames, and another with addresses).
remove line from text file?
View 6 Repliesive been searching the whols google, and i couldnt find a ny solution.. i was wondering if someone here can help me out, i am loading a listbox items from a .txt files, and sometimes there are empty lines, there is a way i can delete them?
View 10 RepliesI am trying to do a blinking cell with red and yellow text in my data grid view. The cell may blink when certain condition meet.May I know how should I write the VB script in VB2008?
View 3 Repliesi want to delete an item on a listview, this is my code
If ListView1.SelectedItems.Count > 0 AndAlso MessageBox.Show("Do you want to delete this item?", "Confirm", MessageBoxButtons.YesNo) = Windows.Forms.DialogResult.Yes Then 'make sure there is a selected item to delete
ListView1.SelectedItems(0).Remove()
End If
now my problem is i want to delete that item on the text file line
( using streamreader and streamwriter)
I've seen posts on deleting the lines from a text file that are specified as a function parameter, but I only need to delete the first and last lines from the file.
I'm still a newbie when it comes to working in files, but it seems that it should be simple to delete the first line... Just delete all text from BOF to the first CrLf character. Am I right?
As for the last line, I understand that I'll have to get a count of the lines in the text file to find it (as the file won't always be x amount of lines long).
i want to delete few lines from a big text file , normally this lines are at the starting of the text file , so it is possible that i can enter the line no from input box and the vb.net can delete that particular line number from the text file ,
[Code]...
I have a text file containing lines of data (File 1). I need to delete all the lines in another text file (File 2), which are found in file 1.So I could read file 2 line by line. And then once the line has been read, read file 1 line by line to search for a match. But that's going to be painfully slow.Or I could read file 2 into memory. And then read file 1 line by line and REPLACE the lines in file 2 with nothing, therefore deleting them. File 2 could be 100 mb, so I'm not sure about reading it all into memory.
View 16 RepliesHow can be find out which file is going to delete when, user provides command like DELETE or SHIFT + DELETE or by programmatically gives DELETE command. Well I know about FileSystemWatcher Class, but this class doesn't provide information before delete...
View 1 Replieshow to count the lines in textbox1.text (with multiplelines). I don't need to count each character. I only need to count each line from top to bottom in textbox1.text (multiplelines) and I will use Label1 to display the numbers.
example:
1-pauljaones
2-tommyperrry
3-marktoms
4-Jonessmith
5-paulwhite
Obviously this is 5 lines and that's what I need to count.
I have written a simple script to get a bunch of lines from a text file (they will be filenames eventually) which are split by new lines and puts each one into an array..
Dim ary() As String
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If My.Computer.FileSystem.FileExists("C:MenuFiles.txt") Then
[code]....
The only thing I can do for now is either use the substring function to remove the first character from all array values after 0 but I don't like that because it's messy and what if the split "works" as I want it to one one of the lines and knocks of the first character when I don't want it to.
below are a few lines from my text file(10929 lines)I need to read each line and insert into MS Access. each line is a column in my table and the record changes on every 8th line or to be more specific(on every 8th line you will see a number [1,2,3,4,5,6,7,8,9.....] this is where another record starts,
[Code]...
I want to draw string in multiple lines and and I want to know how many lines given string will take. I am using following method.
[Code]...
I am trying to make a script to spit command lines to a bat file to compress a bunch of files singly and then delete the original ones. I am sure that is easy to most of you, but I living a ____ trying to do this. A have a file list like this one belo, which was created with a command -- Dir /b /s /a-D N: > filelist.txt
[Code]...
read lines in a file, split the lines and spit the result to another file
View 2 RepliesI want code to check the criteria of a password. The password should contain at least one numeric digit and at least one alphabetic character.
View 5 RepliesI have a generic list of items and need to remove some of these items according to some criteria. I could do this like that:
MyList.RemoveAll(Function(s) s = xxx)