Text files content handling in Access 2003

1 New Member

I want to extract some information in a text file that is not tab, comma and space separated. The format of the text file is actually unknown.
The problem now is, i want to extract like three lines from each section of the text file content, break the lines into different part and use the broken info to populate an already created table in ms access ( all these should be carried out at a press of a cmd button using VBA code in access or VB code)

uploadRemoteInv entory started at 2006/09/21 <Intel_dub>
USER LABEL : Intel_dub/r01sr1/board#01
Unit type : A21E1
Unit part number : 3AL78832AAAE02
Software part number : --------------
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#02
Unit type : A21E1
Unit part number : 3AL78832AAAE02
Software part number : --------------
Date (00) : 03/03/07
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#03
Unit type : A21E1
Unit part number : 3AL78832AAAE02
Software part number : --------------
Serial number : CL030803249
Date (00) : 03/03/13
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#04
unit type : A21E1
Unit part number : 3AL78832AAAE02
Software part number : --------------
NG INFORMATION
Serial number : CL031100082
Date (00) : 03/03/19
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#05
unit type : A21E1
Unit part number : 3AL78832AAAE02
Software part number : --------------
Serial number : CL031402599
Date (00) : 03/04/07
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#06
Unit type : A21E1
Unit part number : 3AL78832AAAE02
Software part number : --------------
Serial number : CL031100199
Date (00) : 03/03/20
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#07
Unit type : A21E1
Unit part number : 3AL78832AAAE02
Software part number : --------------
Serial number : CL030803614
Date (00) : 03/03/19
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#08
Unit type : A21E1
Unit part number : 3AL78832AAAE02
Software part number : --------------
Serial number : CL031100300
Date (00) : 03/03/22
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#09
Unit type : A21E1
Unit part number : 3AL78832AAAE02
Software part number : --------------
Serial number : CL031100330
Date (00) : 03/03/22
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#10
Unit type : CONGI
Unit part number : 3AL78830AAAH04
Software part number : --------------
Serial number : CL031391468
Date (00) : 03/03/13
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#11
Unit type : SERVICE
Unit part number : 3AL78817AAAF02
Software part number : --------------
Serial number : FA031157589
Date (00) : 03/03/11
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#12
Unit type : CONGI
Unit part number : 3AL78830AAAH04
Software part number : --------------
Serial number : CL031391697
Date (00) : 03/03/14
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#13
Unit type : A21E1
Unit part number : 3AL78832AAAE02
Software part number : --------------
Serial number : CL031100299
Date (00) : 03/03/22
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#14
Unit type : A21E1
Unit part number : 3AL78832AAAF02
Software part number : --------------
Serial number : CL050500668
Date (00) : 05/03/04
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#15
Unit type : A21E1
Unit part number : 3AL78832AAAE02
Software part number : --------------
Serial number : CL031100279
Date (00) : 03/03/22
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#22
Unit type : EQUICO
Unit part number : 3AL78836AAAM02
Software part number : --------------
Serial number : CL030607199
Date (00) : 03/03/06
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#23
Unit type : MATRIXN
Unit part number : 3AL78848BAAH01
Software part number : --------------
Serial number : FA031060552
Date (00) : 03/03/07
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#24
Unit type : P63E1
Unit part number : 3AL79092AAAE02
Software part number : --------------
Serial number : CL030810111
Date (00) : 03/02/21
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#25
Unit type : S-4.1N
Unit part number : 3AL78856BBAB01
Software part number : --------------
Serial number : FA030859487
Date (00) : 03/02/26
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#26
Unit type : S-4.1N
Unit part number : 3AL78856BBAC01
Software part number : --------------
Serial number : FA031157458
Date (00) : 03/03/12
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#27
Unit type : P63E1
Unit part number : 3AL79092AAAE02
Software part number : --------------
Serial number : CL012963743
Date (00) : 02/08/22
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#30
Unit type : P63E1
Unit part number : 3AL79092AAAE02
Software part number : --------------
Serial number : CL014243762
Date (00) : 02/08/22
OPERATOR INVENTORY DATA
----------------------------------------------

Using the information above, i want to create a table in access that will contain 10 or above columns. these colunm are;

1. User Label colunm will contain this info: INTER_LAG_PTO i.e the first set of characters after the ":" and before the first "/" sign
2. ADM Type: Name of the Mahine (to be determined using code)
3. Unit Type: A21E1 (Used to determine name of the machine)
4. Site Name: Name of the site (this will be populated from anoda table called Sites)
5. Rack: r01 (another set of string after the first "/")
6.SubRack: sr01 (another set after the r01)
7.Slot Number: sl22 (another set after the sr01)
8.Port Number: daughter#01(ano ther set after the last"/")
9.Release
10.ANV Part Number: 3AL78848BAAH01

Note, not all the columns will contain information at this time.

This is what i want to achieve in access 2000. Each section (i.e all the contents before the long dashes (-----------------------------------------) sign should be on a row in the table created. This will be done for all the sections in all the txt files.

I hope this is clear enough for now. Pls can anybody help me achieve this.
Thank you.

Oct 11 '06 #1

Subscribe Reply

1700

LifeEquals42

New Member

[quote=Jamad]I want to extract some information in a text file that is not tab, comma and space separated.

Do you need help reading the text file?
Is the format of the file always like this?

USER LABEL : Intel_dub/r01sr1/board#02
Unit type : A21E1
Unit part number : 3AL78832AAAE02
Software part number : --------------
Date (00) : 03/03/07
OPERATOR INVENTORY DATA
----------------------------------------------

USER LABEL : Intel_dub/r01sr1/board#03
Unit type : A21E1
Unit part number : 3AL78832AAAE02
Software part number : --------------
Serial number : CL030803249
Date (00) : 03/03/13
OPERATOR INVENTORY DATA
----------------------------------------------

Oct 11 '06 #2

Similar topics

38519

Getting data from a text file

by: Jean-Marie Delapierre | last post by:

Hi, I have two files in a directory. one called toto.txt with the following content : 1 2 3 4 5

Javascript

5500

Get actual text of error trapped by Form_Error?

by: TC | last post by:

Folks Is there >>ANY<< way to get the actual text of an error that is trapped by the Form_Error event? I mean actual text like: "duplicate record in table XYZ", not template text like: "duplicate record in table |1". I need this for a general purpose error handler. I've tried everything obvious, including err.description, the dbengine.errors collection & so on.

Microsoft Access / VBA

3946

Access 2003 Manuals and Help Files

by: BT Openworld | last post by:

I have just had to upgrade to Access 2003 as Access 97 EMail (SendObject) doesn't work when loaded on Windows XP. I'm finding my way around Access 2003 but my biggest problem is getting information. When I bought Access 1.0 many years ago, I got a paper manual and an excellent help file with all you needed to know. With Access 97 the manual came as a 'Building Applications' document on the CD and I still had the excellent help. With Access...

Microsoft Access / VBA

6245

Creating ACH-style text files from Datasets in C#

by: Todd_M | last post by:

I was wondering what anyone might suggest as "best practice" patterns for streaming out fixed formatted text files with C#? Let's say we get our data in a dataset table and we need to iterate over thousands..potentially tens of thousands of rows to create a properly formatted text file -- like an ACH file, for example. In there you typically have a header, a body block of detail rows and a trailer. (The trailers usually contain sums of the...

C# / C Sharp

1764

Temoprary ASP.NET Files access denied

by: lightcap | last post by:

Server Windows 2003. Created one web site, everything works fine. Copied the content to another folder and created another web site pointing to the copied contecnt for test purposes. Configuration is identical except that the test site has a different IP and some path changes were made in web.config to match the different location. First site still working fine, but test site gets access denied trying to create folders under the Temporary...

ASP.NET

1554

convert text to xml

by: neeraja.ram | last post by:

Hello All, I am just learning XML. I need your help in converting a text file to XML. The text file is not a delimited one for me to do the things easily. for eg. a sample file could be like... First Name : abcd Last Name : xyz

.NET Framework

2689

Access 97 import and export of text and HTML not working

by: Wandering | last post by:

I know you guys are heavy duty coders, while I do ad-hoc analysis, and rarely write code. And, I may be in the wrong groups because this is about an install issue, and I don't think it's a code issue. But ... Office 2000 was on this machine when it was given to me. I don't own it. After installing Office 97, mine, in a different directory, and checking most of it out, I uninstalled Office 2000. Well, it's a lot easier to upgrade than...

Microsoft Access / VBA

11140

Access 2007 Rich Text Deficiencies?

by: Neil | last post by:

I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might know one way or the other whether that was true or not, or could point me to an article or help text that would. What I have seen so far online and in Access 2007 help seems to confirm the above. But that (or at least (b)) seems incredible that it...

Microsoft Access / VBA

7255

How To Rebuild Objects From Text Files?

by: Wayne | last post by:

I've read that one method of repairing a misbehaving database is to save all database objects as text and then rebuild them from the text files. I've used the following code posted by Lyle Fairfield to accomplish the first step: Private Sub SaveObjectsAsText() path = CurrentProject.path & "\ObjectsAsText\" SaveDataAccessPagesAsText SaveFormsAsText SaveReportsAsText

Microsoft Access / VBA

9707

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, 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...

General

10586

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, 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...

C / C++

9161

AI Job Threat for Devs

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...

Career Advice

7622

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

6856

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

5525

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

5658

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4301

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2997

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General