Reading complex Data from a file

Blue man

Hello
I have a data file like this :
01 "" "09:04" "PLMDX " 3.20 0.35 1.74 0.23 2.49 0.17
1.37 0.18 03
02 "" "09:05" "PLMDX " 3.70 0.18 1.93 0.14 2.75 0.19
1.05 0.01 03
03...
04...
......
and i want to read each number and fileds and save it to variables to save
it in to the database .
with stream reader and file rader i can only read all of it as a single
string , is that possible to do it with regular expression ? i don't know
how . any idea ...
help please

Nov 15 '05 #1

Subscribe Post Reply

2214

Chad Myers

"Blue man" <fa**********@yahoo.co.uk> wrote in message
news:e5**************@TK2MSFTNGP10.phx.gbl...

Hello
I have a data file like this :
01 "" "09:04" "PLMDX " 3.20 0.35 1.74 0.23 2.49 0.17 1.37 0.18 03
02 "" "09:05" "PLMDX " 3.70 0.18 1.93 0.14 2.75 0.19 1.05 0.01 03
03...
04...
.....
and i want to read each number and fileds and save it to variables to save it in to the database .
with stream reader and file rader i can only read all of it as a single string , is that possible to do it with regular expression ? i don't know how . any idea ...
help please

Can't you use the ReadLine() method of StreamReader? It looks like
everything is on a row-by-row, line-by-line basis.

Once you have a line, then you can use a Regex to split it.
Unfortunately String.Split() won't work because of the quotes.

-c

Nov 15 '05 #2

Similar topics

Reading data in lists: Error

by: Satish Chimakurthi | last post by:

Hi all, This is in continuation of my email today regarding reading data files. I am stuck with one more problem now. Here are my two data files: a. fluid_grid.dat 1.00000000000000 ...

Python

operator[] and different behaviour for reading and writing

by: Mark Stijnman | last post by:

A while ago I posted a question about how to get operator behave differently for reading and writing. I basically wanted to make a vector that can be queried about whether it is modified recently...

C / C++

reading complex xml file

by: davis | last post by:

ok I am new to xml and probably will use .net. my problem is I would like to read the xml file into a dataset, making it easy to navigate the data. however, my 1st xml file is simply too complex...

.NET Framework

116

Security - more complex than I thought

by: Mike MacSween | last post by:

S**t for brains strikes again! Why did I do that? When I met the clients and at some point they vaguely asked whether eventually would it be possible to have some people who could read the data...

Microsoft Access / VBA

UI Metaphors for complex criteria selection

by: Steve Jorgensen | last post by:

Mailing List management is a good example of a case where my conundrum arises. Say there is a m-m relationship between parties and groups - anyone can be a member of any combintation of groups. ...

Microsoft Access / VBA

Reading and updating XML Files

by: scorpion74 | last post by:

Hi All I am developing a very complex application that hosts UserControl in IE Browser.Usercontrol has treeview and datagrid control basically.The data is in xml file and which is hierarchical...

ASP.NET

reading XML files from codebehind file

by: Martin Eyles | last post by:

Hi, I have a configuration file I made in xml which I am using to name a database server. (this way I can deploy my web page on various servers, and just change this file to make it work)....

ASP.NET

Reading a COMPLEX CONTENT : Stan Can you help?

by: Ganesh Muthuvelu | last post by:

Hi STAN, Stan: Thanks for your response to my previous post on reading a XSD file using your article in "https://blogs.msdn.com/stan_kitsis/archive/2005/08/06/448572.aspx". it works quite well...

.NET Framework

reading text file

by: John | last post by:

How can I tell if a line begins with a number instead of a character? I need to read a text file and some of the data begins with a character which is causing me an issue in reading and uploading...

ASP.NET

Reading Excel sheet into DB Table

by: dba123 | last post by:

I need some help and direction on what classes and an example or two (article) on how to read an Excel Worksheet and insert one column into a database table column. I am using .NET 2.0 only. What...

C# / C Sharp

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing