I am try to import a text file read it's hex code search for a specific string and replace it with a different string. and write the changed file. I so far have a why to browse for the file on my form but not sure what to do from there.A
Public Class Form1
Public fdlg As OpenFileDialog = New OpenFileDialog()
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
[Code].....
I would like to be able to parse vb.net code files, so I can examine the collection of Subs, Functions (and their contents, including comments), private variables, etc. I can be open the actual source code files. So for example, if I have:
[Code]....
I barely know VB at all, but I managed to build an application with it, to import some text files into a database. So my problem that is left is that I need to install the application on the server and setup the scheduled task. I have the setup project built, but I can't figure out how to publish it so I can put it onto a CD. I am working in Visual Studio 2005.
View 1 Replieshow to best go about this project. I have just been given the task of creating a program that will primarily be used to import and sum a excel or text file that is tab delimited. As a quick example the file would be in the following format:[URL]The problem is that I would need to store this information locally (unless you know better) because I need to be able to append information to this from a second (or third, fourth, etc...) file and re-sum it, lets say that this is the second excel file that I needed to sum:
[URL]
I would have to append the week5 and week6 columns and add the Neapolitan row to my summation. This program will then format the sums into a list of the different flavors and the sums of all products sold during the total weeks and output to a text file.I have informed my employer that it would be easiest to do this with a VB script in excel, however, they are adamant that they want this done in VB.NET with a GUI.
I need to dump a bunch of delimited data to Excel. In VB6 days, I would save the data to a text file, then use ExcelApp.ActiveSheet.QueryTables.Add (blah blah blah...) to import the data to Excel (I got this code from recording a macro while manually importing a text file).In VB.NET (2005), QueryTables does not appear to be an option for ActiveSheet.I could take the long path and manually parse thru the data writing to individual cells - however if I could just import it, it would be much faster.Part of the issue is not being able to record a macro in Excel in .NET format.So my primary question is, how do I import a delimited text file in to Excel without having to manually parse the data into individual cells.Secondary question is any tips for not being able to have ready made examples (in VB .NET format) by recording a macro.
View 3 RepliesI've inherited a .NET app to support / enhance which reads in a couple of files of high hundreds of thousands of rows, and one of millions of row.The original developer left me code like :-
For Each ModelListRow As String In ModelListDataArray
If ModelListRow.Trim.Length = 0 Or ModelListRow.Contains(",") = False Then
GoTo SKIP_ROW
[code].....
and it takes an age (well, nearly half an hour) to import these files.
I'm busy with an applicaton which reads space delimited log files ranging from 5mb to 1gb+ in size, then stores this information to a MySQL database for later use when printing reports based upon the information contained in the files. The methods I've tried / found work but are very slow.
or is there a better way to handle very large text files?
I've tried using textfieldparser as follows:
Using parser As New TextFieldParser("C:logfiles estfile.txt")
parser.TextFieldType = FieldType.Delimited
parser.CommentTokens = New String() {"#"}
[Code].....
I am trying to import a bunch of excel 2003 files all with A:H columns and they are under the same headings etc. into a table in access 2003 database. This is a module in access im making. Im using a file search to look for every file that begins with Format (which they all do ) to get at all the files in the folder path. is there a more efficient way to do this? somehow select all files in a folder? and import each to the same table in access? The DoCmd.TransferSpreadsheet seeems to take each file path individually so I'm not sure how to get each file name in the folder to import it.
I have this at the moment:
Sub Import()
Dim db As Database
Set db = CurrentDb
[Code].....
How can I change my code # to Code & in All the text files within a folder
View 10 Replies"How to import or put Microsoft 3d Movie maker in VB 2008?"
I have searched in internet but got none.. I also tried to but I don't get it.
We use a program, called CFPS (a flight planning program) and it creates different flights. I can export this file to a CRD-type. When I open it in Wordpad or something, it looks very familiar to a XML-file ("<item></item>...")...but I don't find a way to read it. What is the best way to handle this problem? It would be time saving if I can import these files directly in my program.
View 1 RepliesI am building a small Windows Forms application. I need to 'read in' CSv files into the application.
I am using StreamReader to read the CSV files into the application. That is no problem. On my Form I have a text box, 3 Buttons and 2 data grids. With the first 'browse' Button I am using OpenFileDialog to select which CSV file I want to display in the first grid.
Then I want to use a 'convert' button to display the information from the CSV file in a much more 'user-friendly' manner in the second grid. Lastly I want to use my 'export' button to export the converted file to excel.
I am working on a vb.net Windows Forms application.I want the application to import Visual Studio Solution files from versions 2005 & 2008 (elsewhere on my Hard Disk).I am using Visual Studio 2010. I want the applicaton to find the files entitled - 'Microsoft Visual Studio Solution File, Format Version 11.00 # Visual Studio 2010.' Thyese are the files I need. I aso know that it will find files - 'Microsoft Visual Studio Solution File, Format Version 9.00 # Visual Studio 2005'.Under is my code thus far. Maybe someone can give me some advice as how to make sure that the applications returns the correct Sln files?
Imports
System
Imports
System.IO
[code].....
what would be the best way to parse a PST file for message info on messages and embedded messages/attachments?
View 5 Repliesi want a code for compare between 2 text files A.txt and B.txt all record in file B.txt includes in file A.txt but with different value.the digits with color red are accounts and the digits with color blue are values.i want to compare between A.txt and B.txt based on accounts,when find the accounts from B.txt in A.txt copy the full record for these accounts from A.txt and print it in new file C.txt
===============================================
File A.txt:
ABC20100317201000000 -----> Header
D1503320006980000000
D1629040003540000000
[code]....
I want to make a database of my media collection for my application. I want to create a library for that. Now what i want is that user should be able to add his own song to the database. How can i access mp3 files metadata in my database? How to update that database using my application.
PS: My application is a media player made in Visual Basic using Visual Studio?
I am writing an application where data can be gathered from many different places and graphed against other data. However the data from all the different places is coming in different formats such as .csv, .txt and some others i can't recall right now.So i am wondering what is the easiest way to allow my program to import the data supplied in these different formats?
View 4 RepliesI need to be able to select a title from a listbox (lstBooks) and I need the data from a comma delimited text file (books.txt) to flow into a form (frmDetails)when I click the UpdateToolStripMenu button. Program is attached.
Attached File(s)
Test.zip (100.45K)
Number of downloads: 7
I always make back ups of my projects in case I'll really really mess up on the way and want to go back to more stable version. I've tried running one of my back ups few days ago and ended up with importing pfx key canceled. What exactly is pfx key? And what do I do to have my code compiled?
View 2 RepliesI have a text file containing ten pieces of information (5 prices and 5 descriptions) I want to load the information from the text file in to the text boxes, so that it can be viewed and edited if required.
I've declared the filename, and various variables, but I'm not sure how to get the info from the file to my form?
filename = CurDir() & "/charges.txt"
Could I use something like this:
fileopen(1, filename, openmode.append)
do while not EOF(1)
...
...
Have been struggling with parsing XML as there seems so many options. My XML string is formatted as follows
<mysite>
<request>
<type>login</apiType
[code]......
i am having problems trying to code this application, here is the assignment: Amusing Toys, Inc. wants to store the description and the number of items on hand of its toys in a sequential access file named stock.txt. The company's sales manager wants an application that lets the user enter the descriptions and the inventory in tow list boxes. Then he also wants to retrieve the file so it is possible display the inventory of a toy whose description he selects from a list box. The List box with the description should appear as soon as the application is loaded. Create an application which: initially adds the information to list boxes so the information can be checked, places the data in one or two arrays, saves the information for retrieval later, contains test data for at least 10 items.here is what i have so far i cant get the information to line up correctly in the list box from the text file and also i have no idea on how to get the quantity to show up after i get it to line up correctly i think i need an array.
Public Class MainForm
Private Sub addItemButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles addItemButton.Click
Dim heading As String = "Department" & Strings.Space(2) & "OnHand"
Dim description As String = String.Empty
[code]....
Parsing HTML in code? Content removed.
View 7 RepliesWhich parsers are available for parsing Vb code?
I'm looking for a Vb parser that can be used in Vb and give me access to line and file informations about each artefact of the analysed code.
I'm trying to get a local HTML file to display within a WebBrowser in a VB.NET program. I'm using the code below, however it doesn't seem to work, and I can't figure out why:[code]The first method produces the error "" in the Debug console when I go to run it. If I try it with out the @, I get an empty white page. If I change the address, however ,so I know its a broken URL, I get a 404 message, which makes it seem like it's finding the file but not rendering it?The second method does the same as the first except no error is produced, its like its finding the text but doing nothing.
View 1 RepliesI have a WebBrowser control on a form and pass HTML code to it to "preview". This works fine in development on a Win XP machine but on the target machine with Win 2K it just shows the HTML code in the control and doesn't parse it.
[Code]...
I need code for the function filesystemobject which gets the text files from a folder when searched for.
View 1 RepliesI'll be able to get some advice and help with regards to my question. Basically I am trying to achieve the task of downloading source code from a website say forum then using a simple parser technique remove the metadata from the uploaded data and store it into the database.
I know how to download information from a website by using the following code
[Code]...
I am working on a program for the Windows Mobile 6.0 system and using Visual Basic 08.I would like for the current txt file that I have, that is formatted as follows: "NOR400","277225","ZIMA 4/6 12OZ NR BOTTLES","07199077603",21.65,"cs",7.19,"pk","C4/6PK","12 OZ " to be imported and each item in the line will be assigned to its own txt box. I have been able to load up the file, in to one txt box, but am unable to separate the items in to their own box. Should I be using arrays for this?
View 6 RepliesTrying to get some VB practice after a long time rest, but I'm having some issues even getting a new solution open. Ok, I have VB '08 Express on Vista (Visual Studio also installed) and whenever I try to create a new solution I get the following error:[code]Now I've checked the forums and seen that this error has come up a fair bit, but I've tried the couple of suggestions I have seen to no avail.
View 7 Replies