Search : in
By :

Append columns from several files?

stan barr, on Sep 25, 2009 7:54:31 am BST 
 Report this message to moderators

Hello,

i have 300+ text files in which there are two or three columns (separated by Tab) and i need to get all these columns in a single excel spreadsheet, and I don't want to import each file in excel and then copy/paste the columns in a single sheet. that would obviously take me ages

How can i make this process a bit automatic?

Is there a way to append all text files in a single text file with all the columns? any script? (I can use Linux or windows)

Thanks for any help or idea...

Configuration: Windows XP / RHEL 5
Firefox 3.5.3

Best answers for « append columns from several files? » in :
Assembling multiple PDF files Show Assembling multiple PDF files Intro Steps: Intro PDF creator is a software allowing you to print several files into one with its printer function. Download link http://en.kioskea.net/telecharger/telecharger-40-pdf...
DV files divided into several files Show DV files divided into several files It is good to know that the fat32 file system which however cannot handle files larger than 4GB may split a digital video in DV format into several files. A plausible and right solution to...
Renaming multiple files in batch Show Renaming multiple files in batch Native features Using a third-party program Renaming a large number of files can quickly become tedious. Fortunately, there are tools to automate this task in many cases: Native features On Windows...
[Linux]Cutting a file into several parts Show[Linux]Cutting a file into several parts Linux is full of utility tools allowing you to manipulate files. There is a very handy tool to split a file into several parts (for example to carry data on low capacity media). The split...
Transforming columns into lines ShowTransforming columns into lines Example Limitations It is endemic for most Linux tools to work with lines, but not with columns (sed, awk, grep, etc..). However, it may happens,that you have a file where the data should be read in...
[Sed] Delete one or more lines from a file Show[Sed] Delete one or more lines from a file Removing one (or several) line (s) of a file Syntax: sed '{[/]||[/]}d' sed '{[/][,][/]d' /.../=delimiters n = line number...
Download Multiple File Search and Replace Show
Download Join (Merge) Text Files Software ShowDescription The application is designed by Sobolsoft. Simple and easy to use, the application has been awarded from various places. Join Text Files a tool that enables you to merge several files. It allows you to merge multiple text files into a...
Download Web File Transfer ShowAs its name suggests, Web File transfer is utility for file transfer. This web based program simplifies the process of sending and receiving files over the internet. It allows you: - to download several files with the suitable manager, - to...
File formats and extensions Show
File sharing in Windows XP ShowAdvantages File sharing involves making the content of one or more directories available through the network. All Windows systems have standard devices making it easy to share the content of a directory. However, file sharing may lead to security...
Linux - User management ShowFirst step for the administrator When several people have access to a system, the administrator must manage the users. To do so, he must know the common commands and files to be configured. The important files are: the /etc/passwd file the...
Ask your question Reply
They need your help