Hi,
I m doing a file copy from one file1 to file2 and there involves some modifications which need to be done before copy.
FILE1:
123456789,SB,61,99.99,0.0,ABCD
123123123,AP,77,00.00,1.1,UVWX
OUTPUT FILE:
123456789,SETUPBOX,A,100,ABCD
123123123,AIRPLANE,B,200,UVWX
REQUIREMENT:
------------------
First field have to be copied as is. (123456789)
in the second field, If input file is SB, then we need to expand it to SETUPBOX.. else if it is AP, we need to expand it to AIRPLANE in the output field
In the third field, if 61 is there, then we need to change it to A.... if not, then change it B in the output field
In the fourth field is non-zero, we need to populate 100, else we need to send 200 in the output field
Last field have to be copied as is.