Array Calculation With CSV File?
Dec 4, 2011
I am trying to work with taking in and parsing CSV files. Right now I have it taking in and producing something like this:
The program loads the csv and copies the data into an array as such:
ReDim strarray(num_rows, num_cols)
For x = 0 To num_rows
strline = strlines(x).Split(",")
[Code]....
etc. I guess my main problem is trying to perform calculations to all values in a specific column. To start I am just trying to figure out how to isolate the columns and found that by using MsgBox(strarray(x, num_cols)) it will msgbox everything in the second column twice. I just want to try and understand how I can perform a basic calculation like multiply every value in the first column by 2 and every value in the second column one by 3.
View 1 Replies
ADVERTISEMENT
Dec 7, 2010
I am writing a pizza order program for class and have gotten everything put together, even got my array setup and displaying but when i go to calculate it will not calculate the values coming from the array in any of the calculations.
[highlight="vb"]Option Strict On Public Class Form1 'declare structure and module-level variables Structure PizzaSale Dim SizaString As String Dim StyleString As Stri]
View 3 Replies
Feb 1, 2012
I found this thread in regards to calculating CRC16 on an array.... however, it does not work probably because it was written for VB6 and not .NET. [URL] Does anyone know of a built-in function in .NET to calculate CRC16? If not, is there a way I can adapt the above VB code example to work with Visual Studio 2010?
View 12 Replies
Mar 23, 2012
I have a 2d array and I want to do a calculation on each element in the array and then return the index which results in the smallest value.
I have tried iterating through each element in the 2d array and running the calculation. If the calculated result is smaller than the currently stored minimum I set that to the minimum.
This works but it runs so slowly it makes the solution a non starter. It performs each calculation quickly but because of the number of elements in the array the calculation for the whole array is stupidly long.
View 1 Replies
Dec 19, 2009
I need to store a calculation to use later and obtain a new calculation
[Code]...
View 4 Replies
Jun 2, 2009
Lets say I have a line like this:dblvalue = round((.meter/100)*100/360)If I want to retrieve the value of .meter which is in a .txt file say line no.4.
Textfile
=====
133
[code].....
View 3 Replies
Nov 27, 2009
Can I save an array into my .bin file then read the array again just like a string or Integer??
View 2 Replies
Sep 9, 2010
I want to reading in a excel file and extract the sCodenumber sDescription ans the sStatus and store them in a array : StatusComposeArray(5200) As MyCompose. After this I need this array for comparing outside this class. But as can you see the array is defined inside the sub: ReadingIn_ExcelFilesCompose [Code]
View 2 Replies
Mar 20, 2011
I have a Comma Separated value file in .txt format... simply put, its a bunch of data delimited by commas and text qualifier is separated with ""For example:
"So and so","1234","Blah Blah", "Foo","Bar","","","",""
"foofoo","barbar","etc.."
Where ever there is a carriage return it signifies a new row and every comma separates a new column from another.My next step is to go into VB.net and create an array using these values and having the commas serve as the delimeter and somehow making the array into a table where the text files' format matches the array After that array has been created, I need to select only certain parts of that array and store the value into a variable for later use.... how to make the array and selecting the certain info out of it..
View 1 Replies
Mar 28, 2012
im trying to make an example program for a teacher friend of mine
Springfield
Toledo
Youngstown
[Code]....
thats just what i have so far but im really having trouble getting the other part into a 2d array. i want the second half to look like this when done: the oppsite of what it looks like in the file.
001
359
203948
View 3 Replies
Jun 8, 2009
I have an array of filenames, and an array of files in a directory. I use a for loop in a for loop to check if those files are in that directory. Look at the below code to illustrate my problem. [code]
View 8 Replies
Sep 20, 2009
How do I read a raw byte array from any file, and write that byte array back into a new file?
View 3 Replies
Dec 3, 2011
I'm close to getting this to work, but currently can't get any output to display in the listbox. I had it working, but needed to move some things around to get the join function to work.In my program, a user enters input into a textbox and an array is displayed in a listbox based on what they type in. For example, if they type in "a", all foods (in the textfile that is connected to the program) that start with "a" will be displayed.
When there is output, I need to find a way to name this array (which is created based on what the user inputs) and join all of the items in the listbox (example: foods stacked on top of each other in the listbox will be shown at the bottom as a string).I am posting the code that I have thus far; all of the errors that I'm getting (and potentially my logic errors) are just in the first public class until the end of the first if-next statement:
Public Class frmFoods
Dim foods() As String = IO.File.ReadAllLines("foods.txt")
Private Sub btnDisplay_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDisplay.Click
[code]....
View 1 Replies
Sep 4, 2008
trying to find a decent answer for my question; I do have a utf8 file which I (down)load, manipulate and wanting to save back again.The result always is that the file I produce is not in utf8 format;
Dim fs2 As New FileStream("c: est.dat", FileMode.Create, FileAccess.Write, FileShare.None)
Dim w As New BinaryWriter(fs2, Encoding.UTF8)
[code].....
View 3 Replies
Apr 22, 2012
I am trying to create a sort of 'personal code library' in visual studio 2010 where the form displays a list box of certain project files in vb that I have made in the past and when selected, a button can be pressed that launches the .exe files of those visual basic program project files or displays the source code (.vb file)
[Code]...
View 1 Replies
May 30, 2010
I'm trying to take items from a list box, add them to an array and then output the array items to a text file using Visual Basic 2008 express.
The number of items in the list is unknown so I can't set the array size to start.
Code:
Dim sWriter as IO.StreamWriter = New IO.StreamWriter("C:file_name.text")
sWriter.WriteLine("Name List")
sWriter.WriteLine(arrayListItem)
[Code].....
View 1 Replies
Dec 22, 2010
i have a structure of;
name
age
gender
location
then i need to read in a file into an array on the structure above, and pretend this is the file which has 3 people
george
45
m
usa
[code]....
so basically i dont get how to read in a file then put it in the array in that structure then make it into a csv file?and whats the difference between streamreader and streamwriter?
View 1 Replies
Mar 11, 2010
I am attempting to gather a group of file names from a directory. I am able to do this. I tested the code by having the list populate into a listbox and all desired items were added to the list.
Here is my code:
Dim di As New IO.DirectoryInfo(strPath)
Dim dir1 As IO.FileInfo() = di.GetFiles("*.txt")
Dim dFiles As IO.FileInfo
ListBox.Items.Add(dFiles)
However, a listbox is not my desired output. I am attempting to write these file names to a text file for purposes of then parsing the information to a datatable to compare with another datatable. How to get my filenames written to a textfile.
View 2 Replies
Mar 9, 2009
Heres my code in vb 2008[code]...
I need to add 15% vat to it and i have no clue how to add the 15% vat.
View 1 Replies
Aug 29, 2010
compute an exact age of a person using the format date of mm/dd/yy... in vb.net, i was trying to code it but the result was not the exact age of the person.lp me...
View 11 Replies
Oct 6, 2010
I am using Microsoft Visual Studio 2008 with VB.NET, and in class we were assigned this project: A procedure should calculate a 2% price increase on all red shirts, but a 1% price increase on all other items. In addition to calculating the price increase, the procedure also should calculate the new price. You can use the variables strItemColr, strItem, decOrigPrice, decIncrease, and decNewPrice. Format the original price, price increase, and new price in the lblOriginal, lblIncrease, and lblNewPrice controls, respectively.
View 1 Replies
Sep 12, 2010
I have datagridview, wich have 5 columns
example:
id supplier bought payed sum
1 a 15
2
2 a 20
[Code].....
View 3 Replies
May 8, 2011
i have an issue with my program. when i create a function and use a calculation in it it returns a wrong answer. if i copy the calculation and put it directly in the btnClick event it works ok. is this normal?
here is the code if you would like to try see what i am doing wrong.
Private Sub btnExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExit.Click
[code].....
View 6 Replies
Aug 21, 2010
I'm having trouble with a calculation in VB and it's a simple one but for some reason I keep getting an output of zero.
Here's the code for the calculation and the click button:
CODE:
View 5 Replies
Apr 15, 2012
i have this problem on how to calculate the amount due in our system in VISUAL BASIC.NET .in returning module, (this is for penalty purposes), if the borrower didn't return the book on time, the system must automatically generate the amount due .one daY is equivalent to 10(ten) pesos.so if the borrower didn't return the book with 2 days. the amount due must be 20.00 pesos.
View 6 Replies
Jan 5, 2011
I have two money fields in a SQL database called TotalClaimed and PartialSettlementAmountRecd.They are declared as Decimals like so:
Public PartialSettlementAmountRecd As Decimal
Public TotalClaimed As Decimal
They both output the repsective amounts perfectly. I need to do a calculation on them, by subtracting PartialSettlementAmountRecd from TotalClaimed. I have tried the following, but it just outputs a random number, not the amount I require.
Dim NewSettAmount As Decimal = (ClaimDetail.TotalClaimed) - (ClaimDetail.PartialSettlementAmountRecd)
Response.Write("New Settlement Amount: £" & NewSettAmount)
View 3 Replies
Mar 15, 2012
what i am trying to do is i have two textboxs which have figues in them and need the 3rd textbox to display the figure the code i am using doesnt seem to be doing anything could anyone spot it and tell me why it is not working for me
[Code]...
View 2 Replies
Mar 17, 2012
i am trying to do is i have two textboxs which have figues in them and need the 3rd textbox to display the figure the code.[code]I want the answer doesnt display in the textbox as i want it but when i click on the text box nd type anything the answer shows but in the error
View 6 Replies
Dec 15, 2011
Develop an application which reads two integers n1 and n2 from the user via two textboxes and displays in a label the sum of the factorial of the integers n1 and n2?
View 3 Replies
Jun 9, 2011
I'm writing a financial calculator. I know that my calculations are more precise when Decimal format is used. But when I calculate 314/365, the answer given by VB is 0.8602814581, where as the real answer is 0.8602739726. This ends up affecting my calculations quite a bit.
View 7 Replies
