I wrote a program for my company and it imports a .csv file i then split it by the ,. My problem that I now see at the end of the project is that 98 out of 1400 items have, in the descriptions that im seperating. This creates a problem when search for items. My question is is there a way to use more then just one char to split it? i was thinking of splitting using ",".
View 11 RepliesI am a school student and having a project on importing text to access database. The problem seems easy but the issue is the text file i am trying to import has no delimiter. .
firstnamelastnamesexage
jhonlittlem15
Now how can I split the text and import it to an access database.
I'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 a large financial application which I am migrating to VB.NETIt has two main components: charting and financial statements.I want to know if it is possible (and how) to create a main exe, and then two separate projects for the two components (as dll's?).
View 3 RepliesI need to split the Filepath in my Windoes Forms pplication in order to get the correct part of 'Import Project' file. I think I need to use the split(vbCrLf) control to do this but am having problems coding it. I have included my code(so far) and have underlined the area where I am confused. the code?
[Code]....
I want to try VB.net and i want to know if the forms in Access 2007 can be imported to VB.net?
View 2 RepliesI work alot with the visual basic used by MS Office at my work, and recently started taking a visual basic class. As a result of this class, I've started working with visual basic.net.What I was wondering was... can I export the forms I make in VB.Net into the Microsoft Visual Basic used by MS Office? How would I go about doing that?
View 2 RepliesI have a String with 15 places that I would like to split into 3 pieces: (First 3 digits), (next 3 digits), (remaining 9 digits).
How in VB2008 can I do that? Everything I have read so far indicates seperating by a certain character (ie: "," or " ") but no mention of character place. Seems like a simple thing, but after 2 hours of searching I'm still coming up empty
when I try to import an image into the forms background the form turns white ( I want another color ) and when I move controls around the pictures of the controls stay the screen. How can i fix this?
View 3 RepliesI am using VB for developing a GUI. I need to display charts in the VB form. How do I invoke Excel 2003 using VB and import the charts created in it.
Steps:
1) Getting input from the user using VB form and processing it in VB or external application such as Matlab.
2) Over-Write the processed data in excel sheet.
3) Modify the charts based on the new data which I believe will happen automatically.
4) Display the chart in the VB form.
I got one problem. I did simple listview-saver, (with 1 line) and all working (import, export)...
But i want to add new colums. But I don't know how to export or inport them.
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
TextBox4.Text = TextBox1.Text & vbNewLine & TextBox2.Text & vbNewLine & TextBox3.Text & vbNewLine
Dim str(3) As String
Dim itm As ListViewItem
[Code]...
This code is with adding items to colums, but it saving only first item from line. Anybody know how to export and import all items from line?
I have a File i need to read and extract a few values from each line in the file. my problem as it stand the file i'm reading has some unconsistatcys as all of the Strings are seprated by " " but the integers are not they are Without any Speech marks to define them. I have thought of a methord to deal with this but i can't for the life of me think how to achive this.
As the file has unconstancys to be used with a standard " " extractor, the only consistancy is that there is allways a " before the integer and after attached to another column. this could be used i thought.
a Sample of the data is only one line:
[Code]...
I am trying to split a long string based on an array of words. For Example:Words: trying, long, array Sentence: "I am trying to split a long string based on an array of words."Resulting string array:Multiple instances of the same word is likely, so having two instances of trying cause a split, or of array, will probably happen.
View 5 Repliestrying to input a text file that's tab delimited that looks something like this.
2.2 5.6
3.7 9
1.2 9.1
[code].....
I'm trying to import a tab delimited file into a table.The issue is, SOMETIMES, the file will include an awkward record that has two "null values" and causes my program to throw a "unexpected end of file".For example, each record will have 20 fields. But the last record will have only two fields (two null values), and hence, unexpected EOF.
Currently I'm using a StreamReader. I've tried counting the lines and telling bcp to stop reading before the "phantom nulls", but StreamReader gets an incorrect count of lines due to the "phantom nulls".I've tried the following code to get rid of all bogus code (code borrowed off the net). But it just replaces the fields with empty spaces (I'd like the result of no line left behind).
Public Sub RemoveBlankRowsFromCVSFile2(ByVal filepath As String)
If filepath = DBNull.Value.ToString() Or filepath.Length = 0 Then Throw New ArgumentNullException("filepath")
If (File.Exists(filepath) = False) Then Throw New FileNotFoundException("Could not find CSV file.", filepath)
[code]....
I've tried using SSIS, but it encounters the EOF unexpected error.
I'm writing a program in Visual Basic 2010. It's a HMI (Human-Machine Interface) and therefore has a whole whack of buttons that just send commands to other devices. As a result, there are a huge pile of event handlers for clicking buttons that can't really be broken down into modules (unless my understanding of modules is wrong). Essentially, I'd like to be able to move all the event handlers, for, say, button presses to a different file. Can this be done or is it important that they stay in "MainWindow.xaml.vb"? (All my buttons reside in one fullscreen window, some are hidden by tabs).
View 6 RepliesI want to split a text file in two part , as the file size is approx 30 GB , how can i achieve this is vb.net , i am having a ram of about 4 GB.
I got one solutions of split the file but its split into various text file i just want it to split in two part the first part should contain first 9 lines and the second part contains the rest of the lines. [code]...
As to use split in the file in a HTTP server without needing to save in the HD, it's possible?
Using this code, but to open file direct in the HTTP server.
[Code]...
I have read the contents of a text file that looks like the following lines into vb;
this_date = "1-2-09"
// user input
//user input
this_date = "2-22-2009"
[code]....
(there is no limit to how many "this_date" lines or "//user input lines" there are in the file and additions are made often ) When I read the file in vb I wish to only capture the last "this_date" only as the rest are irrelevant.
I have a 2 gb text file and I need to split it up into several parts in order to handle it efficiently. The more the better. I would like to split it up every 50,000 characters.
View 9 RepliesI'm using this script:
Dim idnumber = InputBox("input client no", "Search")
currentdir = My.Computer.FileSystem.CurrentDirectory + "
ecord"
[code].....
I have a lines in my text file like this
[Code].....
It not spliting the line and writing but it write everything to text file
I have a large text file which I want to split into many different items.
On the next file I have a time between each item it's like this
01:20 a.m.
01:44 p.m.
In between these items is information like you would see in a log file.
How can I split these items like this?
I have a large file (2.7GB). I need to split it into smaller files. How to split a large file into smaller files using VB.NET 2003? Cannot use LINQ and the resources (cpu and memory) on operating environment are very limited (it is a shared hosting environment).
View 1 RepliesHow can I break a large mp3 file into one or more mp3 files, and still have each part playable in a media player?
View 2 RepliesI have a problem I was hoping someone might be able to help with please. I am trying to read and interpret a .txt filewhich typically has a data line of the form:I want to be able to split each value, i.e. so I have:
DESCRIPTIONNAME
104.19
6171
[code].....
I have a text file which has the format
A;UK;WN0XKKF;XX377SL;POSS TRADE MONITOR
A;UK;N6HXS;XX361NG;POSS TRADE MONITOR
A;UK;DU58XPK;XX37 6UR;EXCESSIVE WASTE MONITOR
A;UK;R251YXF;XX36 ZHA;POSS TRADE MONITOR
I am trying to read the code, and pull out the 3rd, 4th and 5th set of each line in to a datagrid.
Dim list = New List(Of datagrid)
Dim FILE_NAME As String = "C: est.txt"
If System.IO.File.Exists(FILE_NAME) = True Then
Dim objReader As New System.IO.StreamReader(FILE_NAME)
Do While objReader.Peek() <> -1
[Code] .....
I get the reg come up ok, but then it errors out with Index was outside the bounds of the array.
my text file will look like this
7.0 28 Black [2 11.94 37.7] (2 13.00 14.0) 115611 2275 79996 -5121
7.0 28 Black (2 13.00 50.0) (2 04.00 39.0) 78111 -60725 61611 2275
7.0 28 Black (2 11.00 18.0) (2 02.00 19.0) 108111 -74725 109611 -11725
[Code].....
9.0 28 Black (2 13.00 26.0) (2 01.00 26.0) 97611 2275 97611 -81725
9.0 28 Black (2 01.00 49.0) [2 11.00 18.0] 63111 -81725 109611 -11725
2.0 28 Blue (2 14.00 64.0) [T1 ] 40611 9275 81504 -49757
[code].....
my text file will look like this
7.0 28 Black [2 11.94 37.7] (2 13.00 14.0) 115611 2275 79996 -5121
7.0 28 Black (2 13.00 50.0) (2 04.00 39.0) 78111 -60725 61611 2275
7.0 28 Black (2 11.00 18.0) (2 02.00 19.0) 108111 -74725 109611 -11725
[code].....