Selecting only specific columns from a file in unix

ray.wurlod · Post by **ray.wurlod** » Fri Sep 04, 2009 3:08 pm

You CAN omit fields as you read. Use the Drop on Input property in the extended column definition.

chulett · Post by **chulett** » Fri Sep 04, 2009 3:17 pm

Well... that's a little misleading. They are still read, they're just not propagated downstream. Dropping them after input is not the same as not reading them at all, which is how I interpreted the OP's quest. Besides, you still have to fully specify them in the input data, something else the OP is trying to avoid.

laknar · Post by **laknar** » Fri Sep 04, 2009 11:13 pm

Read all the columns from file and then map only the columns that you want in transformer stage.

rajesh450 · Post by **rajesh450** » Wed Nov 18, 2009 10:33 am

you can use below unix command in sequential file stage

cut -d"," f1,f2 <filename>
where f1&f2 are filed names

Sreenivasulu · Post by **Sreenivasulu** » Wed Nov 18, 2009 10:36 am

Hi,

'cut' command is a useful awk command to do this selective stuff

regards
Sreeni