Merging two text files side by side Post: 302745995

Sponsored Content

Top Forums Shell Programming and Scripting Merging two text files side by side Post 302745995 by joeyg on Tuesday 18th of December 2012 03:02:04 PM

12-18-2012

Registered User

How about...

The following example was done with only one sample file. In your case, you would not re-use filenames -- your paste command would be files __32a and __33 (for instance).

Code:

$ cat sample32.txt
Received message from [https://www.abc.zzz] in [939] milliseconds.
Received message from [https://www.abc.zzz] in [981] milliseconds.
Received message from [https://www.abc.zzz] in [447] milliseconds.
Received message from [https://www.abc.zzz] in [93] milliseconds.
Received message from [https://www.abc.zzz] in [123] milliseconds.
Received message from [https://www.abc.zzz] in [124] milliseconds.
Received message from [https://www.abc.zzz] in [89] milliseconds.
Received message from [https://www.abc.zzz] in [124] milliseconds.
Received message from [https://www.abc.zzz] in [103] milliseconds.
Received message from [https://www.abc.zzz] in [167] milliseconds.
Received message from [https://www.abc.zzz] in [179] milliseconds.
Received message from [https://www.abc.zzz] in [2498] milliseconds.
Received message from [https://www.abc.zzz] in [2505] milliseconds.

$ awk '{printf "%-90s\n",$0}' <sample32.txt >sample32a.txt


$ paste sample32a.txt sample32.txt
Received message from [https://www.abc.zzz] in [939] milliseconds.          Received message from [https://www.abc.zzz] in [939] milliseconds.
Received message from [https://www.abc.zzz] in [981] milliseconds.          Received message from [https://www.abc.zzz] in [981] milliseconds.
Received message from [https://www.abc.zzz] in [447] milliseconds.          Received message from [https://www.abc.zzz] in [447] milliseconds.
Received message from [https://www.abc.zzz] in [93] milliseconds.           Received message from [https://www.abc.zzz] in [93] milliseconds.
Received message from [https://www.abc.zzz] in [123] milliseconds.          Received message from [https://www.abc.zzz] in [123] milliseconds.
Received message from [https://www.abc.zzz] in [124] milliseconds.          Received message from [https://www.abc.zzz] in [124] milliseconds.
Received message from [https://www.abc.zzz] in [89] milliseconds.           Received message from [https://www.abc.zzz] in [89] milliseconds.
Received message from [https://www.abc.zzz] in [124] milliseconds.          Received message from [https://www.abc.zzz] in [124] milliseconds.
Received message from [https://www.abc.zzz] in [103] milliseconds.          Received message from [https://www.abc.zzz] in [103] milliseconds.
Received message from [https://www.abc.zzz] in [167] milliseconds.          Received message from [https://www.abc.zzz] in [167] milliseconds.
Received message from [https://www.abc.zzz] in [179] milliseconds.          Received message from [https://www.abc.zzz] in [179] milliseconds.
Received message from [https://www.abc.zzz] in [2498] milliseconds.         Received message from [https://www.abc.zzz] in [2498] milliseconds.
Received message from [https://www.abc.zzz] in [2505] milliseconds.         Received message from [https://www.abc.zzz] in [2505] milliseconds.

This User Gave Thanks to joeyg For This Post:

joeyg

View Public Profile for joeyg

Find all posts by joeyg

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merge 2 text files to one text file side by side

Inquiring minds want to know.... I need to take two files that I have latitude and longitude values and then combine them into one file with the values side by side separated by a space. the first file is temp113-lat.txt and the second is temp113-lon.txt. They each have values listed in the...

2. Shell Programming and Scripting

Script to place selected columns from a group of files side by side in a new file

Hi Everyone, I need a shell/perl script to bring selected columns from all the files located in a directory and place them in a new file side by side. File1: a b c d 2 3 4 5 f g h i .......... File2: I II III IV w x y z .............. and so on many files are there......

3. Shell Programming and Scripting

How to Merge / combine / join / paste 2 text files side-by-side

I have 2 text files, both have one simple, single column. The 2 files might be the same length, or might not, and if not, it's unknown which one would be longer. For this example, file1 is longer: ---file1 Joe Bob Mary Sally Fred Elmer David ---file2 Tomato House Car...

4. Web Development

Cannot access Apache web server from Wan side, only Lan side.

I have installed WAMPSERVER 2.0 on my windows vista x64 system but still am having issues with getting the webserver to be seen outside my local network. It is working fine within my local network. Been through several setup tutorials so far, no dice still. For testing purposes I have...

5. Shell Programming and Scripting

Paste two file side by side together based on specific pattern match problem

Input file_1: P78811 P40108 O17861 Q6NTW1 P40986 Q6PBK1 P38264 Q6PBK1 Q9CZ49 Q1GZI0 Input file_2:

6. Shell Programming and Scripting

printing 3 files side by side based on similar values in rows

Hi I'm trying to compare 3 or more files based on similar values and outputting them into 3 columns. For example: file1 ABC DEF GHI file2 DEF DER file3 ABC DER The output should come out like this file1 file2 file3 ABC ABC

7. Shell Programming and Scripting

AWK to merge multiple files side by side

I have about 100s of files of type text in a known directory. I want to merge all files side by side. Number of lines in all the files will remain same. For example file1 contains cat dog File 2 contains rat mat Output file should be cat rat dog mat Using awk I was able to...

8. Shell Programming and Scripting

Combining two single column files side-by-side

Hi, I am looking for a sed/awk script to join two large (~300 M) single column files (one is sorted and the other is not sorted) side-by-side. I have a shell script but its taking ages to do the task so looking for an optimized fast solution. The two files look like: File1 (sorted) a1...

9. UNIX for Dummies Questions & Answers

Paste many files together side by side

Hi, Thank you for your help in advance :D. I have thousands of files like... file01 file02 file03 . . . file6324 I would like to paste every other file side by side so it looks like file01 file02 file03 file04 ...e.t.c file6323 file6324

10. Shell Programming and Scripting

Import 2 columns from 8 .csv files into pandas df (side by side) and write a new csv

I have 8 .csv files with 16 columns and "n" rows with no Header. I want to parse each of these .csv and get column and put the data into a new.csv. Once this is done, the new.csv should have 16 columns (2 from each input.csv) and "n" rows. Now, I want to just take the average of Column from...

LEARN ABOUT NETBSD

sleep

SLEEP(1)						    BSD General Commands Manual 						  SLEEP(1)

NAME

     sleep -- suspend execution for an interval of time

SYNOPSIS

     sleep seconds

DESCRIPTION

     The sleep utility suspends execution for a minimum of seconds.  It is usually used to schedule the execution of other commands (see EXAMPLES
     below).

     Note: The NetBSD sleep command will accept and honor a non-integer number of specified seconds.  This is a non-portable extension, and its
     use will nearly guarantee that a shell script will not execute properly on another system.

     When the SIGINFO signal is received, the estimate of the amount of seconds left to sleep is printed on the standard output.

EXIT STATUS

     The sleep utility exits with one of the following values:

     0	   On successful completion, or if the signal SIGALRM was received.

     >0    An error occurred.

EXAMPLES

     To schedule the execution of a command for 1800 seconds later:

	   (sleep 1800; sh command_file >& errors)&

     This incantation would wait half an hour before running the script command_file.  (See the at(1) utility.)

     To reiteratively run a command (with csh(1)):

	   while (1)
		   if (! -r zzz.rawdata) then
			   sleep 300
		   else
			   foreach i (*.rawdata)
				   sleep 70
				   awk -f collapse_data $i >> results
			   end
			   break
		   endif
	   end

     The scenario for a script such as this might be: a program currently running is taking longer than expected to process a series of files, and
     it would be nice to have another program start processing the files created by the first program as soon as it is finished (when zzz.rawdata
     is created).  The script checks every five minutes for the file zzz.rawdata, when the file is found, then another portion processing is done
     courteously by sleeping for 70 seconds in between each awk job.

SEE ALSO

     at(1), nanosleep(2), sleep(3)

STANDARDS

     The sleep command is expected to be IEEE Std 1003.2 (``POSIX.2'') compatible.

BSD
								  August 13, 2011							       BSD

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merge 2 text files to one text file side by side

Discussion started by: ahinkebein

2. Shell Programming and Scripting

Script to place selected columns from a group of files side by side in a new file

Discussion started by: ks_reddy

3. Shell Programming and Scripting

How to Merge / combine / join / paste 2 text files side-by-side

Discussion started by: cajunfries

4. Web Development

Cannot access Apache web server from Wan side, only Lan side.

Discussion started by: davidmanvell