10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. UNIX for Dummies Questions & Answers
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 (3 Replies)
Discussion started by: shaz1990
3 Replies
3. Shell Programming and Scripting
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
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
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
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
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... (15 Replies)
Discussion started by: ahinkebein
15 Replies
10. Shell Programming and Scripting
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
xlhtml(1) General Commands Manual xlhtml(1)
NAME
xlhtml - A program for converting Microsoft Excel Files .xls
SYNOPSIS
xlhtml [-a] [-asc] [-csv] [-xml] [-bcNNNNNN] [-bi/path] [-c] [-dp] [-v] [-fw] [-m] [-nc] [-nh] [-tcNNNNNN] [-te] [-xc:N-N] [-xp:N] [-xr:N-
N] FILE
DESCRIPTION
This manual page explains the xlhtml program. The program xlhtml is used to convert Microsoft Excel Spreadsheet files into either html or
tab delimitted ASCII. The program can be interfaced with helper scripts for viewing email attachments. Most use of this program is through
the helper scripts and one would probably rarely resort to using the commandline interface.
OPTIONS
-a aggressively optimize html by removing </TR> </TD> or VALIGN="bottom". Some older browsers may not display properly in this mode.
-asc Ascii out of -dp and extraction data (-xc, -xp, -xr)
-csv Output in Comma Separated Values of -dp and extraction data (-xc, -xp, -xr)
-xml Output in XML of -dp and extraction data (-xc, -xp, -xr)
-bc Override the background color. e.g. -bc808080 for gray
-bi Use background image. e.g. -bi/home/httpd/icon/tar.gif
-c Centers the tables horizontally
-dp Dump page count and max columns and rows per page
-v Prints program version
-fw suppress formula warnings about accuracy
-m No encoding for multibyte
-nc tells it not to colorize the output.
-nh Suppress header and body tags in html output
-tc Override the text color. e.g. -tcFF0000 for red
-te Trims empty rows & columns at the edges of a worksheet
-xc Columns (separated by a dash) for extraction (zero based)
-xp Page for extraction (zero based), one page only
-xr Rows (separated by a dash) to be extracted (zero based)
An example of the extraction command line is: xlhtml -fw -asc -xp:0 -xr:2-6 -xc:0-1 Test.xls
The extraction output is: Formatted output of cells by column left to right, columns separated by a tab, end of row is: 0x0A, end of file:
AUTHOR
Steve Grubb, Charles N Wyble
xlhtml May 15, 2002 xlhtml(1)