Best Way To Proceed With Searching A File Content
May 28, 2009
I need some guidance on the best way to proceed with searching a file content.I have a large file (see attachment) that is in text form, some of these files could be upto 50 times as big, therefore creating a huge file.These files contain information that is produced from another application and therefore I am unable to change the format of the file.This file contains information that I want the user to be able to be able to enter search criteria in a form that then searches this file and returns information. The individual information is split into sections of data and this is defined by the section start label lbl{ and the end label }} Therefore the below information highlighted in bold is an individual section
lbl{-32768 21 12 0 text {Equip no: P-102BDescr 1: RECYCLE PUMP-BDescr 2:}}lbl{-32768 21 28 0 text {Equip no: D-100Descr 1: COLUMN RECIEVERDescr 2:}}Now comes the hard bit, in the bold section above you will notice that there is some text Equip no: P-102B I want the user to be able to enter in a form *102B* and for it to return -32768 21 12 0 which is after lbl{ and before text.Now obviously I could loop through the whole file to do this, however I am very concerned about RAM usage and also the time it will take to do this. Obviously the user could use this search option over and over again and therefore we would be searching the same file over and over again. One of my thoughts was to read the file once and output the content in an Access Database table and then use SQL to get the information? However would the user require Access on there machine to be able to do create the database or could I just ship a blank Access database with my app and then copy this and populate? Also I am not sure if Access is the best database, obviously I don't want people to have to use Oracle of SQL as this would require server configuration etc. but are there better free databases out there?
View 5 Replies
ADVERTISEMENT
May 28, 2009
I need some guidance on the best way to proceed with searching a file content. I have a large file (see attachment) that is in text form, some of these files could be upto 50 times as big, therefore creating a huge file. These files contain information that is produced from another application and therefore I am unable to change the format of the file.
This file contains information that I want the user to be able to be able to enter search criteria in a form that then searches this file and returns information. The individual information is split into sections of data and this is defined by the section start label lbl{ and the end label }} Therefore the below information highlighted in bold is an individual section
CODE:
Now comes the hard bit, in the bold section above you will notice that there is some text Equip no: P-102B I want the user to be able to enter in a form *102B* and for it to return -32768 21 12 0 which is after lbl{ and before text
Now obviously I could loop through the whole file to do this, however I am very concerned about RAM usage and also the time it will take to do this. Obviously the user could use this search option over and over again and therefore we would be searching the same file over and over again.
What I am wondering is if anyone has an idea on how best to do this?
One of my thoughts was to read the file once and output the content in an Access Database table and then use SQL to get the information? However would the user require Access on there machine to be able to do create the database or could I just ship a blank Access database with my app and then copy this and populate? Also I am not sure if Access is the best database, obviously I don't want people to have to use Oracle of SQL as this would require server configuration etc. but are there better free databases out there?
View 2 Replies
Apr 14, 2010
I am beginner in programming and developed an application of mine. Although, I am finished with the coding part, but I have to present my software architecture diagram. I am not a software engineer and so familiar with basics of software engineering, layering etc.I have used 1) .NET GDI Graphics in my application, 2) Text to Speech, 3) RichTextBox which retireives pictures etc. How do I proceed with the architecture diagram now?
View 1 Replies
Mar 6, 2009
I am suppose to do a VB form where it can be able to read, add, update and delete citectSCADA variables from access .But after entering the following code into my add button. my form jus hang.i tried F11. But still it didnt tell me the problem about it.VB
[Code]...
View 11 Replies
Jun 27, 2012
I am doing a Quiz form on VB.net . How to proceed on to the second question using the same form . I have linked the database to it so now my form1 is the first question . I need to save the answer and proceed to the second question using that same form
View 1 Replies
May 22, 2012
I need to open an excel file from vb.net and then search it for specific data. I then need to take those data and insert them into text boxes on a form that i have created. This is all controlled by a button click. I already have some code that will open a file dialog box and let me navigate to the correct file, but I am having trouble with the search portion. I have tried the Find function but I am not sure of the proper syntax. I am using Visual Studio 2008 and Excel 2003.
[Code]...
View 7 Replies
May 18, 2009
i'm working on a simple drop down button. all the stuff i tried with context strips ended up misplacing the menu in all the wrong places, so i'm doing a dropdown button with a combobox and a button placed infront of the combobox but not the comboboxes arrow click. what i would like, is to click on a item in the combobox and proceed with command, instead of having to click a go button or such..
also, is it possible to fully customize a combobox? trujade..so much work to do and so many choices to choose from...
View 3 Replies
Dec 1, 2010
I am new to vb .net and I have been writing simple programs in VB4(16 bit) and now I have to convert a particular program to VB .Net. I have never really used the Crystal report in vb to write my reports and I am really lost as to how to proceed with converting the following module to .net equivalence.
[Code]...
View 1 Replies
May 21, 2009
how do i have my app read a line from a textfile and if that line equals "whatever" proceed with command, this case a msgbox.so much work to do and so many choices to choose from...
View 3 Replies
May 1, 2011
Im trying to get a list of all the text files present (there file paths) in a certain folder (lets say C:\Users\podypodpod\Desktop\textfiles) and then add them to the list box (lb_Entrys)
ive manage to find this code to get all text files from the desktop , but i cant manage to edit it so i can give an actual filepath for it to search
CODE:
View 2 Replies
May 31, 2011
I don't know whether it is simple or not because i am new to programming. my requirement is : In my vb.net winform application, the filenames of the files present in "D:Project" willbe displayed in DataGridView1 control. Now I want to load these files one after another into memory stream buffer and add the headers("ID","Name","Class") to the content in the file. Then I want to save these files in "C:" with "_de" as suufix to the filename i.e.,sample_de.csv.
View 1 Replies
Feb 18, 2011
I have to generate an XML file from several database tables. I could use the WriteXml method of the DataSet to do it, but the database tables are really huge and I can't add all those tables in the DataSet at the same time or it may cause a problem because of the big amount of memory used. Then I decided to use the DataTable's WriteXml method and save table after table, but the the generated file only stores the information of the last DataTable.WriteXml's call. How can I preserve the previous XML data when adding all that information?
View 4 Replies
Dec 16, 2010
I cannot read filename in response header:Content-Disposition: inline; filename="
View 6 Replies
Mar 3, 2012
I have a textbox on a form that is set to allow dragdrop operations from txt files.Basically you drag a .txt file onto the txtbox, the content of the text file is displayed in the textbox.All is working fine, however after the textfile is displayed in the textbox, the text box text is for some reason is highlighted.I don't want the text to be highlighted (or selected) after it's being displayed on the textbox.Second issue, after I close the file that I dragged, for some reason even if I didn't make any changes to the file, it is acting as if the file has changed.In another words, if I open a text file using my MenuItem Open item, and if I do not change the file, If I close the file it's fine it closes.However, if I close a file that I draged into the text box and then close the file without changing anything in it, the stringcompare function is telling me that the file has changed... I can't understand why.
View 6 Replies
Dec 17, 2008
What i am trying to do now is to show the content of the dnsredir.ini file on the forms and able to edit it.
The dnsredir.ini file file looks like this
;Configuration INI file for DNS Redirector v6.4.7
Logging=Normal
ListenOnIP=172.23.128.33
[Code]......
View 1 Replies
Jun 3, 2009
i have a checkbox, when checked, contextmenu shows and remains visible until unchecked.. then i ran into a problem.. if i click any other control on my form, the context menu disappears and the checkbox remains checked. i have tried placing
[Code]...
View 5 Replies
May 19, 2009
i'm having a little trouble with a listbox. [Code]. i want the button command to run through the listbox items and proceed with given command. it's not listbox1.items.indexof(#), it's something else i'm missing.
View 2 Replies
May 22, 2009
Try
Dim s As New IO.StreamReader("C: est.txt")
For i As Integer = 1 To 4
s.ReadLine()
[code]....
this only reads one line and proceeds with command.. how can i fix this to be able to read multiple lines, like read line 7, do command, read line 9, do command, etc..so much work to do and so many choices to choose from...
View 4 Replies
Aug 21, 2011
I'm trying to do some simple XML manipulation by searching one XML file for a set of nodes and inserting them into another XML file at a specific location.I'm able to succesfully create a node list from one of the files using the following xpath statement [code].....
I'm struggling to see how I can easily select any node I want within the first XML file but the second file refuses to play ball! I've attached the second XML file should anyone wish to check that I've interpreted the structure correctly.
View 3 Replies
Dec 30, 2010
I have a sample app here I could use a hand with Basically I'm trying to update the TextBlock on the main page using MVVM when the content the frame updates the the property. Please find the code attached below:[URL]..How do i get the button inside the frame to change the variable and update the TextBlock on the parent control?
View 1 Replies
Jun 20, 2009
loop through a textbox control content and extract specific content from it
View 20 Replies
Feb 25, 2010
i would want to make an application that searches a file in a network.
View 1 Replies
Jul 30, 2011
[code].....
View 9 Replies
May 28, 2011
I'm trying to make a script that searches for multiple .TXT files in a directory, and then searches the text of each file for a matching string(ie. "turtles"). It will search each file for the word "turtles". I've been on google trying to figure this out for a while, I'm guessing StreamReader is the way to go?
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim l_Dir As IO.DirectoryInfo
l_Dir = New IO.DirectoryInfo(MyPath)
[code]....
View 3 Replies
Aug 28, 2010
I How can I search a specific file using vb.net and store the path in a variable? For example if I need to know where I have *.abc files in my entire computer, how can this be done?
View 5 Replies
Aug 26, 2011
This is an veriation on a previos thread of mine (les complicated I think)
All .png Image Files in a Folder is named as 6 diget numbers.
Forinstance a "2" wil apear as "000002"
"22" as "000022"
"42" as 000042"
Can this files be searched by numeric value insted of a string?
So if I then searced fot the value of 2 I will get file named 000002 and not file named 000042 or 000022
View 3 Replies
Oct 29, 2011
I have been searching all over the forum and internet, but seems to have a hard time finding some help on how to search for a file at unknown location.
The reason is that, I made an easy form that helps some friends of mine find around a website more quickly.
Now this is what I want.
They have a game installed on the computer, and I want my program to search for this file and execute it afterwords.
F.eks
I have 4 HD's and WOW is on the 3rd. I want this software to search all the HD's to search for Wow.exe.
View 2 Replies
Aug 18, 2009
I have some code that does what I need it to do, But I am going to have make changes to accommodate the user request. Basically the program searches a folder for a paint code, ex. 351X035. When the code is found it displays a link so the user can click it to open up a PDF. The way I have it setup now is that they have to know the exact paint code for it to pull the link to the file. I need to search to find the file(s) with less than the exact code.
Imports System
Imports System.Drawing
Imports System.Windows.Forms
[Code].....
View 1 Replies
Sep 7, 2011
in vba i would use vlookup on an excel table. How do you search a text file in vb.net that is formatted like this
ES,2
C,3
EC,4
I want to search for the two letter string and retrieve the integer that follows the comma
View 3 Replies
Nov 25, 2010
1)This is my code.. (below)what i am trying to do here is to insert username and confirmed password into a sql table called login via a pre created form.I have 1 textbox, 2 Maskedtextboxes and a button.
what i would like is if the passwords do not match in both maskedtextboxes for the system to throw out a message saying passwords do not match please try again..which then clears previous content and requires the user to enter details again. once details are correct and system commits the new user details to the table and throws up a confirmation message.
[Code]...
View 1 Replies