Hello,
Is there some class among the thousands of .Net classes, that would do the
tab-delimited text data parsing into, say, jagged array (an array of
arrays). I have some code sources in other languages, that I am ready to
recode, but there's no need to do that, if .Net has it built-in. Mind, that
the task is not as simple as it sounds, there are tricky parts like data
cells that contain the characters used for delimiting fields (i.e., tabs),
or records (i.e., CR+LF), those must be enclosed by text delimiters. Thus,
generic split+split is not a solution.
Thanks,
Pavils
2  1767 
Hi,
You can use the OleDbConnection http://www.able-consulting.com/MDAC/...crosoftJetText
or ODBC connection http://www.able-consulting.com/MDAC/...CDriverForText
to accomplish your goal.
Cheers!
Marcin
PS: Personaly not tested! Hello,
Is there some class among the thousands of .Net classes, that would do the
tab-delimited text data parsing into, say, jagged array (an array of
arrays). I have some code sources in other languages, that I am ready to
recode, but there's no need to do that, if .Net has it built-in. Mind, that
the task is not as simple as it sounds, there are tricky parts like data
cells that contain the characters used for delimiting fields (i.e., tabs),
or records (i.e., CR+LF), those must be enclosed by text delimiters. Thus,
generic split+split is not a solution.
Thanks,
Pavils
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Gerrit Holl |
last post by:
Posted with permission from the author.
I have some comments on this PEP, see the (coming) followup to this message.
PEP: 321
Title: Date/Time Parsing and Formatting
Version: $Revision: 1.3 $...
|
by: meldrape |
last post by:
Hello,
I need to parse a long string into no more than 30
character chunks, but I also need to leave the words
intact. Right now, I am using:
For intStart = 1 to Len(strOriginal) by 30...
|
by: George |
last post by:
How can I parse an HTML file and collect only that the A tags. I have a
start for the code but an unable to figure out how to finish the code.
HTML_parse gets the data from the URL document. Thanks...
|
by: JMCN |
last post by:
does anyone know how to take out {enter} strings from a field?
for instance, i have:
"INTWEST ADJUSTMENT
ORG ILLINOIS FUND PARTICIPANT DIVIDEND".
i managed to take out extra spaces but then it...
|
by: yk |
last post by:
I am setting up a simple hotel reservation application which have two dates,
i.e. CheckIn and CheckOut. I would like to construct a graph based on a
crosstab query. Therefore, I need to have...
|
by: pbd22 |
last post by:
hi.
i keep getting this error.
as i understand it, my xml isn't formatted correctly.
the online errata suggests the standard formatting
to solve this problem:
element
(tab) (tab) element
|
by: kumarboston |
last post by:
Hi all,
I have two files resultset.csv and sws.lst. Content of two files:
resultset.csv has 5 columns(array index: 0,1,2,3,4)
sws.lst has 8 columns(array index: 0...7)
resultset.csv is small...
|
by: shakefu |
last post by:
I'm new to python and I was wondering if there are any intelligent
date/time parsing modules out there. I've looked at strptime (or
whichever it is) and mxDateTime from the eGenix package. I need...
|
by: pereges |
last post by:
Hi I've a string input and I have to parse it in such a way that that
there can be only white space till a digit is reached and once a digit
is reached, there can be only digits or white space till...
|
by: len |
last post by:
I have created the following program to read a text file which happens
to be a cobol filed definition. The program then outputs to a file
what is essentially a file which is a list definition...
|
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,...
|
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...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
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...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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,...
| |
