Sponsored Content
Top Forums Shell Programming and Scripting Merge 2 text files to one text file side by side Post 302283906 by ahinkebein on Wednesday 4th of February 2009 10:07:29 AM
Old 02-04-2009
RedHat

Linux 2.6.18-92.1.22.el5 #1 SMP Fri Dec 5 09:29:46 EST 2008 i686 i686 i386 GNU/Linux

Here is the O/S and I am using a bash shell.

I tried what you are speaking of and i still get the same result. It is ignoring the first file and only outputting the second file. example below\

[67807 loc]$ paste -d ' ' temp113-lat.txt temp113-lon.txt > 113latlon2.txt
[67807 loc]$ cat 113latlon2.txt
5105.471900
5105.626300
5104.146495
5104.146495
5104.146495
5103.428400
5103.305700
5103.446300

[67807 loc]$ paste -d " " temp113-lat.txt temp113-lon.txt > 113latlon4.txt
[67807 loc]$ cat 113latlon4.txt
5105.471900
5105.626300
5104.146495
5104.146495
5104.146495
5103.428400
5103.305700

I am still getting the leading space as the delimiter but it is not reading the first file. but if I do it this way....

[67807 loc]$ paste temp113-lat.txt temp113-lon.txt > 113latlon5
[67807 loc]$ cat 113latlon5
2645.0805105.471900
2644.5485105.626300
2643.7325104.146495
2643.7325104.146495
2643.7325104.146495
2644.9895103.428400
2645.7915103.305700
2647.3585103.446300

I get both files and some of the first has been cut off. So I know it can read the file it just does not want to do it how I want. I am about to let this go and look for a work around on this problem. Is there any other way of doing this?

Thanks also to everyone who has posted help for this issue I appreciate such hospitality from the Unix.com community.

Last edited by ahinkebein; 02-04-2009 at 11:14 AM.. Reason: Update
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to Merge Two .xls files side by side into a single .xls

Hi all, please help me out in below requirement. I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side Ex: abc.xls Eno Ename 101 hello 102 hero 103 india bbc.xls Eno Ename 201 delhi 202 Hyd 203... (0 Replies)
Discussion started by: jagadish99
0 Replies

2. Shell Programming and Scripting

How to Merge Two .xls files side by side into a single .xls

Hi all, please help me out in below requirement. I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side Ex: abc.xls bbc.xls Eno Ename Eno Ename 101 hello ... (2 Replies)
Discussion started by: jagadish99
2 Replies

3. Shell Programming and Scripting

Merge 3 columns side by side

I know this is a stupid question for you guys! half day googling and i got nothing :( i have 3 variables/files, say: $X1 or file1: # there is one whitespace space after each line | 21 | 9 | 28 | 100 | 51 $X2 or file2: # there is one whitespace space... (7 Replies)
Discussion started by: amaulana
7 Replies

4. 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...... (8 Replies)
Discussion started by: ks_reddy
8 Replies

5. 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... (3 Replies)
Discussion started by: cajunfries
3 Replies

6. 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 Replies)
Discussion started by: patrick87
6 Replies

7. 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 (4 Replies)
Discussion started by: zerofire123
4 Replies

8. 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... (5 Replies)
Discussion started by: kanthrajgowda
5 Replies

9. 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... (1 Reply)
Discussion started by: sajal.bhatia
1 Replies

10. Shell Programming and Scripting

Merging two text files side by side

Hi everyone, I need to merge two files side by side The files look something like this: HOSTNAME fishtornado-K52F 127.0.1.1 UPTIME 20:17:01 up 2:19, 3 users, load average: 0.00, 0.04, 0.05 DISK USAGE (Size/Used/Avail/Use%) 29G 6.5G 21G 25% RUN QUEUE PID COMMAND USER ... (4 Replies)
Discussion started by: FishTornado
4 Replies
ISALNUM_L(3)						   BSD Library Functions Manual 					      ISALNUM_L(3)

NAME
isalnum_l, isalpha_l, isblank_l, iscntrl_l, isdigit_l, isgraph_l, ishexnumber_l, isideogram_l, islower_l, isnumber_l, isphonogram_l, isprint_l, ispunct_l, isrune_l, isspace_l, isspecial_l, isupper_l, isxdigit_l -- character classification utilities LIBRARY
Standard C Library (libc, -lc) SYNOPSIS
#include <wctype.h> #include <xlocale.h> int isalnum_l(int c, locale_t loc); int isalpha_l(int c, locale_t loc); int isblank_l(int c, locale_t loc); int iscntrl_l(int c, locale_t loc); int isdigit_l(int c, locale_t loc); int isgraph_l(int c, locale_t loc); int ishexnumber_l(int c, locale_t loc); int isideogram_l(int c, locale_t loc); int islower_l(int c, locale_t loc); int isnumber_l(int c, locale_t loc); int isphonogram_l(int c, locale_t loc); int isprint_l(int c, locale_t loc); int ispunct_l(int c, locale_t loc); int isrune_l(int c, locale_t loc); int isspace_l(int c, locale_t loc); int isspecial_l(int c, locale_t loc); int isupper_l(int c, locale_t loc); int isxdigit_l(int c, locale_t loc); DESCRIPTION
These functions are extended locale versions of the corresponding functions, with the _l removed. Also, see xlocale(3) for more information about extended locales. SEE ALSO
isalnum(3), isalpha(3), isblank(3), iscntrl(3), isdigit(3), isgraph(3), ishexnumber(3), isideogram(3), islower(3), isnumber(3), isphonogram(3), isprint(3), ispunct(3), isrune(3), isspace(3), isspecial(3), isupper(3), isxdigit(3), xlocale(3) BSD
March 11, 2005 BSD
All times are GMT -4. The time now is 09:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy