How to split a multiple record file by groups

Question

1.00/5 (1 vote)

See more:

I have a text file that contains multiple records, each record is 1288 bytes in length. Each record is uniquely identified with a special 5 byte code @647.

I am pulling info from different fields in each record, but now I must separate results by the GROUP of records indicated by what's @647.

i.e.:

20120614  12345 Joe Somebody             ...@647 = 1234500000
20120614  65497 Joe's Sister             ...@647 = 1234500000
20120614  89845 Alan Somebody            ...@647 = 5432100000
20120614  56498 Alan's Sister            ...@647 = 5432100000

I want to pull and group all the 12345 records in one place and then group all the 54321 records in another place.

How to I do that in vb6?

Posted 14-Jun-12 12:44pm

vb_newbe

Updated 14-Jun-12 21:00pm

Nikfazan

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 14-Jun-12 18:51pm

What's the problem, actually. And how come you end up with such files? Why would you or somebody create them in first place?
--SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

barneyman · Answer 1 · 2012-06-14T13:26:00

The first thing I'd be inclined to do in situations like this is parse the incoming records into something more useful, xml, if there aren't going to be too many of them, or Access or SQL

That way, you can search/seek over them much easier

Parse them with a RegEx[^], for example, then create an xml doc say ..

XML

<file>
<record num="20120614"" serial="12345" name="Joe Somebody" special="@647" other="12345000" />
...
...
</file>

Then you can use XML and XMLPath[^] to search

In this instance it would be something like \\record[@special='@647']

Just noticed you're using VB6, so those two links are this[^], and this[^], respectively