I have used regex to parse a huge text file, and grab a tab delimited
portion of it. I often use comma delimited text files, and use Jet Oledb4.
I read that I would need an ini if the file wasn't comma delimited - if
this is true, I am not sure of the easiest process to create an ini. The
string has a header.
My string looks like:
"Call" "Date" "Time" "Call Period" "From" "Call Type"
"Number Called" "To" "Call Length" "Local Airtime Rate" "Local
Airtime Charges" "Tax" "LD Charges" "LD Tax" "Additional Call
Charges" "Total"
1 11-Nov 07:23 D OTTAWA ON OG 6158365872 TORONTO ON 3:00 $0.10
$0.30 B $0.00 $0.00 $0.30
2 11-Nov 11:36 D INCOMING IN 6157172119 OAK ON 4:00
$0.10 $0.40 B $0.00 $0.00 $0.40
......
Any ideas on the best way to pull this data into a table or dataset?
Thanks,
Joe 3 2439
* Joe Fisherman <jf********@out door--------adventures.com> scripsit: I have used regex to parse a huge text file, and grab a tab delimited portion of it. I often use comma delimited text files, and use Jet Oledb4. I read that I would need an ini if the file wasn't comma delimited - if this is true, I am not sure of the easiest process to create an ini. The string has a header.
Have a look at <http://www.connections trings.com> -> "Text"...
--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet> hi************* **@gmx.at (Herfried K. Wagner [MVP]) wrote in * Joe Fisherman <jf********@out door--------adventures.com> scripsit: I have used regex to parse a huge text file, and grab a tab delimited portion of it. I often use comma delimited text files, and use Jet Oledb4. I read that I would need an ini if the file wasn't comma delimited - if this is true, I am not sure of the easiest process to create an ini. The string has a header.
Have a look at <http://www.connections trings.com> -> "Text"...
Thanks for the tip. The text is in memory in a string - do you think it is
best to save the text to a text file, then import using Jet like this?
Thanks,
Joe
Joe Fisherman <no************ *********@noneo fyourdamnedbizn ess.zoo>
wrote in news:Xn******** *************** **********@216. 196.105.130: hi************* **@gmx.at (Herfried K. Wagner [MVP]) wrote in * Joe Fisherman <jf********@out door--------adventures.com> scripsit: I have used regex to parse a huge text file, and grab a tab delimited portion of it. I often use comma delimited text files, and use Jet Oledb4. I read that I would need an ini if the file wasn't comma delimited - if this is true, I am not sure of the easiest process to create an ini. The string has a header.
Have a look at <http://www.connections trings.com> -> "Text"...
Thanks for the tip. The text is in memory in a string - do you think it is best to save the text to a text file, then import using Jet like this?
I ended up giving up on this route. Saving to a temporary text file, then
reading with JET into a dataset worked fine, but seemed like an awkward way
to do it when the source was already in a string. I used the string split
on the line feed, then a string split on the tab character, then parsed
away.. It looks like it is working fine. Not sure if I did the 'most
efficient' thing.
Joe This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Martin Dieringer |
last post by:
I am trying to split a file by a fixed string.
The file is too large to just read it into a string and split this.
I could probably use a lexer but there maybe anything more simple?
thanks
m.
|
by: argniw |
last post by:
I have a table that looks like this:
Forest Residents
Black Josh
Black Joellen
Black Mary Jane
Brown Gertrude
Brown Josh
Brown Mary Jane
|
by: Yama |
last post by:
Hi,
I am looking to create a report comma delimited on a click of a button.
Explanantion:
1. Get from the database: "SELECT * FROM Customers WHERE Region = 'CA'"
2. Use either DataReader or DataSource
3. Create a button "Export"
4. On ServerClick Event prompt user to save as a text comma delimited file.
|
by: Ed Brown |
last post by:
I'm working on a VB.Net application that needs to do quite a bit of string
pattern matching, and am having problems using the "LIKE" operator to match
the same string twice in the pattern. For example, in the following code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim theString As String
theString = "1234 TEST 5432 TEST ABCD"
If theString Like "*TEST*TEST*" Then...
|
by: Peter |
last post by:
I'm wondering if someone can tell me whether the following set of
regex substitutions is possible. I want to convert parallel legal
citations into single citations. What I mean is, I want to change, e.g.:
"Doremus v. Board of Education of Hawthorne, 342 U.S. 429, 434, 72
S. Ct. 394, 397, 96 L.Ed. 475 (1952)."
into:
"Doremus v. Board of Education of Hawthorne, 342 U.S. 429, 434 (1952)."
| |
by: Avi |
last post by:
I need to create a text file that has the data from the 10 tables in
the database. The number of fields in the tables exceeds 255 and so I
cannot make a new table with all the fields and then export it into a
text file.
Is there any s/w out there I could use? I am not much of a programmer
but I heard I could use VBA to get this done. Any help with the code
will be appreciated.
Thanks
|
by: Fordraiders |
last post by:
vb.net 2003
Office 2003
What I have:
C:\TestData\Input.txt
Text File Pipe Delimited : 4 columns Of data
example:
00001|NO BRAND NAME ASSIGNED|6DU27|M3-.5 X 6 FLAT HD SOCKET CAP SCREW,
CL10.9, ALLOY STEEL
00002|NO BRAND NAME ASSIGNED|6DU28|M3-.5 X 8 FLAT HD SOCKET CAP SCREW,
|
by: tom.hepworth |
last post by:
Hi
I have a problem which I hope someone can help me with because I
really don't even know where to start with it.
I am using Access 2003. I have a delimited text file which contains
about 200,000 lines. There are only 2 fields, Role and ID. The role
field contains many duplicates, out of the 200,000 records I think
there are only 16,000 unique roles.
Role ID
AB_F2S_COST_PLAN_CLK EE1
|
by: wisaunders |
last post by:
the file I'm importing has > 200,000 records
I have one problem:
One of the columns in the .txt file (customerID) has almost all Inetger values except for about 30 records. Those 30 records have one letter in the customerID field (M123456). The field they are going into is VARCHAR(1000) . All of the integers go in correctly but for some reason the cutomerID values that stert with a letter (M123456) are NULL.
Any help? I'm stumped.
...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |