View previous topic :: View next topic
|
Author |
Message |
pravinj
New User
Joined: 10 Jun 2008 Posts: 24 Location: india
|
|
|
|
Hi,
I have a requirement. And this goes as,
94 files containing one record each with each file having a different field layout and length. Now the requirement is to reformat the entire fields of a record from all files into a single record(predefined layout).
Is there any way that i could be going on?
Say,
File #1.
ABCD 1234 56 -- length 12 FB
File #2,
EFGHI 67 ZM *&*6G -- length 18 FB
Now the output file should be reformatted as,
1234 EFGHI ABCD ZM 67 56 6G*&*6G |
|
Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
Hi,
are you kidding, do you really expect someone to work out your predefinded layout ? 94 files with each having a different layout ?
Maybe I'm missing something.
Gerry |
|
Back to top |
|
|
pravinj
New User
Joined: 10 Jun 2008 Posts: 24 Location: india
|
|
|
|
Hey! I am just asking you guys the approach that i should be going on!
Because the constraints that i am facing under each design approaches are,
1) Design approach #1: It was to concatenate all files, number the records (each record corresponds to a record from each file) and then based on the sequence number i could extract from position for the input record and move it to predefined location. But this fail, as the input file length differs.
2) So i had to follow on with seperate step for each file, even then i won't be able to place the records from different files on to the same line.
The requirement is like fixing the pieces from different files into a predefined position of an output file(each with their own record length - differs) |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
pravinj wrote: |
But this fail, as the input file length differs. |
Take a look at a potential TOOL approach Here...... |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
I am just asking you guys the approach that i should be going on!
|
Even recommending an approach may be more than we can do with the info provided so far. . . There does not seem to be a "rule" for combining the 2 files shown. I have no idea to approach 92 such files.
Maybe if a better requirement definition is posted we can make more useful suggestions. What are the "rules" for combining data from the multiple files? |
|
Back to top |
|
|
|