|
View previous topic :: View next topic
|
| Author |
Message |
shakti
New User
Joined: 20 Jan 2004
Posts: 42
|
|
|
|
Hi guys,
My input file looks like as below
1000000013123 rec type-1
500000000000000000abc000000--rec type 5
634345555555555455000000000--rec type 6
700000000005555555568686888--rec type 7
800000065656756557575757575--rec type 8
500000000000000000xyz000000
634345555555555455000000000
700000000005555555568686888
800000065656756557575757575
501100000000000000abc000000
634345555555555455000000000
700000000005555555568686888
800000065656756557575757575
911111111333334444445555555--rec type 9
999999999999999999999999999--dummy record
999999999999999999999999999--dummy record
999999999999999999999999999--dummy record
999999999999999999999999999--dummy record
999999999999999999999999999--dummy record
999999999999999999999999999--dummy record
My output should like this in file 1
If record type is 5 and condition of 'abc' meets and i need to extract all 6, 7, 8 records including 5records. my trailer record should have the records count of this file.
1000000013123
500000000000000000abc000000
634345555555555455000000000
700000000005555555568686888
800000065656756557575757575
501100000000000000abc000000
634345555555555455000000000
700000000005555555568686888
800000065656756557575757575
9 and record count present in this file
More over suppose my total records in this file is 24 i need make it to 30 by adding dummy trailer records 6 times to make it always multiply by 10.
Sakthi |
|
| Back to top |
|
 |
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| 9 and record count present in this file |
Does the count just include the data records ('5's, '6's, '7's, '8's) or does it also include the header record ('1') and trailer records ('9's)?
Please show exactly what this output trailer record record should look like for your example. Does it just have the '9' and the count (in what form?) or must it have some information from the original '9' input record (what information)?
| Quote: |
| More over suppose my total records in this file is 24 i need make it to 30 by adding dummy trailer records 6 times to make it always multiply by 10. |
So you want to add 9...9 records to make the total number of output records a multiple of 10? |
|
| Back to top |
|
|
|
|
