Im trying to load data from a file into three parallel lists, each piece of data is a different data type. Using a split at the "comma", im having trouble trying to load each piece of data in each list. These parallel lists can be like this:
[Code]...
Really crappy title but i have spent the last hour thinking of a working around.
Summery: A textbox is used to list clients i work for, Uses the splitter ","
Being seven days of the work would some times requier 6 splitters looking like this
Breath, Kemp House, garden center, Garden Center, COEL, PPD, Town
As so, but what if i miss a day? Or i dont always work saturdays sundays. from the code below you will see i have not added any work around fora null value. My suggestion is to incorporate a <nw> (no work) tag, but the code needs to change <nw> to my own personal message that i choose.
[Code]...
i have a generic list of type datarow.i have to split this list at an index and then use both parts of the list.
View 2 Repliesi have this In a txt file
118.97.75.226:8080,
218.14.227.197:3128
118.96.151.110:8080
[Code]...
How do i get this in an array! and then how do i display each line seperately (using a variable e.g 1 would display line 1 and 2 would display line 2) this simple project is going on forever!
I have the following code that simply takes a list (length = 15) and splits it into 3 different arrays (5 items in each). Is there a way to achieve more efficiently?
For i As Integer = 0 To 4 Step 1
COURSE_Course1(i) = TempFullCourses.Item(i).ToString
Next i
For i As Integer = 0 To 4 Step 1
For c As Integer = 5 To 9 Step 1
[Code] .....
I am trying to create a simple Word doc that when the user presses the button it takes the information in the boxes and tosses it into a template style paragraph. But my issue is that I have two combo list boxes as seen in the picture. I want to have two values in the drop down list as seen in the labels next to them but for the life of me I can't figure out how to do this in Word 2007. In Visual Studio this is much easier but I am work and need to snap this out for the folks at work. Is there an option that I can choose in the properties where I type in the values for each drop down or do I have to add them in at run time?
View 1 RepliesI am attempting to read the results from a SQL query into a List(Of) and I can see the List.count while adding items to the List increments, however in another part of my code when I am attempting to read the List the List.Count returns 0. My List is as follows:
[Code]...
I do have this Textbox1 which contains the file name.Now in Textbox2 I want only a certain part of the file name to appear.
View 2 Repliessplitting and trimming text file
View 1 RepliesI have a file that has > 10 rows. I want to create 9 files that each contains equal number or rows, with the 10th file containing that equal number plus any left over.[code]...
How can I take oDataList and parse it into 10 files without having to loop through each file and oDataList to write line by line?
I've got a problem reading in a Tab-Delimited text file. There's an extra tab in one of the fields its reading it thats not a delimiter, and it's throwing off me reading the file into a table. This specific file does have quotations around that field though.
What would be the best way to take that tab out before splitting the row by vbTab?
Im reading each line in the text field like this, splitting on vbTab. X is a string array
text = x(J).Split(vbTab)
I have an excel file which I attached for ref. My intention is to copy the rows which start with the string "sarah" in column A & paste them to a new excel file, save it; copy the rows which start with the string "mike" in column A & paste them to a new excel file, save it.
View 11 RepliesIs it possible to split a file into like 10 parts, and using multithreading copy it faster and then put it all back together? Will the speed increase or will it stay the same?
View 19 RepliesI have I text tab delimited file. in every line of that file at the same position in every row of the file I will have a bit that I would want to compare against 23 values (I will call them criteria). So if on every row the string I need matches one of tjhese values then that row will be written in File1.Txt if that value doesn`t match any of the criteria the whole row will be sent to File2.txt.
So far managed to get the original file written in the same format in a newly created file.
how to get the functionality I described working but am stuck with correct syntax.
Here is what I have so far:
Dim fs As New FileStream("C:Original.txt", FileMode.Open, FileAccess.Read)
RichTextBox1.Text = ""
Dim d As New StreamReader(fs)
[Code]....
Now I will need to declare every single row in RichTextBox1 as String then will have to get the bit I need will have to declare that as well(I will need from every row the string taht is between characters 96 and 104), also where do I keep the 23 criteraia values.
I used to do a bit of coding in early versions of VB years ago but moved on to things like RPG400, CL and SQL on an AS/400 box. As I am no longer in this career, I havent touched an AS/400 for a while either.
I am currently working on a visual basic console application in Visual Studio 2005 which takes various csv files from an osCommerce web shop, processes them and writes the data to TAS Books accounts software with the aid of the Infoplex COM module.
I have 2 functions, one reads each line of a csv file into an array, and the second function uses Regex to split the lines array into the various fields before they are added to a structure.
There are something like 5000 records (lines) in the csv file, one example is as follows;
[Code]...
My problem is that due to the formatting of the product description in the example csv line above, it fails the Regex match and therefore fails to read.
I know this is because my pattern is wrong, but I'm not sure how to solve it, I think all I really need is for Regex to split the line by the "," between each element, this might be a little difficult because some of the descriptions contain both , and " but never one after the other.
I am exporting a directory list from a FTP directory to a text file, I would like any suggestions how best to read and split the information detailed on each row in the text file as information isn't Tab Delimited (which i have code for if it was) and the number of spaces between each attribute is different. Below is a snippet of the text file, the main two I require is the File Size and the Filename.
-rw-rw-r-- 1 user_mb www 80520 Jan 10 12:16 GIFT20-000.jpg
-rw-rw-r-- 1 system www 81119 Jan 10 12:16 GIFT25-000.jpg
-rw-rw-r-- 1 system www 80852 Jan 10 12:16 GIFT50-000.jpg
In this readalllines part because my data is saved differently now it used to be like this
CODE:
But now i saved it in a single and more understandable line like this
CODE:
And i have afew ideas like using the split function and stuff to read the months but can i use the "|" and "," in the line at the same time? the first 3 section of the line is for user to know the year, month and day of the starting date of the chinese lunar year. and the following 1,30 is the first month with 30days.
CODE:
So, for my computing project I have to import csv files (got that bit working, got it opening up and displaying in a text box) and search through it to find criteria that I want.
Anyways, I am having trouble splitting/parsing the csv file so that it will display with no comma's (in a kind of tabbed form) e.g. at the moment it displays as
CODE:
But I want it to display it like
CODE:
Thread Performance text file splitting
View 1 RepliesI have a large tab delimited text file to process each day (usually around 25 mb) consisting of usually well over 100,000 lines. The file is actually made up of about 9 or 10 reports separated by "END OF REPORT". I'm wanting to write each individual report to it's own text file. Some values may have trailing spaces or even contain nothing but spaces, so I am wanting to trim those to only the data, or be left with null. Ultimately each report will be imported into sql server tables. The code I have below runs successfully to completionwithout error although each text file is empty. The script is also extremely slow and seems to use quite a bit of memory. The arguments are ad
View 1 RepliesIm trying to read a text file line by line and place each line in a separate Combobox. right now with my code i can only get it to print lines in separate message boxes.
The text file (test2.txt) contains
1,
2,
3,
[Code].....
if i replace the MsgBox code with Combobox1.text = (strArr(count)) i get nothing.
I have a delimited text file, let's call it models.txt and it's delimited by a comma with carriage returns.
example:
21,Z920081
22,Z920082
59,Z930023
120,Z930027
I'm trying to input this into an array and then a combo box using:
dim item as integer
dim array() as string
dim ifile as integer
[CODE]............
What I want to do is to display the right part of the delimited text (Z920081, Z920082, etc) in the combo box. But when you select the item in the combo box, I want it to use the left part of the delimited text (21, 22, 59, 120, etc) as a variable for other use.
I have managed to access and read a specific file line by line. If I wanted to split information by a comma or space and then sort alphabetically or numerically, how would I go about this procedure? Would I create a loop within the reading loop to parse the information?
Dim file As String = "C:Users est.txt"
Dim Line As String
If System.IO.File.Exists(file) = True Then
[Code].....
I'm currently making a program that will be used to practice German. It reads from textfiles that have English words (noted by # prefix) and German words (noted by $ prefix). An example of this:
#hello $hallo
#good $gut
#evening $abends
The way it currently works is it loads a text file, finds all # and splits to an array called "English" and finds all $ and splits it to an array called "German" What I want it to now do is feed the "English" entries into textboxes on the left, and "German" onto textboxes on the right so I can then match them out and make a sort of memory game out of it. Unfortunately, I don't know how I would loop an array through multiple textboxes. Conveniently, the textboxes on the left have even numbers, and the ones on the right have odd. Is there a way to possibly find all evenly numbered textboxes and loop "English" array entries into them, and the same for "German"? I've realised this has now gotten a little convoluted, but hopefully somebody understands. I can screenshot the form for better explanation, and copy my existing source code if anybody wants it.
I have this piece of code
For a As Single = 1 To Picture1.Height - 1
If a < TempArray.Length Then
' Some Stuff here that i really would love not to share
Else
[code]....
I get an error when i try to add the Array TempArray to the List of Boolean TruthBool... The Error Says QuoteObject reference not set to an instance of an object.The Variables are declared like this
Dim TruthBool As List(Of Boolean)
Dim TempArray(10000) As Boolean
I know there are a couple of other problems with this code.. and i have solved most of them in my actual program.. I just cant get this error to go away...
I'm learning how to add items from a list box to a combo box. I'm trying to follow what's going on in the function loop and comparing a boolean and selected index. I can see that it's comparing the item chosen to each item already in the combo box to make sure that it's not already there. If function finds that it's not in the list it sends back that it is true that the item is not in the list.
It then continues to the statement that adds item to the list. The code for the double click event is working fine and items are getting added to combo box. However, the code for the add button isn't functional. I'm not seeing why it doesn't work? I coded out the original code, and replaced with something I thought might work but it still isn't functional. [Code]
[Code]...
Mod Edit: Please use code tags when posting your code. Code tags are used like so =>
I have an Object structured as follows:[code]I thought this would work but I keep getting the following error: Object reference not set to an instance of an object.
View 1 RepliesI have a program where i let the user dynamically add DataGridViews to the interface, those are also added to a list for easy management. All of the DataGridViews have their own datasources. I am using a Databinding source to get different DataGridViewTextBoxColumns to add.
The problem is the following: When the user adds the first table the following code runs:
dataGridList(dataGridList.Count -1).Clear()
dataGridList(dataGridList.Count -1).Add(NameDataGridViewTextBoxColumn)
No problem there and the right data is displayed, but when the user adds the second table i get an exception thrown:
"Provided column already belongs to the datagrid view"
I think this is strange since i access different DataGridView's right?
The point of all of this is to be able to view different columns in all the DataGridViews depending on the users choices.
I am trying to add things from a text box to a list box. I am running vb.net on visual studio 2005. At the moment, i have a list box, a text box and two buttons one for adding what is typed into the text box and one for deleting what ever is selected in the list box. i understand that for the adding from the text box to the list box i use the button1_click and need to define the entry as a variable but how do i move it accross to the list box? and also how would i delete the items in the list? the code is as follows: cmdAddZp_click is the add button, Zp is the text in the text box called txtnewZp and the list box is lstZp.
Public Class Form1
Private Sub cmdAddZp_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdAddZp.Click
Dim Zp As Integer = txtnewZp.Text
[Code]....