12-03-2010
Merge two cells in excel via UNIX?
Hi UNIX Gods!
Is it possible to merge two cells in .csv file using unix commands?
Imagine that this is my present csv file opened via excel:
Gate Reports| |
fatal alerts | 200 |
is is possible to make it look like this using unix?
Gate Reports |
fatal alerts | 200 |
Thanks for reading and please do help me!
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi, My client uploads an Excel file on to Unix server by using web application with more than 20 columns and more than 60000 records in it. I have to check the data in each cell when the file arrived. Is is possible to check the data in cells by running unix script? or Is there any way to convert... (2 Replies)
Discussion started by: sireeshp
2 Replies
2. Shell Programming and Scripting
Hi
I have a data file in UNIX as follows. I need to send this file in Mail as excel format. but the problem i face is i get the data all in single cells per row. what can i do to get the data in seperate cells.
File -> attachment.xls
data data data data
data1 data1 ... (1 Reply)
Discussion started by: vj8436
1 Replies
3. Shell Programming and Scripting
Hi
I have 2 csv files which looks like the following and i have to compare the 2 CSVs and create a third file such that if the value of the 1st cell in A.CSV and the value of the first cell in the B.CSV are same, it should print "SAME" in the third file or else print NOT SAME. Likewise i need... (19 Replies)
Discussion started by: meva
19 Replies
4. Programming
Dear Folks,
Is there anyone know how to do the group and ungroup cells feature of MS Excel through java.
Please help.
Please find the attachment.I want the code to do something like this. (0 Replies)
Discussion started by: dinesh1985
0 Replies
5. Shell Programming and Scripting
Hi Guys,
I am creating a comma separated file by quering the table and routing it to a file with an extension .xls.
I am using the mailx command to send the .xls file to windows mail box.
The file is coming as a excel attachment, but the cells are not expanded.
Is there a way by which... (4 Replies)
Discussion started by: mac4rfree
4 Replies
6. Shell Programming and Scripting
Hii
I have these files , and I want to merge them in an excel file
each file have two columns
file1
title1
1 1
2 2
3 3
file2
title2
5 5
6 6
7 7
8 8
9 9 (10 Replies)
Discussion started by: maryre89
10 Replies
7. Shell Programming and Scripting
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
I am creating an XLS using unix which fetches the data from database.
In the first row i have 2 columns which i want to merge. Is it possible to merge the columns using unix command?
Thanks,
Sashanka (1 Reply)
Discussion started by: Sashanka_545
1 Replies
9. Programming
Perl script to merge cells
---------- Post updated at 12:59 AM ---------- Previous update was at 12:54 AM ----------
I am using below code to read files from a dir and print to excel.
open(my $in, '<', $file) or die "Could not open file: $!";
my $rowCount = 0;
my $colCount = 0;... (11 Replies)
Discussion started by: Jack_Bruce
11 Replies
10. UNIX for Beginners Questions & Answers
Hello All,
I have visited many pages in Unix.com and could find out one solution for merging the HTML cells in the 1st row.
(Unable to post the complete URL as I should not as per website rules).
But, however I try, I couldn't achieve this merging to happen for all other rows of HTML... (17 Replies)
Discussion started by: Mounika
17 Replies
LEARN ABOUT OSX
ncurses5.4-config
ncurses5.4-config(1) BSD General Commands Manual ncurses5.4-config(1)
NAME
ncurses5.4-config -- report configuration and linking information for ncurses
SYNOPSIS
ncurses5.4-config {--prefix | --exex-prefix | --cflags | --libs | --version | --abi-version | --mouse-version | --bindir | --datadir | --lib-
dir | --mandir | --terminfo | --terminfo-dirs | --termpath }
DESCRIPTION
The ncurses5.4-config utility reports ncurses configuration and linking information.
The options are as follows:
---prefix
Reports package-prefix ncurses5.4-config was installed with
---exec-prefix
Reports executable-prefix ncurses5.4-config was installed with
---cflags
Reports C compiler flags needed to compile with ncurses
---libs
Reports libraries needed to link with ncurses
---version
Reports release+patchdate version ncurses5.4-config was installed with
---abi-version
Reports ABI version ncurses5.4-config was installed with
---mouse-version
Reports mouse-interface version ncurses5.4-config was installed with
---bindir
Reports directory containing ncurses5.4-config programs
---datadir
Reports directory containing ncurses5.4-config data
---libdir
Reports directory containing ncurses5.4-config libraries
---mandir
Reports directory containing ncurses5.4-config manpages
---terminfo
Reports $TERMINFO terminfo database path
---terminfo-dirs
Reports $TERMINFO_DIRS directory list
---termpath
Reports $TERMPATH termcap list
EXIT STATUS
The ncurses5.4-config utility exits 0 on success, and >0 if an error occurs.
BSD
January 13, 2009 BSD