US5778359A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for determining and verifying a file record format based upon file characteristics
Assignee: Wilmington Trust NA
•
Filing: 1996-04-18
•
Granted: 1998-07-07
•
Expires: 2016-04-18
Abstract
Abstract A system and method for automatically determining the file record format and characteristics for a data file of unknown file record format. At least a portion of an unknown file is obtained from a file source, such as a mainframe computer. At least a portion of the file is examined to determine whether the file is EBCDIC or ASCII encoded. File type, including print, card, text or binary, is determined. File headers and trailers are detected and removed. Line delimiters such as carriage return, linefeed or new line characters are detected. Periodic character patterns are searched for, such as a space followed by one or more numeric digits, to determine file record length and contents. Once the file record format is determined, a user may verify and modify the data. This system and method can be used by a data processing system, including a telephony system which accesses data records to determine parties in a database to contact, and automatically dial those parties.
Inventors
- 👤 Robert J. Stent
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-08 11:47
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/10; G06F16/11; G06F16/116; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99944; Y10S707/99945
Claims Analysis
Total Claims: 31
Claim 1
Independent Claim
144 words
A method for determining a file record format for a file of undetermined file record format, said method comprising the steps of: obtaining at least a portion of said file of undetermined file record format, said file of undetermined file record format including a plurality of file records; analyzing said at least a portion of said file of undetermined file record format, for determining at least one file characteristic of said file of undetermined file record format; formatting at least one file record of said plurality of file records in said file of undetermined file record format based upon said at least one file characteristic determined by analyzing said at least a portion of said file of undetermined filed record format; and presenting at least one formatted file record of said plurality of file records to a user, for verifying said file record format.
Claim 2
Independent Claim
144 words
A method for determining a file record format for a file of undetermined file record format, said method comprising the steps of: obtaining at least a portion of said file of undetermined file record format, said file of undetermined file record format including a plurality of file records; analyzing said at least a portion of said file of undetermined file record format, for determining at least one file characteristic of said file of undetermined file record format; formatting at least one file record of said plurality of file records in said file of undetermined file record format based upon said at least one file characteristic determined by analyzing said at least a portion of said file of undetermined filed record format; and presenting at least one formatted file record of said plurality of file records to a user, for verifying said file record format.
Claim 3
Dependent Claim
36 words
The method of claim 1 wherein said at least one file characteristic is selected from the group consisting of: file encoding, file type, presence of file headers and trailers, file record length, and sequential record numbers.
Claim 4
Dependent Claim
33 words
The method of claim 2 wherein said step of determining file encoding of said at least a portion of said file of undetermined file record format includes determining that file encoding is EBCDIC.
Claim 5
Dependent Claim
62 words
The method of claim 3 wherein, upon determining that file encoding of said at least a portion of said file of undetermined file record format is EBCDIC, the step of formatting said at least one file record includes converting file record encoding of said at least a portion of said file of undetermined file record format to an ASCII file encoding format.
Claim 6
Dependent Claim
60 words
The method of claim 2 wherein said step of determining file type of said file of undetermined file record format includes the step of determining that said file type of said at least a portion of said file of undetermined file record format is selected from the group of file types consisting of "binary", "card", "text" and "print" file types.
Claim 7
Dependent Claim
45 words
The method of claim 5 wherein said step of determining said file type of said file of undetermined file record format is one of "binary" includes detecting a lack of characters from the group consisting of carriage return characters, linefeed characters and new line characters.
Claim 8
Dependent Claim
64 words
The method of claim 6 wherein said step of determining said file type of said file of undetermined file record format includes the step of detecting periodic occurrence of characters from the group of characters consisting of carriage return characters, linefeed characters, and new line characters, at periodic sequences of between 72-80 characters; and determining that said file type is a "card" file type.
Claim 9
Dependent Claim
61 words
The method of claim 7 wherein said step of determining said file type of said file of undetermined file record format includes detecting periodic occurrence of characters from the group of characters consisting of carriage return characters, linefeed characters, and new line characters, at periodic sequences of between 128-132 characters; and determining that said file type is a "print" file type.
Claim 10
Dependent Claim
54 words
The method of claim 8 wherein said step of determining said file type of said file of undetermined file record format includes determining that said file type of said file of undetermined file record format is not one of "binary", "card", and "print"; and determining that said file type is a "text" file type.
Claim 11
Dependent Claim
39 words
The method of claim 2 wherein, upon determining the presence of file headers and footers the step of formatting said at least one file record includes removing file headers and footers from said file of undetermined file record format.
Claim 12
Dependent Claim
36 words
The method of claim 10 wherein said step of removing file headers include skipping a predetermined number of characters at the beginning of said at least a portion of said file of undetermined file record format.
Claim 13
Dependent Claim
36 words
The method of claim 10 wherein said step of removing file trailers include skipping a predetermined number of characters at the end of said at least a portion of said file of undetermined file record format.
Claim 14
Dependent Claim
39 words
The method of claim 10 wherein said step of removing file headers and trailers includes: detecting a character string of "HEADER" subsequently followed by a carriage return character; and skipping to a point immediately after said carriage return character.
Claim 15
Dependent Claim
38 words
The method of claim 2 wherein said step of determining file record length of said file of undetermined file record length includes detecting periodic sequences of at least two characters in said file of undetermined file record format.
Claim 16
Dependent Claim
43 words
The method of claim 14 wherein said step of detecting periodic sequences of at least two characters in said file of undetermined file record format includes detecting a periodic repeating sequence of at least one space followed by at least one numeric character.
Claim 17
Dependent Claim
44 words
The method of claim 14 wherein said step of detecting periodic sequences of at least two characters in said file of undetermined file record format includes detecting a periodic repeating sequence of at least one space followed by at least two identical numeric characters.
Claim 18
Dependent Claim
43 words
The method of claim 14 wherein said step of detecting periodic sequences of at least two characters in said file of undetermined file record format includes detecting a periodic repeating sequence of at least one space followed by at least one alphanumeric character.
Claim 19
Dependent Claim
60 words
The method of claim 14 wherein, upon detecting periodic sequences of at least two characters in said file of undetermined file record format, the step of formatting said at least one file record includes partitioning said at least a portion of said file of undetermined file record format into records based on said periodic sequences of at least two characters.
Claim 20
Dependent Claim
51 words
The method of claim 1 further including, after the step of presenting at least one formatted file record of said plurality of file records, the step of: responding to a user verification that said file record format of said at least one formatted file record presented to said user is correct.
Claim 21
Dependent Claim
45 words
The method of claim 19 further including, after the step of responding to a user verification, the step of: formatting all of said plurality of file records of said file of undetermined file record format based on said file record format verified by said user.
Claim 22
Dependent Claim
35 words
The method of claim 19 further including, after the step of responding to a user verification, the step of: storing said at least one file characteristic determined for said file of undetermined file record format.
Claim 23
Dependent Claim
57 words
The method of claim 1 further including, after the step of presenting at least one formatted file record to said user, the steps of: changing said at least one file characteristic to a different file characteristic; and re-formatting said at least one formatted file record of said plurality of file records based upon said different file characteristic.
Claim 24
Independent Claim
187 words
A system for determining a file record format for a file of undetermined file record format, comprising: a file record format decoder, responsive to at least one source of at least one file of undetermined file record format for obtaining at least a portion of a file of undetermined file record format, said file record format decoder performing the steps of: determining character coding of said at least a portion of said file of undetermined file record format; determining file type of said at least a portion of said file of undetermined file record format; removing, if present, headers and trailers in said at least a portion of said file of undetermined file record format; and detecting periodic sequences of at least two characters in said at least a portion of said file of undetermined file record format; partitioning said at least a portion of said file of undetermined file record format into a plurality of records based on said periodic sequences of at least two characters; and outputting said partitioned at least a portion of said file of undetermined file record format to an output device.
Claim 25
Independent Claim
187 words
A system for determining a file record format for a file of undetermined file record format, comprising: a file record format decoder, responsive to at least one source of at least one file of undetermined file record format for obtaining at least a portion of a file of undetermined file record format, said file record format decoder performing the steps of: determining character coding of said at least a portion of said file of undetermined file record format; determining file type of said at least a portion of said file of undetermined file record format; removing, if present, headers and trailers in said at least a portion of said file of undetermined file record format; and detecting periodic sequences of at least two characters in said at least a portion of said file of undetermined file record format; partitioning said at least a portion of said file of undetermined file record format into a plurality of records based on said periodic sequences of at least two characters; and outputting said partitioned at least a portion of said file of undetermined file record format to an output device.
Claim 26
Independent Claim
112 words
A method for determining a file record format for a file of undetermined file record format comprising the steps of: obtaining at least a portion of said file of undetermined file record format; determining character coding of said at least a portion of said file of undetermined file record format; determining a file type of said at least a portion of said file of undetermined file record format; determining whether headers and trailers are present in said at least a portion of said file of undetermined file record format; and detecting periodic sequences of at least two characters in said at least a portion of said file of undetermined file record format.
Claim 27
Independent Claim
112 words
A method for determining a file record format for a file of undetermined file record format comprising the steps of: obtaining at least a portion of said file of undetermined file record format; determining character coding of said at least a portion of said file of undetermined file record format; determining a file type of said at least a portion of said file of undetermined file record format; determining whether headers and trailers are present in said at least a portion of said file of undetermined file record format; and detecting periodic sequences of at least two characters in said at least a portion of said file of undetermined file record format.
Claim 28
Dependent Claim
69 words
The method of claim 24 further including the steps of: formatting at least one file record of said plurality of file records in said file of undetermined file record format based upon said character coding, said file type, said headers and trailers, and said periodic sequences; and presenting at least one formatted file record of said plurality of file records to a user, for verifying said file record format.
Claim 29
Dependent Claim
54 words
The method of claim 25 further including, after the step of presenting at least one formatted file record, the steps of: changing said at least one file characteristic to a different file characteristic; and re-formatting said at least one formatted file record of said plurality of file records based upon said different file characteristic.
Claim 30
Independent Claim
257 words
A method for determining a file record format for a file of undetermined file record format, said file of undetermined file record format including a plurality of file records, said method comprising the steps of: obtaining at least a portion of said file of undetermined file record format; determining character coding of said at least a portion of said file of undetermined file record format, wherein said character coding includes one of EBCDIC and ASCII and, if said character coding is EBCDIC, converting said character coding to ASCII; determining a file type of said at least a portion of said file of undetermined file record format, wherein said file type includes one of binary type, card type, print type, and text type; determining whether headers and trailers are present in said at least a portion of said file of undetermined file record format and, if headers and trailers are present, removing said headers and trailers from said at least a portion of said file of undetermined file record format; determining periodic sequences of at least two characters in said at least a portion of said file of undetermined file record format and, if periodic sequences of at least two characters are determined, partitioning said at least a portion of said file of undetermined file record format based upon said periodic sequences; and presenting said at least a portion of said file of undetermined file record format to a user, for verifying a format of said at least a portion of said file of undetermined file record format.
Claim 31
Independent Claim
257 words
A method for determining a file record format for a file of undetermined file record format, said file of undetermined file record format including a plurality of file records, said method comprising the steps of: obtaining at least a portion of said file of undetermined file record format; determining character coding of said at least a portion of said file of undetermined file record format, wherein said character coding includes one of EBCDIC and ASCII and, if said character coding is EBCDIC, converting said character coding to ASCII; determining a file type of said at least a portion of said file of undetermined file record format, wherein said file type includes one of binary type, card type, print type, and text type; determining whether headers and trailers are present in said at least a portion of said file of undetermined file record format and, if headers and trailers are present, removing said headers and trailers from said at least a portion of said file of undetermined file record format; determining periodic sequences of at least two characters in said at least a portion of said file of undetermined file record format and, if periodic sequences of at least two characters are determined, partitioning said at least a portion of said file of undetermined file record format based upon said periodic sequences; and presenting said at least a portion of said file of undetermined file record format to a user, for verifying a format of said at least a portion of said file of undetermined file record format.
References Cited (Backward Citations)
US4789852A
Cited
US5414834A
Cited
US5301304A
Cited
US5590311A
Cited
US5446896A
Cited
US5410677A
Cited
US5530794A
Cited
US5617432A
Cited
US5608874A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-07-06 | 2002-01-05 | 2002-07-07 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-07-06 | 2006-01-05 | 2006-07-07 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-07-06 | 2010-01-05 | 2010-07-07 | $7700.00 | Window Closed / Lapsed |