keeping some of the fields in tab separated file and rearrange the fields

[newbie271]

Hi Php user
I have a tab separated file with variable number of fields. The fields name may be

name age address xxx yyyy zzz www

I want to keep only only some of these fields in specific order. For example I need to keep only those fields with field name (name, age, zzz, address) in this particular order.

what is the best way to do it.
Thanks

[dagon]

the best option is to import it in to a db

[leatherback]

Besides the database option: [man]file[/man] can be used to read the file, each line to an array element. You could then use [man]foreach[/man] to loop through the array, [man]explode[/man] to split the line in pieces and then you can use the array index to grab the columns you need.