im already familiar with splitting variables into an array using a certain character e.g.
strtextfield = name,surname,dob
strpersonarray = strtextfield.split(",")
strpersonarray = (0)name
(1)surname
(2)dob
im wondering whether you can split one variable according to its characters e.g.
strtextfield = name
strpersonarray = strtextfield.split(unsure as to what char)
strpersonarray = (0)n
[code]....
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 need to split one variable into 3 variables. For example I have a variable called Data and it contains AAA00000001. I need to have them be split between the "AAA", "0000000", and "1". I looked at the Split() function but didn't get a clear example for this situation. The reason I need to do this is because I want to store these 3 variables into fields for a MySQL database.
View 3 RepliesI hjave the following text read from a txt file but would like to assingn each of the three numbers to induvidual variables how can i achive this?
(234.134, 105.087, 0.000000)EDDIT:
[Code]...
only now the product of XVAL and ZVAL is displayed as 0.123 8.910 and not 0.123 + 8.910 = 9.033 the 9.033 which is what im after
This is the code I have so far
Dim vArr() As String
Dim vArrX As String
[code].....
I am trying to split a string into array. I know about split, but it seems to need a separator of some type. Suppose I am going to be working with input like the following. 8561369 and I want to split each character of that string into an array. I tried something like this, but again Split seems to need a separator, I just keep getting the entire string in one entry of my array, not split. Dim values as String 'I am going to be populating this string variable via user input eventually, 'which is why I cannot just add spaces. values = "8561369"
[Code]...
i 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 string:
[URL]
I need to separate each value and put it in an array. typically it would be done by ".split". however I need it to be split in this order: 0, 50, 100, 200, 400 etc.. In other words, I need it to read the rows left to right. I have no problem separating each number, I just need it to read it in the specified order. I've tried the regexp and I forgot to mention that after each line there is a line break. I am not sure if this would impact the regex, but in any case, after i do the regex, I get the following order: 0, 6.65, 84..??, 35.... etc
I am not getting the order I need as stated above
Expected results: 0, 50, 100, 100, 200, 400, 218, 9.8, ???, 6.65, 6.31 etc...
I am going to follow some of the suggestions below by splitting up the string into separate lines initially. this code almost does that:
Dim fields() As String
fields = calculationText.Split(vbCrLf)
Unfortunately for some reason the spaces are lost. When i look into the array, all the spaces between numbers are lost. why?????????
I want to split a string with this array of char
Dim sepa As String = " '"",.;:(){}[]·#|-_<>+¿?=/&%$‚¬@!¡"
The question is how do I include in this string vbcrlf? So I can do the fallowing:
dim palabras as String() = RichTextBox1.Text.ToString().Split(sepa)
I tried:
Dim sepa As String = " '"",.;:(){}[]·#|-_<>+¿?=/&%$‚¬@!¡\r\n"
But it does not work.
Im writing a program where im trying to split some text imported from a textfile into a textbox into an array.The array is undefined and i would like each piece of text to be an element in the array. I would then like to sort this information into alphabetical order.This is the code I have at present; I apologise if any appears to be out of sequence or whatever, VB is a rather puzzling language to myself!
PS i have the code behind a button as you can tell from the code.
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim textInput As String
textInput = TextBox1.Text
[code]...
So I'm trying to split a "," from an array that I parsed after the xml file is loaded. I tried several things.[code]
View 10 RepliesThe format I use in the file I am reading is this: [property name]=[property value],[property name]=[property value],[property name]=[property value], [etc...]
I coded the following, but I pinpointed an error on the very last line of code shown here.[code]...
I'm trying to read lines from a file and split them into two words contained in a two dimensional array.[code]Does anyone know why I'm getting this error?
View 1 RepliesI am a little bit confused by the following VB statement
commands = Regex.Split(script, _
"GO", _
RegexOptions.IgnoreCase)
I know what regex.split does. I know what the first parameter is. The second parameter is what I'm confused by. I think it is using the word "go" as a delimiter to split the first parameter into an array of substrings. But I don't understand what that refers to.
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.
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 am creating an app to use as a data logger, that receives serial data from a micro-controller and displays the various values and to plot some line graphs of the data, as well as eventually sending commands to the micro-controller, right now though I'm just trying to get the data being received to display in a rich text box like :
[Code]...
I have a situation where a user can enter just about anything they want into a text box.Whatever they enter in the box, I need to split the string into an array of strings where each item is one word. For example, if the user enters All State Insurance, I split that into a string array:
sParams(0) = "All"
sParams(1) = "State"
sParams(2) = "Insurance"
[code]....
I've been working on this challenge for a while now without much luck. What I'm attempting to do is split a MIME byte response into its individual images. I am given the boundary to split on in the HTTP header but when I attempt the following code it doesnt work.
'boundary to split on
Dim boundary as string = _
"boundarystring"
[Code]....
I am trying to split text in a TextBox and I get this error {"Index was outside the bounds of the array."} while using this code
Dim s As String = Me.RichTextBox2.Text
Dim parts() As String = s.Split(":"c)
Me.TextBox1.Text = (parts(0))
Me.TextBox2.Text = (parts(1)).Trim
I am stock, it will work fine for a couple of reads, since the Me.RichTextBox2.Text text changes constanly but every now and then I get the error
I need to manipulate data for 1000 boxes, each one of these boxes has 8 variables.How to declare an appropriate array? and how to load the array with the 8 variables for each box?
View 1 RepliesOk so I have an array and wish to add the variables of the array to separate lines of the list box. I came across this which in some ways worked but also didn't. The second thing mentioned on the page was to us:
ListBox1.DataSource = Form2.Title This works the first time you run it but if you try to run it again nothing happens. So using the above or something else how can I get it to update the list box? Another thing I tried was to use the DataSource method but instead to clear the list box first, but that turned up an error
I have a set of nine double variables declared earlier in a program (i.e., phq91 through phq99) that I have placed within an array. The variables need to hold numeric data that correspond to item responses within combo boxes.
View 6 RepliesMy problem is, in VB 2008 I need to convert this[code]...
View 8 RepliesI have a small class of Object CellValue
Friend Class CellValue
Public CellColor As Color = Color.White
Public CellShape As Shape = Shape.Blank
Public CellName As String = ""
End Class
Then in my main I make an array of CellValue but I want to know if the values are also being passed down with the array.
Dim Plan(SizeW - 1, SizeH - 1) As CellValue
Dim CellW As Integer = PictureBox1.Width \ SizeW
Dim CellH As Integer = PictureBox1.Height \ SizeH
[Code].....
Are CellName, CellShape and CellColor being tied to each element in the array?. The reason is because I need to use these properties to tie certain functions to them. The CellName should have a MachineID which I would have to use to pull some info from a Database.
The Array should also be serialized and deserialized to XML as customer needs to create/edit and delete certain values in the array. And in order to save the array has to be in XML
So the Questions are does it save the CellName, CellShape and CellColor for each element, will it be affected if I serialize and deserialize using XML. If possible, how can I call up the Cellname p.e for a specific array element.
I'm trying to put together a quick program for our database, I haven't touched VB since vb6, and we have 2008 .NET now. my question.
Ideally I'd like to make an array which can hold multiple values...such as
Job[job#].joblocation
Job[job#].jobsupervisor
So there would be a Job array, and then different values contained within that. I can't seem to make an object or whatever which allows me to hold different variables inside it.
I have a form that asks for a name, and a phone number, it has 3 buttons, a add customer button, show list button and an exit button. When the add customer button is clicked, it increments intCustomer variable, formats the phone number, makes sure only the first letters of the name are capitalized and creates an ID that is the first 4 letters of the name plus the customer number, the show list button takes ALL customers added to the array and displays them into a multi-line text box, like so:
ID Num Customer Name Phone Number
JOHN-1 John Harry Peters (111) 111-1111
Paul-2 Paul J Rodgers (111) 111-1111
Etc...
The area where I am completely lost in, is how to add the consecutive customers to the array, in the correct way. here is my code in its entirety
Public Class frmCustomerName
Dim intCustomer As Integer = 1
Dim names(9, 2) As String
[code]....
This may sound quite basic, but i was wondering how to change the value of a variable in an array, not knowing the index value but knowing what the variable is.
For example, I have an array and I want all strings within it that haven't got a value to say "Stretched". here is what i have tried:
For Each stl As String In Me.stl
If stl = "" Then
stl = "Centered"
End If
Next
My array is called stl(), and the size of it is always changing, so i can't just change the specific variables within the array
Also, is there some way to show/change etc all variables in an array? e.g. msgbox(stl(all))
I know this won't work, but what will?
I have text file that is saved as comma delimited. There are 3 columns with x number of rows. I cannot seem to figure out how to create an array that will store all three columns with the variable intProductArray as the length of the array. I have been opening the file with only one column and putting it into a textbox and using the lines of the textbox as the variable for length. I cannot figure out the array for all 3 columns.
Private Sub btnChoose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnChoose.Click
Dim myFileDlog As New OpenFileDialog()
myFileDlog.InitialDirectory = "c:"
myFileDlog.Filter = "All Files (*.*)|*.*" & _
[Code] .....