Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 07-13-2018, 07:30 AM   #26
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 1,780
Thanks: 34
Thanked 536 Times in 509 Posts
MajP will become famous soon enough MajP will become famous soon enough
Re: Help with text file trim and create 2 tables

Code:
SEGMENT : CLASS1                                            Print Date 04-07-2018 12:40:37     Page       6 of 2000
 MOM ID: 1100       PQR - Test25
 Department Name: DEFAULT NAME1                                           CAT                  ABR120

---------------------------------------------------------------------------------------------------------------------------------
 1                   10          1,000.00  Rej Reason : Sxxxxxxx Ixxxxxx
					   		No Exceptions or Warnings encountered
					   InstXXXXX  Rejected
---------------------------------------------------------------------------------------------------------------------------------
 Total Amount:           2,000.00
 Other Reference Details:                                Axxxxxxx Bxxxxx        Hold Fxxxxx       Unxxxxxx          CA Lxxxx
---------------------------------------------------------------------------------------------------------------------------------
 1234567890123       INR PQR                               1,000.00                0.00               0.00                 0.00
---------------------------------------------------------------------------------------------------------------------------------
This one is worse, and not sure if there is a way around this. This one does not have the header for S_No, Instrument, and amount. What is actually going on with the report here? Is this just a cut and paste error. Looks like a whole section is missing. Does this happen in other places? This would get extremely hard to apply any logic to extract those elements.
MajP is offline   Reply With Quote
 

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Create and open a text file IainMc2013 Modules & VBA 0 04-10-2013 07:38 AM
Create table in access from a text file Helpy Modules & VBA 0 07-21-2009 08:37 AM
Create Recordset and Export to Text File jketcher Modules & VBA 5 07-16-2009 11:48 PM
Create a function from a text file. Dan_T Modules & VBA 16 07-07-2005 09:24 AM
[SOLVED] Need to create text file netforce General 1 01-31-2003 09:20 PM




All times are GMT -8. The time now is 01:06 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World