View previous topic :: View next topic
|
Author |
Message |
senthilnathanj
New User
Joined: 31 Jul 2007 Posts: 47 Location: chennai
|
|
|
|
Hi,
My Input File:
Code: |
10206 700 JAN 21
10206 700 FEB 8
10206 700 MAR 0
10206 700 APR 66
10206 700 MAY 55
10206 700 JUN 144
11091 700 JAN 204
11091 700 FEB 393
11091 700 MAR 387
11091 700 APR 406
11091 700 MAY 298
11091 700 JUN 368
|
Excepted Output:
Code: |
Outlet_ACN Brand Code JAN FEB MAR APR MAY JUN
10206 700 21 8 66 55 144
11091 700 204 393 387 406 298
|
|
|
Back to top |
|
|
senthilnathanj
New User
Joined: 31 Jul 2007 Posts: 47 Location: chennai
|
|
|
|
Sorry Excepted Output in the below format:
Excepted OutPut:
Code: |
Outlet_ACN Brand Code JAN FEB MAR APR MAY JUN
10206 700 21 8 0 66 55 144
11091 700 204 393 387 406 298 0
|
|
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Senthilnathan J,
Are you expecting only months JAN-JUN in the input/output? |
|
Back to top |
|
|
senthilnathanj
New User
Joined: 31 Jul 2007 Posts: 47 Location: chennai
|
|
|
|
yes,Arunraj. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Looks like the alignment in the sample shown is all messed up.
Could you tell the starting position,length and format of all the fields along with the input/output file attributes. |
|
Back to top |
|
|
|