Script To Process Ascii Data
Sep 17, 2009
I found VB to be the easiest and best tool to process ascii data. I have a bunch of them (about 15), each is constructed differently, and I will receive monthly updates. the data is all the US flight navigation systems, like VORs, airports...etc. Some of the files have comments and explanations on top and bottom only, and the rest is heading and data at specific columns. Others are a little trickier, like the data for Jetways, its not continuous data, but it breaks for each jetway to identify it first, then plot the data in rows. What am ultimately trying to do is create a tabular version of some sort of this data to be used in my GIS database. Some of the fields needs to be combined ofcourse, like the latitude and longitude data is given in separate columns, but they need to be combined. I have pasted below a small sample of two different data files. [code]
View 5 Replies
ADVERTISEMENT
Dec 11, 2010
I am using Microsoft.VisualBasic.Fileio.TextFieldParser to parse a CSV file that was created with Excel 2003. The parser is working great with the exception that it is converting extended ascii values to question marks! So if the file content was:
± 3
The TextFieldParser is returning
? 3
I have tried all of the encodings in the System.Text.Encoding package with no luck. I thought I had it with UTF7 but it was dropping other characters like replacing the + sign with a space.
View 2 Replies
May 9, 2011
I'm working on decoding a NMEA sentence that is a compressed 8-bit string. I'm having a very hard time of wrapping my head around the bit manipulation needed to convert this string. If someone could get me started with this it would be great.
Here is the incomming string:
!AIVDM,1,1,,A,14eG;o@034o8sd<L9i:a;WF>062D,0*7D
and here is the expected output:
[code]...
View 10 Replies
Jun 10, 2012
I open the serial port and using a recieved data sub, pull data out of the input buffer.I then place the data on a textbox. Problem is, all I seem to get is "????xx??" of various different lenghts.How can I re-encode the data as ascii?
With SerialPort1
.ParityReplace = &H3B ' replace ";" when parity error occurs
.BaudRate = 9600
.Parity = IO.Ports.Parity.None
[code]....
View 8 Replies
Feb 16, 2010
I have data that has to be collected from my database and sent to a supplier's edi system. The file has to be in ascii format so their system can read it. I am writing what I see as an ascii format file but they say it's in edibc format when they receive it. I am posting my code and hopefully somebody here can help me out. Funny thing is that I have done this before successfully and am using virtually the same code but to no avail!!
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim filed As String = "Y"
' get records to be transmitted and plop them into an array list
Dim con As VICSClaimDAO = New VICSClaimDAOSQL()
[code]....
View 1 Replies
Feb 27, 2012
I was wondering if this code could be better optimized for multithreading. What it does is open a process and loops through the data, there could be any range of files to open (so I would like to have say 2 or 3 processes at once):
[Code]...
View 19 Replies
Oct 12, 2009
I have made an application in VB 6.0.In this application ,i am connecting one controller through serial port to laptop.I have used MSOMM control for this purpose.Controller is sending data as a string .On VB 6.0 applicaton in laptop ,i am getting data displayed in one text boxall in ASCII code/characters.Total chatacters in string are 61.My problem is this that all 61 characters are comming in one text box.I want thateach character should come in seperate text box so that i can be able to display them individually,i.e. 61 characters and 61 text boxes.
View 2 Replies
Jun 18, 2011
If we have a string that contains for example "01_1A" in ascii, I would like to take first two chars and following two chars after mark and send it as hex format, like &H1 and &H1A.
Note that I would not convert ascii to hex. I am asking for something like &H(var).
View 5 Replies
Nov 4, 2009
I would like to pass a whitespace character by using the System.Text.Encoding.ASCII.GetBytes(" "), and System.Text.Encoding.Unicode.GetBytes(" ") , where " " is the whitespace Character required. What do I need to type (" ") to get a whitespace character passed.?
View 6 Replies
Sep 27, 2011
We have the customers credit card number on file which we use simply to identify them when they swipe at our computer. The problem i'm running into is that when they swipe their card in the card reader (Magtek mini usb) it outputs the data as ASCII which looks something like %B followed by the credit card number in whatever textbox i have the program focused on. I'm sure i could just search the textbox for any 16 character number string and assume that is their card number, but i was just curious if there is some best practice to decript the ASCII output from the magnetic card reader.
View 1 Replies
Aug 7, 2009
So I have an ASP.Net (vb.net) application. It has a textbox and the user is pasting text from Microsoft Word into it. So things like the long dash (charcode 150) are coming through as input. Other examples would be the smart quotes or accented characters. In my app I'm encoding them in xml and passing that to the database as an xml parameter to a sql stored procedure. It gets inserted in the database just as the user entered it.
The problem is the app that reads this data doesn't like these characters. So I need to translate them into the lower ascii (7bit I think) character set. How do I do that? How do I determine what encoding they are in so I can do something like the following. And would just requesting the ASCII equivalent translate them intelligently or do I have to write some code for that?
Also maybe it might be easier to solve this problem in the web page to begin with. When you copy the selection of characters from Word it puts several formats in the clipboard. The straight text one is the one I want. Is there a way to have the html textbox get that text when the user pastes into it? Do I have to set the encoding of the web page somehow?
[Code]...
View 4 Replies
Nov 21, 2009
I am using visual basic 2008 and trying to create an application to plot data from text files. I have several data files of various sizes. They have an unknown number of rows and either 2 or 4 columns.I need to put the data into 2 dimensional array, so value(,) becomes either value(lines,3) or value(lines,1) depending on the number of columns.My program needs to be able to count how many columns there are, and redim value(,) appropriately.I have written a piece of code to count the number of lines (rows) in the file using 'While not (EOF(1)) ....' but I'm stuck on how to count the number of columns.I could ask the user to indicate how many columns there are before the file is read, but I would prefer the program to detect the number automatically.
View 1 Replies
Feb 27, 2009
I am developing an app that will import numeric data and export it to various text files using ascii templates. I am basically converting the template file into a single string, replacing application fields in the string with {0}, {1}, etc... and adding the result into an array that is then passed to the String.Format(str_Template, Params()) to provide the final output. I have set it up so the template will use the standard VB.Net formatting syntax.
A simple template example:
{<prt_Mark>:G} {<prt_Qty>:F2} {<prt_Length>:F2} {<prt_Remarks>:G}
[code].....
View 4 Replies
Jul 18, 2009
I need to write an application for receiving data (ascii characters) from microcontroller through the serial port in three separate parts. I've created three RichTextBoxes, but I do not know which commands I need to type. In first textbox I need to receive one byte... next six bytes need to be placed in second text box, and finally last seven bytes need to be placed in third textbox.
View 11 Replies
Jun 4, 2009
I have written a windows service that is meant to launch a notepad when a specific action happens. The problem i have is that even though the service launches notepad, the actual notepad it self is NOT visible. I know that it has been launced because i can see the process in the task manager. By the way the process is listed as a SYSTEM process rather than a process under my user name (i believe that is because my process is a "LocalSystem" one).
View 4 Replies
Dec 4, 2009
I'm receiving a lot of data at the rate of 19200. I'm using read byte to assemble a buffer and process it. When I receive certain data I need to reply to the sender. I noticed that my replies are not fast enough. So I did a test where I unplugged the sender and noticed I was still receiving data! That I found was because the serial port buffer still had data from the sender that I didn't process. Anyhow I'm using Visual Studio 2005, the serial port object. How can I process the data faster. Would something like SerialPort1.ReadExisting or ReadLine work faster?
View 4 Replies
Aug 25, 2009
How do I use for loop in vb.net something like
dim start as integer
Dim customers as New List(Of Customers)
Customers=dataAcess.GetCustomers()[code].....
I want to process some data for each 500 customers..
View 8 Replies
Nov 16, 2011
I retrieve the html from a cross domain web page using asp.net vb
[code]...
Additionally I want show just a portion of it in a literal control. As an example I want to show just the table with the class "result".How do I process this further in XML and XQuery in VB.NET? How do I declare strRequestedHTML as XML and how do I xquery in it?
View 1 Replies
May 6, 2011
In my last information seeking I found the answer on a systemic level.
[URL]
Now, I need to find data on the process level and it is documented in a far sparser manner than I am used to seeing. I dont know if the answer is in psapi.dll or kernel32.dll is. I don't know what approach to take since there is little information.
View 9 Replies
Apr 23, 2011
I am currently creating a Windows App for a handheld device (WM 6.0, CF 2.0, sqlce 3.5) that pulls data from the server only when connected to a dock (all the significant data is maintained/altered on the handheld til it comes back and is docked for a sync with server).The data is similiar something UPS would do in that it manages pickups and dropoffs of items from a location to a location and records the time these "transactions" occurInitially, the handheld has a couple source tables (pickups and dropoffs) and some validation tables. During a given pickup or dropoff, I am trying to figure out the best way to move the data along this multistep process
View 2 Replies
Nov 12, 2010
I need to pass some data to some procedure called with a parralel.invoke, how can I pass data to the procedure?
I need something like:
Sub ProcessData()
For Each myobject In ListOfObject
Parallel.Invoke(AddressOf LoadOneCPU, myobject )
[Code].....
View 1 Replies
Mar 16, 2009
I'm looking for a way to process the text entered into a textbox, before the the focus is lost from the control. Or a way to pass a reference to the control to a function/sub when the control has lost focus. In Access I would be able to use the AfterUpdate event. I have tried the following events, but have not figured out how to get what I want from either of these events:
- TextChanged (tried to capture the Tab key, didn't work)
- Validating (when fired for Text1, the ActiveControl name is Text2 which is the next TextBox control)
View 4 Replies
Jul 29, 2009
I am trying to implement SMPP protocol in vb. I am sucessfull in send and receiving packets using sockets. Now I would like to decentralize the functions of my program. I want to implement two programs one for sending and another for receiving using a single socket. I want to receive data through the same socket that was created in another process(i.e., the first program).
View 1 Replies
Dec 12, 2010
Is there a way to optimize the process of reading data from an harddisk to reduce the time required to get the data?
View 1 Replies
Jun 9, 2010
[Code]...
I'm doing an application where I open a specific process. And after opening that process I need to send data to him like username and password.
[Code]...
View 1 Replies
Jun 10, 2011
i'm having trouble opening a text file to process and order the data in it. When i try to read the first line of characters an error message occurs saying: 'Variable words1 is used before it has been assigned a value.' I dont understand what i am doing wrong when opening the file. Also, I am sorry if this is a rather basic question.
[Code]...
View 2 Replies
Jan 18, 2010
Imports
System.IO
Imports
System.Windows.Forms
Imports
[CODE]...
I don't understand why nothing is being returned from the SQL)
View 3 Replies
Feb 23, 2010
I am iterating processes using the Process class GetProcesses method. I would like to display information formatted similarly to the way the TaskManager displays it. Where to I get the CPU and Mem Usage data that the TaskManager displays?
View 2 Replies
Feb 18, 2011
Moved from Microsoft Developer Network
> Forums Home >
Development Forums >
Windows Debugging
[Code].....
MS has a patch for the OnListChanged event handler issue, even though it seems we have to pay to have access to it. This fix specifically addresses an error message when you press ESC to cancel adding a new row in .NET 2.0: [URL]
FIX: Error message when you try to press ESC to cancel adding a new row to a DataGridView control in the .NET Framework 2.0: "An unhandled exception of type 'System.InvalidOperationException' occurred in System.Windows.Forms.dll"
View 3 Replies
Mar 23, 2012
I want my vb.net dll to get the data sent from c++ project(exe).Can any body help on in what form this void pointer can be sent via pipe. The void pointer corresponds to enums or structures. I have to get this structures/enums on the vb.net dll end. I have mentioned about using pipe. My question is as what type the pointed to data can be send over the pipe so that I can easily handle the received data at the vb.net dll end.
View 1 Replies
