Search A CSV File By An Input String And Return All Lines That It Is Found?
Dec 12, 2009
I was hoping someone could assist with the following coding; I am trying to search a very large csv file (approx 200,000 lines) for a user defined string eg "0100020789" and I essentially want to print all the lines that contain this to a text box on screen. Please not that the csv file does not have standardised column headings, each line is different. There would be approx 5 lines that contain the input string.
I am concerned with the v large csv i am using which will prob slow everything down, but then I thought if simple text pad application can search for a string in complete files with similar sizes like that and return a result in less than 1second, then it must be do-able.
View 1 Replies
ADVERTISEMENT
May 5, 2010
i want to search item A (from a list of X items) in list B but i want to get the item not found example Search ITEM A in LIST B if not found then return a print....if found continue with ITEM B..and so on.
View 11 Replies
Apr 2, 2010
I've got myself a CSV file with the following contents:
1,The Compact,1.8GHz,1024MB,160GB,440
2,The Medium,2.4GHz,1024MB,180GB,500
3,The Workhorse,2.4GHz,2048MB,220GB,650
It's a list of computer systems, basically, that the user can purchase.I need to read this file, line-by-line, into an array. Let's call this array csvline().The first line of the text file would stored in csvline(0). Line two would be stored in csvline(1). And so on. (I've started with zero because that's where VB starts its arrays). A drop-down list would then enable the user to select 1, 2 or 3 (or however many lines/systems are stored in the file). Upon selecting a number - say, 1 - csvline(0) would be displayed inside a textbox (textbox1, let's say). If 2 was selected, csvline(1) would be displayed, and so on.
It's not the formatting I need help with, though; that's the easy part. I just need someone to help teach me how to read a CSV file line-by-line, putting each line into a string array - csvlines(count) - then increment count by one so that the next line is read into another slot.So far, I've been able to paste the numbers of each system into an combobox:
Using csvfileparser As New Microsoft.VisualBasic.FileIO.TextFieldParser _
("F:folderprogramnameprogramnameinDebugsystems.csv")
Dim csvalue As String()[code]......
But this only selects individual values. I need to figure out how selecting one of these numbers in the combobox can trigger textbox1 to be appended with just that line (I can handle the formatting, using the string.format stuff). If I try to do this using csvalue = csvtranslator.ReadLine , I get the following error message:
"Error 1 Value of type 'String' cannot be converted to '1-dimensional array of String'."
If I then put it as an array, ie: csvalue() = csvtranslator.ReadLine , I then get a different error message:"Error 1 Number of indices is less than the number of dimensions of the indexed array."
Structure systemstructure
Dim number As Byte
Dim name As String[code]............
View 3 Replies
Jan 23, 2010
I'm trying to search for text that is known to be in a TextBox.
Once it is found, I want to return the line number it was found on.
Also, I would like to know how to delete all blank lines from a TextBox.
These two problems have been plaguing me for the last 2 days.
View 4 Replies
Mar 20, 2010
how can I search a textbox for a string within a string and if certain word (string) found enable a timer?
View 3 Replies
Jan 6, 2010
I know there is a function Contains that returns true if string has a certain substing in it. But is there a function that returns the count of instances of that substring inside another string.
View 6 Replies
May 6, 2010
i want to generate a serial key which depend on system harddisk manufacture id ...
so Is any function which take string of alfanumeric + special char as input and after encrypted return output as unique serial key / product key...
View 10 Replies
Jun 3, 2011
how to call two lines from VB Script and give the same in .bat file as input.
Here is my VB SCript code..
Set oShell = CreateObject( "WScript.Shell" )
Set ObjFSO= CreateObject("Scripting.FileSystemObject")
Str1="Version=3.1016.0.0"
[Code]....
View 9 Replies
Jul 1, 2009
I have lines in my text file like this:
x y
x Y
x y
x y
x y
x y
x y
x y
x y
x y
x y
x y
x y
x y
x y
x y
x y
x y
x y
x y
Lets say I have 20 lines like this. I want to change this lines according to user input. So user will input how many lines they want to change in terms of row and column. In my program
Row=TextBox5.Text column=TextBox6.text
User must enter initial value for x and y. Let say the initial value is
x=1 y=1.
Row=2 column=5..
Now my lines should look like this.
1 1
2 1
3 1
4 1
5 1
1 2
2 2
3 2
4 2
5 2
x y
x y
x y
x y
x y
x y
x y
x y
x y
x y
Since I enter row=2 only two set of lines is change other lines remain unchange. But in my coding all the lines is changing like this:
1 1
2 1
3 1
4 1
5 1
1 2
2 2
3 2
4 2
5 2
1 3
2 3
3 3
4 3
5 3
1 4
2 4
3 4
4 4
5 5
which is wrong.
This is my code
Dim lines() As String = IO.File.ReadAllLines("C:\wirematches.txt")
Dim xValue As Decimal = Val(TextBox1.Text)
Dim yValue As Decimal = Val(TextBox2.Text)
Dim altValue As Decimal = 2.54
Dim lineTracker As Integer = 0
[Code] .....
This code working fine for changes the column. But i dont know where i should write the code for row.
View 7 Replies
Jul 1, 2010
I have a folder with several textfiles. The only thing i need from the files is the last 10-15 lines from each file, printed into a new file. There is a sentence that is uniqe inside (but the same for all) at the line i want to start copying from.In other words i need to seach for a spesific word, copy everything from that line to the end of document, and print that to a new doc. Repeated for all files in the current folder.
View 10 Replies
Jun 11, 2011
How can I search, for example ID Number, and want to highlight the listview item found in search from my first form? I'm using combobox from my second form to search.
View 6 Replies
Jun 22, 2010
I'm trying to call an external .vb file class function, is it like dim a as ClassName=new ClassName()? so how do you do with this kind of.. I try to search for return value from .vbs to project that i will compiled, but none got the answer..#The reason why i'm doing this is for feature maintenance..
View 1 Replies
Jan 11, 2011
i need to read binary file and in this file found the string and replace it with other one and save the file afterwords. I found many example to read binary, but to find and replace is for me mistery.
View 3 Replies
Nov 29, 2008
I have a listbox which on form load generates correctly from a text file like so in a listbox...ex"John Doe, 1""Bob Brown,2"I now would like to search the listbox if it contains either a "1" or a "2" which is does in this case and copy the item to another listbox. The 1 and 2 indicate positions I have a position listbox for each position. So 3 listbos, first one contains the names on form load, 2 other empty listboxes one for position 1 other for position 2...I have tried the following
If xReservationListBox.SelectedIndex = xReservationListBox.FindString("1") Then
'MessageBox.Show("Found It")
xSpot1ListBox.Items.Add(xReservationListBox.Items(0))
[code].....
View 7 Replies
Oct 11, 2010
i need a vb8 code to open a txt file,search for a string in it & extract string in a excel file.
View 2 Replies
Aug 26, 2011
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]...
View 1 Replies
Mar 3, 2011
I would like the following function to return Nothing if the element with the specified key is not in the collection. Instead, it returns an error - something to the effect of "no element found"
Public Class MyCollection
Inherits System.Collections.ObjectModel.Collection(Of MyType)
Public Function FindByActivityKey(ByVal searchValue As Integer) As MyType
[code]....
View 1 Replies
Feb 26, 2009
I have a *.txt file which contains instructions and data, with its own comments (preceded by ! ), blank lines, and each instruction begining on a new line, but occassionally using two lines. Each instruction consists of several feilds seperated by a TAB. Finally each instruction ends in a comma. Only a few different instructions are there (10 different ones) but there are many of each. Spanning a good 2500 lines. Comments and blank lines are obviously of no interest to me. I merely need to read the instructions and the data that follows it.
Now, I have successfully used 'System.IO.StreamReader.ReadLine' to go through it line by line, picking out lines begining with certain strings (first 3 characters of a known instruction). All good, I can 'lift' out the lines of interest and store them, for them to be split up later (seperating their fields into instruction, data, etc..) and then into an array.
The problem is, since some of the data fields in these instructions are so long, it spans two lines, before it ends with a comma. Using the above method, I end up with two array entries for a single instruction, since I have stored individual lines rather than a complete instruction. The only similar situation I can tihnk of to explain this, is to pick out sentences in text, and store each one in a string. Of course these end with a period (full stop) but span two or more lines.
I am hesitant to post an example, since its formatting is rather strange, but it is generated that way from 3rd party software, so I cannot change that for my software application.Perhaps there is no 'graceful' way of doing this, meaning I would have to find a way of 'adding' the second line of the instruction, to the string of the first line. Or perhaps reading each line character by character, literally storing every number/letter until I reach a comma.
View 4 Replies
Feb 28, 2011
I have the following problem where in VS2005 VB I am returning all text in a text file to a rich textbox for preview purposes. Once I have returned this I am searching for a specific word (sv_hostname) and I need it to return a different result (Server name Here)on the same line to a text box. For example: Test file contains lots of lines where one of the lines would look like this within the text file.
set sv_hostname �Server Name Here�
I want textbox1 to only show Server Name Here The user must then be able to modify this and append this to the text file/rich textbox.
My Code so far:
vb.net
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim ServerName As String
[Code].....
View 5 Replies
Sep 30, 2008
I am trying to write a program that reads values from a datafile and makes the data available in an array for further use in the program. The data consist of a description and then a value (COM_PORT=COM1, for example). My idea is to put the data in an array so that I can just search the array for COM_PORT and I will get COM1 back. Is that a good approach of handling it this way? What methods would I use to put the data (I use FileSystem.ReadAllText, the data is in a string) into an array? Would the split method work?
View 2 Replies
Jan 5, 2010
I am trying to search an array and then say whether the result was found or not.
So far i have:
Option Explicit On
Module Module1
Const MaxAnimals = 20
[Code]....
Now i have looked online and all of them seem to give you like ready made things on VB but i have not used them yet and i know there is an easy way of doing it as my friend managed to do it before but i can't get hold of him.
Basically it is a program (There is more of it but this is not necessary for this) which puts the names of animals into an array then you can either add another animal, or in the sub i am doing at the moment view all the animals in the array but i can't work out how!
View 3 Replies
Dec 13, 2011
How to search foldernames (for example 'xerity') and zip found folders (for example 'zerxeritynar', 'hiun xerity natrer' ,etc.) with Visual Basic.NET?
View 1 Replies
Jun 2, 2009
This search button works fine, however, in the tooltip it shows "Record Found" as highlighted in the code below. What I want to do is to say how many records have been found. Lets say 2 records found it says "2 Records Found".
[Code]...
View 7 Replies
Aug 3, 2009
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]...
View 2 Replies
Oct 20, 2009
read lines in a file, split the lines and spit the result to another file
View 2 Replies
Jun 11, 2011
I can search for items in first listview column using FindItemWithText. I wonder is it possible to search in other listview columns and highlight found text, not all item line? My Listview contains multiple items and each item has 9 subitems. I would like to search in column 4.
[Code]
View 3 Replies
May 22, 2011
How to search and get position a string in a big file?I have searched in forum2 and get several ways to search for strings in files, but it is not for large files above 500 mb,I have just been make a function to search string and get its index,but it is very slow and uses lots of RAM.This is my function
Function StringInFile(ByRef fs As FileStream, ByRef
substring As String, Optional ByVal occurence As Integer = 1,_
Optional ByVal start As Integer = 0, Optional ByVal count As Integer = -1) As Integer
[code]....
View 10 Replies
Nov 4, 2009
I have a single text file and I need to search the file for any instance of the
string (Product_Type: "Hardware", "xxx", "xxx") the Product_Type is constant and has several instances within the file but the "Hardware" changes. I need to show all the values inside the quotes of the "Hardware" string to a listbox.
View 15 Replies
Jun 26, 2009
I'm creating a search application that needs to have a fuzzy search. Basically if there are 0 results, I need to provide a suggestion, much like google. For example, if I type "Californea", I need my program to suggest "California" after doing a query on my DB for similarity.
View 12 Replies
Sep 21, 2009
The format I need is a group of numbers in a text file and it looks like this and it will always look like this:xxxx x xxxxxxxx xxxxxxxxx x xxxxxxxxxxx xxxx x
The problem is that it can be anywhere in a text file so I cannot search by a particular line.
How can I search for this type of string format in a text file?
View 3 Replies
