[URL] ..to read a CSV file, so lets say I have a large file that looks like this:
[Code]....
How would I add the 10 and 11 together store it then say if that value is not greater than 23 then delete row 2.
I a very large text document, I need to read some lines and at the end of each line, insert a text from the header of each page to he preceding lines.I have the following code the reads the file and displays it on a list box.Public Class Dialogs..[code]
View 2 RepliesI need to fetch numbers one by one from text file, suppose i have a text file with different serial numbers, like;
SHG9001231 SHG9001232
SHG9001233 SHG9001234 SHG9001235
SHG9001236
[code]....
there is no sequence like tab delimited, comma delimited or CL/LF, so it need to search on every prefix series and fetch entire serial number. But i have no clue how to write code in vb.net 2005.
Such as the text file has 5000 lines and 500000 columns. Each line has the format "xxx,yyy,zzz,000,...."
View 39 RepliesI'm having trouble with reading a file from embedded resources.
I'm starting to learn about developing applications for eBay. You can pass queries to eBay in XML format, and receive replies back in the same format.
I have some examples of code to do this. Here's how the sample code loads an xml file, containing the query.
'Get XML Document from Embedded Resources
Dim xmlDoc As New XmlDocument()
Dim current_assembly As Assembly
[Code]....
I can't see any difference between the sample and my attempt.
The Assembly Name and Root Namespace in my project are both set to "Sample," just as in the original.
I've tried things like changing the filename and the namespace, but I still can't get it to work.
i'm having trouble reading a slightly different structured xml file , it looks like :
HTML
<?xml version="1.0" encoding="iso-8859-1" ?>
-<VESSELS>
<vessel MMSI="205416000" TIME="2011-09-01 09:31:16 GMT" LONGITUDE="3.19722"
[Code]....
I do need the different fields like time / lontitude e.d.
Basically what I want to do is open a .txt file that contains numbers and then read the numbers into an array and sort them highest to lowest but I don't know how.
View 3 RepliesI have an application that currently stores PDF files (and others) inside the database as BLOBs. The trouble with this method is that I've now got SQL Server databases in excess of 200 GB! I've finally figured out a way to still enable full-text search without needing to store the PDF files as BLOBs (yay! Adobe's iFilter isn't great.), but I'm having trouble designing the method for a client to get access to the files stored on the server's file system.
I want to place the files in a restricted directory on the server, so I can't simply pass a UNC path to the client and let them open the file from there either in a browser or using Process.Start(filename). I understand how that would work, but if that directory has user access granted, all sorts of security holes open up, right?So, what I'm thinking about is a way to have a SQL Server account that has read/write access to/from the protected file system directory. That way (in my mind), the SQL Server can take a file as it's loaded in through the import client (as a series of byte chunks) and write the file to that area of the filesystem. Then, when a file is requested, the SQL Server can bulk load the file into a varbinary(max) field and do whatever I want with it.
1. How can SQL Server take a stream of bytes and write them to a specified location on its local file system? (This is assuming that I want the import utility to be able to be run on a client machine and not require it to be run on the server itself.)
2. Is there any way to stream a varbinary(max) file to a web page out of SQL? I'm using a lot of PDF files that will have Fast Web View enabled, so if I can stream the bytes to a web page, the user will be able to see the first few pages of the document while the rest is loading. I thought about having the SQL Server read (bulk load) the file from the protected area and write it to an unprotected area just long enough to point a web browser to that location, then wiping the file, but that brings me back to #1 above and would THEN require me to be able to issue a delete command from SQL.
I have a text file pwd.txt comma delimited, I added in project resources, now i want to read,edit and insert in text file.
View 1 RepliesCan I know how to read the text file which has Trade Mark sign in it? Like this one "Unique™"..I tried using System.Text.Encoding.*(all the encoding methods) but it still not working.I know how to read text file. But I don't know how to read the file which include this special character. (Actually this is a CSV file which has been exported out from Excel file.)url...Any other way of reading such special characters text file from VB.Net?????
View 5 RepliesI'm using a background worker to read a XML file and do stuff in a database i get nothing in debugger but when i run it i get this error... how can i find out where and what is wrong? Exception has been thrown by the target of an invocation.
View 6 Repliesit is a normal text file, I would read it then , (This part I got it) print it out to a reciept printer, send insert ascii code to force the printer to cut the recipt.
View 2 RepliesI am having a problem with my program that is desinged to read a 3rd party text file database. I posted previosuly about a problem inserting an item in a new row and the column was expectig a different data type. It appears that sometimes the column is being determined to be of decimal value, I dont understand why. the fields contain information such as
Col1
F123456
CLW-12321 etc....
So my column fills with
123456
12321 the letters just get chopped off
So I added MaxScanRows = 0 to my schema file and that took care of the problem
Except now several of my columns that contain Date Values are coming back
9/24/2010 00:00:00
without the setting MaxScanRows = 0
The date returned 9/24/2010
Here is the code for my schema ini file I am creating:
HTML
Dim fs As New FileStream("Schema.ini", FileMode.Create, FileAccess.Write)
Dim writer As New StreamWriter(fs)
[CODE]............
I have been trying different settings hence the dimmed out lines
Here is the code to fill the datatable:
HTML
[CODE].............
I am thinking that without the MaxScanRows = 0 setting the datatype for Col1 is being incorrectly determined
I am not sure what is happening with other columns that contain date values. Apparently If i use MaxScan Rows=0 all columns are being pulled over as string value which creates numerous problems. If I dont use maxscanrows then all columns appear to be correct except Col21 MLSNUM which is being pulled in as a decimal. Can I change that in the schema file?
I know how to read user input using textbox but it only can read character and numbers. Is it possible that I want to read user input equation?
Example:
User type A+B
User put range of A and B.
1.25<A< 3.56
2.45<B< 9.87
I failed to read the equation using textbox. Is it there are other ways that can use to read equation input A+B?I am using VS2005 and VB.Net. I really new in this programming using VB.Net.
I have a txt file that I need to read into a listview, but I need to read from a specific line in that file. Below is a sample of the txt file to read,
6400,3200,2,95.5,84,76.6,0
1,2,-20,15,0,0,0,"NO",0,0
TOTAL GPM= 6400 HWT= 95.5 CWT= 84.0 IWBT= 76.6 ALTITUDE= 0
CODE]...
way to do the following in VB 2005:
I need to access, but not display, a web page out of a VB 2005 program. The web page would be an aspx page with a query string as part of the url - with the url using values acquired thru the program - e.g. www.mysite.com?arg1=this&arg2=that
So the aspx page would produce an html output with values I need placed in specific elements. I want to read that page from my app and do stuff with the resulting values.
I have created a program that saves the co-ordinates of the users mouse and saves it to a text file to be used as an auto clicker.
View 2 RepliesI'm using vb.net 1.1 to develop the program. I got text files that contain test result from a machine, like below.
T1 1.24535 2.56335 2.43253 1.24538 2.55619 4.35243
T2 1.42542 1.63728 3.57295 4.59275 1.57320 2.72057
T3 5.12857 2.45375 6.38593 2.58375 3.57259 3.57204
I need to check the test result with the data from database, to find out which test result is failed. If there is a fail test result, I will show an alert to the operator and stop the checking process. Until the operator close the alert, then the checking process will continue from the last read point.
I have a number of word documents I am converting. Everything is going great until I get a file that is read only. In this case I get a Save As prompt.
Is there any way to open the file in read/write format? I should have admin privileges so access isn't an issue.
I'm using VB.net to open the files. More specifically
doc = word.Documents.Open(path, Type.Missing, False, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing)
Reading a .txt file in VB.net. My file path is C:UsersMyLilMulePepeDocumentsVisual Studio 2008Projectscurtain_calls.txt.
This is my line of Dim LoanOptionsFile As String = "C:UsersMyLilMulePepeDocumentsVisual Studio 2008Projectscurtain_calls.txt"
I can read the file when I run the program, but how do I write the file path so that someone else can download my program and file and read the file on their system?
I'm trying to make a program that can read .mp3 data (Such as Artist, Album, Year, Track number, etc), but I need to be able to do two things that I have no clue how to do:
1. Read starting from a specified string (E.G, On one line it states: [code]
2. Read until a specified string (E.G, On the previously stated line,I need to read starting from what I said, up until.
i need to read binary file and in this file found the string and replace it with other one and save the file afterwords. I found many example to read binary, but to find and replace is for me mistery.
View 3 RepliesI need to write data to a file, preferably in binary format, but I am unaccustomed with the concept. Where's the easiest place to get the basics? I could come here with a specific need, but I'm at the point right now where I am more willing to work within the confines of keeping it simple.
Here's what I know:
1. how to open a new file
2. how to specify the record length
3. how to close the file
Some specific questions:
Does the record length have to be constant throughout the file?
Can I read the nth record without reading the whole file?
I have a fairly simple XML file that I just want to read the data from.
It has 3 levels, root, main section and items. There are no attributes. I want to go to the first main section by name, then read in all the items. The items all are named the same. I've seen this done before, so it should be ok. No writing will be done. Basically this is a static data file
File looks similar to the following:
CODE:
How can I read Emails in vb.net 2005 (without Using Third Party Control). Please Any idea and source code Give to me.(Any Method)
View 2 Replieswith vb.net 2005 exp
(1) how to read MAC address
(2) what are the fundamentals ( i mean which .dll to import & any cautions to be fallowed)
(3) is the MAC address is the unique id over a network
This is a spin off of my other thread: Write XML using XmlDocument
Now I have it creating an xml file and everything's good, I'm working on the the reading of it now. Here's my current
Try
Dim XmlDoc As New XmlDocument
XmlDoc.Load(m_ImportOpenFile.FileName)
[Code]....
I need a simple app that just reads a cookie from the users cookie folder and then displays that cookie on a form. Now i would like for the form to update everytime the cookie changes but we can get to that.This is not an ASP application just simple VB.the cookie that is being written is called testcookie and the value is 999.what I am having difficulty with is how to find and refrence the cookie from the users desktop.
View 8 RepliesI have SQL 2005 table with columns TypeId(int) & Description(ntext datatype).
The Description column has XML file content as value in the table.
Now i want to read the data into a dataset in VB.Net. How to do it in VB.Net. I am using Winforms and VB.Net in VS 2005.
I have SQL 2005 table with columns TypeId(int) & Description(ntext datatype). The Description column has XML file content as value in the table. Now i want to read the data into a dataset in VB.Net. How to do it in VB.Net. I am using Winforms and VB.Net in VS 2005. Below i have given the xml file content.
<?xml version="1.0" encoding="Windows-1252" ?> - <SummaryPageComponent xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> - <categories>
[Code].....