note Anonymous Monk <p> CSV manipulation is the most popular of FAQs everywhere. An answer might use [mod://Text::CSV] or [mod://Text::xSV] <p> Examples at <ul> <li> [id://964028|Merge two files with similar column entries] <li> [id://950649|Opening multiple files] ( [id://950679|csvpaste.pl] ) <li> [id://903477|Open multiple file handles?] <li> [id://903867|X, Y Table structure] <li> [id://966813|How to extract the particular residues from PDB files(text csv split hash bioperl)] <li> [id://960394|Select only desired features from a text (text csv split hash bioperl)] <li> [id://965790|Sort on Table headers (text csv split hash bioperl)] <li> [id://932512|I need help joining tab-delimited files/tables!] <li> [id://973890|split then join based on common value in field] <li> [id://974564|Smart way to read a file vertically?] <li> [id://924257|reformatting tab delimited file] <li> [id://977784|edit a CSV and "in-place" replacement] <li> [id://833682|Re: Reversing a mysql table], [id://833682|transpose-tsv -- invert a tab-delimited table] </ul> 997845 997845 13