EXCEL Reads A Text String As Scientific Notation
Dec 31, 2007
I am working on a project that involes reading an Excel file, picking through it, then creating a flat CSV file. One of the the data elements I am picking up is a 9 character string that may be numeric, or contain one or more alpha chatacters. Excel has a nasty habit of converting long numerics to scientific notaion. I can overcome this by converting the "general" string to "TEXT".
However, there is one instance where I can not get the function to work...the string is "90333E108" ( the CUSIP for USU). Regardless, the text string is saved properly into the CSV file. When opened in a text editor, it reads correctly.
When opened with Excel, it is in scientific notation. Changing the field to "text" from "scientific" still displays "9.03E+112".
how to create an csv file that Excel will open and read correctly?
You can test this by creating an Excel workbook, format all cells as TEXT and add the following data:
90333E108
123
2
[Code]....
View 14 Replies
ADVERTISEMENT
Nov 12, 2011
The only post I can find on this matter is one that coverts the double to a decimal before converting it into a string. However the numbers I'm using are far larger than what a decimal can store.
Example: 1/(16^10)
So how can I convert the solution to the problem above. Which equals 0.00000000000090949470177292824, to a string value that is exactly as it's shown?
Cause when I convert this to a decimal I still end up with a string in scientific notation..
View 39 Replies
Feb 19, 2009
I can not column 4 of my Datagridview1 to display numbers as ###,###,### with not decimal places it seems stuck in Scientific notation mode, even though I have set it several different ways in the menus.How do I set it in the program like I set the column width.
DataGridView1.Columns(2).Width = 80This is in VB ExpressGary
View 3 Replies
Sep 28, 2009
I've written a small program that does some calculations and I want to display some of the results in scientific notation. For example, I want to display 0.005 as 5.0E-3.
View 2 Replies
Mar 12, 2009
6/0
6/1E-10
6/2E-10
[Code].....
I need those in there true form not scientific notation, how do i do this in vb.net?
View 1 Replies
Apr 11, 2009
I am trying to have a firm grasp of VB.NET and wondering if there is a way to use a double dot notation instead of the single dot notation people are normally accustomed to?The double dot notation that I want to implement is shown directly below:
PersonData.Birthdate.IsValid
Currently, the only way I know is by using the call shown below which I suspect is not using the full capabilities of .NET:
Validations.IsValid(PersonData.Birthdate)
My code is shown below:
vb.net
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
modVar.intDay = 25
[code]....
View 6 Replies
Jun 13, 2012
I was using the following code:
If Entry.ToLower = "test" Then
Dim test As Double
test = Double.Parse(InputBox("test", "test")[code]....
to check if I can inputoutput scientific numbers tofrom Double.I was able to output the data successfully. (With "E" instead of "* 10 ^" but that's fine)But when I input the same number error occurs.
"System.FormatException: Input string was not in a correct format.
at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
at System.Double.Parse(String s)
at Particle_Simulation.General.ConsoleEntry(String Entry) in G:ProjectsVisual BasicParticle SimulationGeneral.vb:line 23"
View 6 Replies
Jul 15, 2010
My application reads information from an Excel spreadsheet into a DataSet (ds1) which is then filtered into another DataSet (ds2) based on user-specified criteria. The information is basically telephone call logs that reflects when a phone call was made,what extension it was made one, how long the call was, what number was called, etc.When the user's "search" criteria is matched in ds1 above, the application adds the number called to a ListBox on the form. When the ListBox Item is selected, additional information (call duration and such) is displayed to the right of the ListBox. My problem is that a single phone number could have been called multiple times on an extension within the date range the user specifies and for each occurrence of that number in the ListBox, the "expanded" info only reflects the information for the 1st call to that number listed in the DataSet.
The only unique identifier I have is the DateTime field for the row (as this goes up to the second). I thought about putting it into the ListBox item, but I'd prefer that this date not be visible until the user selects the ListBox item to view the details for that call. [code]
View 7 Replies
Jan 28, 2009
I have a hardware which sends out packets containing 17 bytes to the comport in bursts of 3. the little test VB that I have written receives and displays the bytes in a line of 17 bytes long and works fine until it gets to around 170th packet, then it starts to mix up (looks like shifting the data left) the bytes shift mostly by one digit sometimes by two. then it will continue to give almost a packet correct and a packet shifted for about 50 packets. Then it will correct itself for a long while, but then the speed at which it receives drops. All the packets are sent 3 times, and before things go wrong (within the first 170 packets) the packet counter shows that it receives 3 packet each time but after the problem it goes to 2 packet per burst and then to one.
If i close my VB monitoring program say at packet 165 and immediately open it again, it wont go wrong for another 170 packets, this points the finger at VB. I have check my hardware, there is no problem with that.The program reads port - waits for 17 bytes - once 17 has been received it will go and buffer the packet in an array. In fact they are 2 arrays but printing fro either results in the same problem.I have tried whatever i could think of but to no avail, i am wondering if some kind of house keeping needs to be done to clear something... I am sorry the program is a bit messy but I have been making many changes to find out what the problem is - my code below:[code]
View 11 Replies
Oct 3, 2011
I would like to query a string that only reads a last character.
sqlstmt = "select * from table where Area like'%A'"
Dim cmd4 As New SqlCommand(sqlstmt, con2)
da = New SqlDataAdapter(cmd4)
ds = New DataSet
[code].....
I have the above codes but i've got '-1' if nothing to read..
View 8 Replies
Jul 7, 2009
The code below reads each line from a file and if the conditions become true it adds the contents of the file from the particular line and after into a string collection (i.e. the All contents). This is what at least what the code should do as the current one only adds the line that it encounters into the string collection.
View 5 Replies
Oct 30, 2007
I have a simple Windows Service that reads from an Excel spreadsheet and imports the records into a SQL Server 2000 database table. Before it loads it checks if the file has been successfully imported before (using filename) and whether any of the records in the file have been imported before (using primary key). If these checks are ok I load the records into a datatable and then update the datatable to the database.
However, I need to do this in a transaction as I want to ignore the whole file if there is an error. The file goes to a discarded folder and the user gets an email with why the import failed. (This is likely to be because the store the record is for is not yet added to the database and the referential intergrity of the db fails). If there is no transaction the records before the failure record are imported. When the file is imported again (the store has been added to store table) the file is then rejected because duplicate records are already in the db.
Heres my code:
[CODE]...
View 3 Replies
Jun 15, 2012
I am trying to update someonelse code, the attached code reads from a unicode txt files and compares a string of "Department_Name |Division_Name|Position_Name|Job_Name" with a db field called "ident_org" in org tbl. Since it is a bad design, I need the code to check a combination of ""Department_Code|Division_Name|Job_Code" against db and get the value of uid_org (unique key). Then if key exists then update that specific row(s) else insert the combination of "Department_Name|Division_Name|Position_Name|Job_Name" into db.[code]....
View 3 Replies
Mar 15, 2009
I am writing an app that reads from the com port, filters the data, then writes to the text box, then immediately starts over. This all takes place in an endless " do while" loop within the "start" button code. I also have a end button too which closes the com port and ends the program. Some other buttons are present also to change the filter settings.Problem is when I click start, data is logged, but none of the other buttons work. Also some of the text boxes are "see through" and dont look like thy have updated with the rest of the form.
View 9 Replies
May 10, 2009
I'm trying to create a program which reads a text file into an array.
[Code]...
But that's just silly so how can I fix this? Lines isn't being assigned a null value it's being assigned the first line of text in the file which has text in it so I'm confused.
View 5 Replies
Jul 1, 2010
im makign a game that reads text files off of an ftp server. everything is working great. except for the fact that i cant read more then the first line of the players text file. how would i use substring to, for example, look for 'inventory' and get all the info under 'inventory' and above the next title?
View 4 Replies
Jan 4, 2010
I have a piece of code that reads in lines of tabbed text. It is a game of who wants to be a millionaire. What I would like to do is get the game to incorporate random questioning.
The format of the text file is as follows:
Which record company did the Beatles create? (tab)Apple Records (tab)Sony (tab)BMG (tab)LiteFM (tab)Apple Records (tab) Which has the highest mountain? (tab)Mars (tab)Ireland (tab)Iceland (tab)America (tab)Mars(tab) With a set amount of lines. I want the program to choose each question randomly and not to repeat the question. I'm not sure how to incorporate it into the code.
Quote:
[CODE].....................
View 1 Replies
Feb 14, 2011
I'm having problem with our germany customers whose operating system uses dot as thousand separator and comma as decimal point.I have an application which reads some text from an Access database, parse it into data and display on a datagridview,the program also needs to write the data into another file as input to another application. right now, it seems when my application parses doubles (say 0.2500),germany os will always return everything except the decimal dot(so 0.2500 becomes 2500),and that just messed up the whole process...so my question is, how can we detect the locale of the windows and parse the doubles correctly?
View 6 Replies
Oct 10, 2011
Im trying to come up with a do while statement that reads through a text file till the end while pulling out 3 different matched items, then writing those matched items to ascending spots in an excel file, and then creating a bar graph according to the saved data. Sounds complicated but...I have the program reading the text file, pulling out the first iteration of all three, writing them to an excel file, and I have it even graphing them the way I want it to. The only thing I havent done before (and which is probably the easiest), is creating the do while statement so it keeps searching line to line for the three interactions of what im looking for and writing them to ascending spots in the excel file.
Right now my code works like this, which is perfect for pulling out the first 3 and creating a graph, I just inserting a do while and a rowindex + 1 variable.
vb Dim alines() = System.IO.File.ReadAllLines("C:deviceinfo.txt")
Dim amatch As String
Dim muvalue As String
[CODE]................
I have a feeling in order to pull this off, I do not want to use the, "ReadAllLines" option and possibly want to put the text into an array.
And do something like: if lines.count > 0
But im not familiar with how arrays work in VB, and more specifically what the syntax is. The other tricky thing I am trying to add is an if statement that adds to a variable (such as i) everytime a line is added to excel so the program will write to ascending lines. I was trying to have the it work with the do while statement but pretty soon realized that if I did: i = i +1. Everytime it went through the loop then the data was going to be on random lines corresponding to their place in the text.
View 17 Replies
Aug 18, 2010
Hi, I'm working on a program that reads text entered into a textbox and creates a list of items by separating entries by commas. Everything is working fine, except, because I am using an array to store the items in the list, I have a limited number of entries. This is only a problem because, as it is written currently, each comma counts as an individual entry. Therefore, users can enter ",,," for example, and it would use up 3 places in the array.
I'm looking for a way to check to make sure there is text after the comma before adding an entry. I've attempted to use the .substring command to check the character after, which works until it gets to the last character. Because there is no character after that, it will give an error.
Here is my code for extra clarity:
Public Class frmMain
Dim intCounter As Integer 'Stores the # of commas in the string
Dim Messages(49) As MessageProperties
[code]...
View 4 Replies
May 17, 2011
Our programming teacher taught us to use the Hungarian notation (e.g. intMyInteger, strMyString,...) while programming.But I have heard somewhere this isn't actually used in the professional world. Is this true?
Edit: I just found out this is actually "Leszynski"
View 5 Replies
Aug 11, 2009
I'm trying to build a scientific calculator with vb .net, except it is vista glass :-p
I basically want the user to be able to enter an equation like SQRT(5 * 6) / (2 ^ 4) and then I want vb to use system.math to solve it. If I write this in my code, vb is able to do it, so how could I do this at runtime.
View 4 Replies
Apr 16, 2010
Show me a link to the source of a good scientific calculator example?
I'm using VB express 2008. I've been searching, but I can't find any good ones that work with express 2008!
View 6 Replies
Nov 15, 2011
I've created an application where our clients can have access to our program by logging in. It uses our database for most information. I want to implement a richtextbox where it saves notes but i don't know if i should be saving that information as a file or what. Also I also have an application that handles everything that deals with our clients I also want to implement a messaging system that can leave a message to the client upon opening the application if they are missing any information that we require. Can someone point me the right direction on where to learn about this.
View 2 Replies
May 13, 2009
Is there any official notation for private fields? Like mVar, m_var or another notation?
View 10 Replies
Jun 21, 2010
How to code the sqrt, log, sin,cos and tangent buttons please write down the code for the mentioned buttons
View 1 Replies
Sep 18, 2009
I would like to know if Visual Studio does have a setting where you can choose whether it should write nombers like 0.00000127 in scientific notation or not? I am writing such doubles to file but VB2008 writes them in scientific notation. If I treat these numbers as decimals then it writes them correctly, but I also have to take care of performance as I'm writing lots of numbers.
View 1 Replies
Oct 21, 2009
I've got an app that sometimes stores some decently small numbers, such as 0.000023425. These numbers get loaded up in TextBox controls for users to edit.
Dim number As Double = 0.000023425
someTextBox.Text = number.ToString() ' Shows "2.3425E-05"
As mentioned, the text that shows is 2.3425E-05, which isn't exactly intuitive for the user to see, plus I have numbers even more precise (out to 19 decimal places). I would like the output to be fixed point. Of course I could easily and cleanly do:
number.ToString("F20") ' Shows "0.00002342500000000000"
But then there's an annoying number of zeros left over. So, to fix that, I could do:
number.ToString("#,##0.####################") ' Shows "0.000023425"
Which is what I want, but is there any better way to do it than to have that giant ugly format string there? So, ok, it's not that ugly, but surely there's a different way, right? My goal is to show the raw value being stored in the DB in a friendly way, and I would rather not have to force a format on the number at all.I found that changing the underlying datatype to Decimal solves the issue.
Dim number As Decimal = 0.000023425
someTextBox.Text = number.ToString() ' Shows "0.000023425" instead of "2.3425E-05"
So it sounds like Doubles aren't precise enough to be displayed normally?
View 3 Replies
Mar 23, 2011
What would be the best approach in Vb.Net to generate music notation by importing a MusicXML (example below)
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE score-partwise PUBLIC
"-//Recordare//DTD MusicXML 2.0 Partwise//EN"
"[URL]">
<score-partwise version="2.0">
[Code] .....
View 4 Replies
Jun 18, 2009
There is a Select overload that adds an index to each element of a sequence :
[Code]...
Can this query be written in Query Notation ?
View 1 Replies
