Hello friends!
Here is the scenario.
I have a flat file named FILE1.TXT with multiple columns and comma as delimiter.
Now my task is to create another file called FILE2.TXT which contains the FIRST & THIRD column values from FILE1.TXT separated by comma.
Which mean i am creating a new files with only two columns which are 1st and 3rd. Ex:
FILE1.TXT
1,2,3,4,5,6,7,8,9
1,2,3,4,5,6,7,8,9
1,2,3,4,5,6,7,8,9
1,2,3,4,5,6,7,8,9
1,2,3,4,5,6,7,8,9
Now after creating another file FILE2.TXT it should look like this:
FILE2.TXT
1,3
1,3
1,3
1,3
1,3
Using Unix create a script for this. Please help me out as this is very urgent. I would be very grateful to you people.