I am wanting to write an application which opens a delimited text file (either comma, pipe, colon, semi colon) and displays the file on the form. The same feature is in Excel when you import a data file. After selecting the file it shows the contents and you can choose the delimiter. Once the delimiter is chosen the data shown reflects this and updates to show the correctly formatted data.
View 5 RepliesI'm trying to use VB.NET to parse a very large plain text file (2 GB). It is a database and has a field delimiter of SOH and a record delimiter of STX. I want to separate the fields and records of the file.
I would normally read each line of a text file and then use the split function to separate out the fields. I can't use this approach as there isn't always a delimiter on every line.
Is there any way to read a file until STX is found (rather than one line at a time)?
Alright, im trying to load a text file into a list box using a delimiter(sp?)I have 2 list box's lstFirstName and LstLastName I have the code to load it into a list box
r = New IO.StreamReader("c:\test.txt")
While (r.Peek() > -1)
lstFirstName.Items.Add(r.ReadLine)
End While
r.Close()
And at the moment this will just load the whole list box, how can I use a delimiter to split it up?So John Doe in the text pad will show up as lstFirstName: John lstLastName: Doe Sorry if im not all that clear, if you dont understand I will try to explain it clearer.
How can I change the delimiter when writing my Access table to a text file? I was hoping it would be as easy as adding a similar option like we do for HDR=No; maybe Delimiter=|
Dim AccessConn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|mydatabase.mdb")
AccessConn.Open()Dim AccessCommand As New System.Data.OleDb.OleDbCommand("SELECT * INTO[Text;HDR=No;DATABASE=" & userPath & "].[" & fileName & "] FROM tblMyTable", AccessConn)
AccessCommand.ExecuteNonQuery()
AccessConn.Close()
I'm working with VB.Net. I have imported some data into the Data Set.I have four columns of data.
[Column 1]This is a test[/Column 1]
[Column 2]This is a comma, Test.[/Column 2]
[Column 3]This is a double quote " test.[/Column 3]
[code].....
I want to read a text file with unlike delimters into a collection.This is what the file looks like:
_Item 4916 0.00 781.21
_Item 2831 0.02 842.25
there are 10029 items and i am trying to get each items description into 3 different collections: Item "names" (first column), Item "weights"(second column), and Item "values"(third column).the delimiters are as follows:
______(3 spaces)____(1 space)____
considering the amount of items in the file, it would be a complete waste of time to edit it.
I am trying to write code that will open a file with the input from a combobox from the user. My code is below:
[Code]...
I have a csv file which I am populating to a datagridview. I am delimiting it using "," and "space". My csv file has "," at first instance and "space" in next two instances. I want to delimit the first instance using "," and the second instance using "space" and the third instance though has "space" I wanna ignore that space.
My CSV file :
HTML
jarnvagstag,Mantel,Mantel1,Mantel2
100tag,01/01/1750 11:45:32 PM
200tag,01/02/1750 12:57:57 AM
[Code].....
I've made a rudimentary program that combines multiple files into one single file. Currently if I combine two .csv files together the output comes out correctly for what I need, which is a coma delimited file. When I try to combine two .csv files into a .xls file it doesn't format correctly (I get all the data separated by commas, but thrown into one column in the .xls file). For this reason I believe I need to add a delimiter.I'll post my code below.
[Code]...
I have the following line of code used to input the name of a text file to be opened and during development this was working without a problem. However when I create an executable this is not working and I was hoping someone would be able to give me a tip on resolving this matter.
Dim fileName As String = Application.StartupPath & "" & TextBox1.Text
I am using a thread to call a process which is spliting a text file into various text file and folder using the system.io , now when calling the Textsplit() with thread on click of a button i am getting the error below , how to use thread and why this error occurs.
Cross-thread operation not valid: Control 'txtbox_destn' accessed from a thread other than the thread it was created on.
I am trying to figure out how to read a text file and check the value entered into a textbox to see if it already exists. Its basically a validation list.
I found some code on how to read a text file, but I do not know what to do with the information.
Sub Main()
If RadioButton1.Focus = True Then
'Check TextBox1 value against list of known part numbers
[Code]...
How do I compare the textbox value to a line read from the file and stop if there is a match?
Normal
0
false
[Code]....
This question has been most likely been asked a number of times, but really hitting a brick wall regarding this.
The issue is that at the moment, I have to create a database using text files on VB.
So far I have managed to get the code working to add new customer and browse added records, but stuck on how to output/input back and fore to a text file, to store information, and after this input/output the text file to a DB ( Not worried about this at the moment)
Public Class Customer
Dim CmrColl As New Collection 'Create the new collection. Think of this as an array of objects.
Dim itemCount As Integer = 0 'A variable to help us scroll through the objects later.
[Code].....
I need to get data from a text or excel file and input it into a windows program that I do not have source code for and cannot get it.What I am trying to do is get sales order data from one of our customers in a file and then read the file and input the order information into our sales order system by actually stepping through the order entry process so all the checks for item #'s, zip codes, etc that are already in the sales order entry software are utilized, basically so that data files integrity is maintained.
I am very green when it comes to programming, can anyone tell me if this can be done using vb.net or should I look into using another programming language.
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.
can I convert the input in the text box and save it into database in pdf file?
View 8 RepliesE.g The user enters data into txtName, what i then want to do is make a text box with the data entered into txtName
So if the User enters Daniel into txtName, then a txt File is created called "Daniel.txt"
I am trying to input a text file of figures into a 2-dimensional array. I want to do this so I will then perform percent changes on the respective columns. The text file contains columns and then numerous rows for each columns each number is separated with a tab. The text file looks something like this.
2.2 5.5
3.7 6.3
9.2 9.1
So I need to be able to input the text file, turn it into an array and then find the total percent change. From 2.2-3.7-9.2
need an example of a console application that would allow you to input data to and retrieve data from a text file on disk.
View 2 RepliesCan I set this function so that if the local settings.txt exists, it will NOT be overwritten unless the mapped file is newer?
If IO.File.Exists("C: empsettings.txt") = False Then
IO.File.Copy("K: empsettings.txt", "C: empsettings.txt")
ElseIf IO.File.Exists("C: empsettings.txt") = True Then
[Code]...
Currently modifying a program that is being used by several staff. Each time they restart it, it starts the latest build.
I have a settings.txt file that is needed for the latest build(not on all pc's yet, original version has the settings written in the code) and updated as needed.
If local PC doesn't have settings.txt, it is copied, if it does have settings.txt it gets overwritten by the mapped copy on each run.
Wanting to let users keep their 'personalized' local settings.txt, unless I add a new feature to the program that requires a change to the mapped settings.txt file.
i have created a program to view images in a picturebox, i have created two list box's one for folder names/image areas to group certaint images and the second listbox to list the number of pages contained in the image folder/area. when the user creates a new image area, he or she can name it whatever they want, when they do that i would like to create a folder in the c drive for instance with the same name as the image area, and i would want it to create a .txt file aswell to keep memory of what they have done, so when they come back to it the next day they can just carry on from where they left off.
View 14 RepliesI am having trouble turning a set of data from a .txt file into arrays, basically, what i have in the text file is:
Eddy vbtab 20
Andy vbtab 30
James vbtab 20
Is there a simple way to save user input from MANY controls (textboxes, comboboxes, etc...) to a text file? When I say 'MANY', I am referring to at least 580 textboxes and several dozen comboboxes.
I may be able to accomplish this using the StreamWriter Class, but doing this individually would take quite a long time. I suppose I could also change all text boxes to richTextBoxes and save to .rtf. It seems like this would be even more time consuming.
Surely there is a simpler way to do this 'globally', perhaps with an added single line of code that points (and saves) to a preset or created text.txt file whenever text is added or changed in a textbox or combobox throughout the program.
how do i code this. my textbox length is 5 and i input only 2 numbers and i want it to save in textfile as 5 Digit ex. i input 2 number in textbox and should be save it as 00012 how can i code this?
View 4 Repliesi was just wondering if there was a way that i could compare data stored in a text file such as usernames and passwords with data input into text boxes in visual studio vb2008?
View 6 RepliesIf my Category and Forum selection is incorrect I am sorry and feel free to move it. I'd like to have the users input in the message box that will show. For example: There is a textbox and the user puts in their name as Bob. Then the message box would be: What my main goal is, is being able to include the users input they type inside the textbox inside the message box.
View 6 RepliesI need to pull a random word from a text file in my resource folder (visual Studio 2010) and then have a user enter a letter to see if it is in the word. Yes, Hangman game. There is more, but right now I need to pull from that text file for a start. I know what I have is not even close to right under "Get Word Button", but I'm kind of confused about the process.
Public Class hangMan
Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
Dim word As New Random
End Sub
[code]....
I'm using VB 2010 and need to multiply 2 user input numbers in forms, so basically: TextBox5 = TextBox2 * TextBox3 That obviously didn't work but it shows what I want it to do.
View 3 RepliesI'm trying to read a text file that contains info like this:
ACX-101-011 , J2168
BTXR-130A-013, D6733
AJ4-233-614, T8211
I want to split each line at the comma and write the left side to a textbox and the the right side to another textbox. I'm close, with the code below, but I can only post results from the first line in the file. How do I loop this and append the text results in each of the textboxes.
Dim TempFile As String
TempFile = "temp.txt"
Dim sw As StreamWriter
[Code].....
I have to save the text boxe values of a form to a text file almost like a data record. I will be saving an Employee First Name, Last Name, Dept Number, and Phone Number. This I know how to do using streamwriter.
next form which we have to use stream reader to load one record at a time. The form has a next button to load the next record. How do I seperate each record (I am sorry for calling it a record if this is inappropriate) when use streamreader and how do I load a record at a time.
I know how to open a file and use streamreader, I just don't know how to read one record at a time and move to the next one.