10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I have three files with similar pattern i need to merge all the coloumns side by side from all three files according to the first coloumn example as shown below
I mentioned 5 coloumns only in example but i have around 15 coloumns in each file.
file1:
Name,Samples,Error,95RT,90RT... (4 Replies)
Discussion started by: Raghuram717
4 Replies
2. 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
3. UNIX for Dummies Questions & Answers
Hi all,
I have two separate csv files(comma delimited) file 1 and file 2.
File 1 contains
PAN,NAME,Salary
AAAAA5467D,Raj,50000
AAFAC5467D,Ram,60000
BDCFA5677D,Kumar,90000
File 2 contains
PAN,NAME,Dept,Salary
ASDFG6756T,Karthik,ABC,450000
QWERT8765Y,JAX,CDR,780000... (5 Replies)
Discussion started by: Nivas
5 Replies
4. Shell Programming and Scripting
I have lot of csv file collected from script like below :
Name of files (some examples) there are thousands of it:
192.168.0.123_251_18796_1433144473.csv
192.168.0.123_251_18796_1433144772.csv
192.168.0.123_251_18796_1433145073.csv
192.168.0.123_251_18796_1433145372.csvContent of each... (5 Replies)
Discussion started by: rk4k
5 Replies
5. Shell Programming and Scripting
I have requirement to write two CSV files to one single excel with multiple sheets.
Data present in the two files should sit in excel as different sheets.
How can we achieve this using shell script?
1.csv 2. csv
1,2,3,4 5,6,7,8
XXXXX YYYYY
Res.excel
1.csv data... (1 Reply)
Discussion started by: duplicate
1 Replies
6. Shell Programming and Scripting
Hi,
I have one requirement, create separate files (".csv") from one excel file(xlsx) with multiple sheets. These ".csv" files are my source files. So anybody please suggest me the process.
Thanks in Advance.
Regards,
Harris (3 Replies)
Discussion started by: harris
3 Replies
7. Shell Programming and Scripting
Help in writing a script using sed which updates fileOne with the contents from fileTwo
Example:
Contents of fileOne
1,111111
2,897823
3,235473
4,222222
Contents of fileTwo
1,111111,A,1,2
4,222222,A,2,2
5,374632,A,3,2
6,374654,A,4,2
Final File should be:
1,111111,A,1,2... (9 Replies)
Discussion started by: NewToSed
9 Replies
8. Shell Programming and Scripting
I have 2 files pipe delimted and want to merge them based on a key
e.g file 1
123$aaa$yyy$zzz
345$xab$yzy$zyz
456$sss$ttt$foo
799$aaa$ggg$dee
file 2
123$hhh
345$ddd
456$xxx
888$zzz
so if the key is the first field, and the result should be the common key between file 1 and 2 (6 Replies)
Discussion started by: loloAix
6 Replies
9. Shell Programming and Scripting
SHELL SCRIPT
Hi,
I have 3 separate files within a folder. Every File contains data in a single column like
File1 contains data
mayank
sushant
dheeraj
File2 contains
DSA_AT
MG_AT
FLAT_09
File3 contains data
123123
232323 (2 Replies)
Discussion started by: mayanksargoch
2 Replies
10. Shell Programming and Scripting
Hi,
I am using Solaris 8. My script outputs 4 .csv files. Currently I am SFTPing the files and creating a new excel file with the 4 files as sheets.
Can anyone suggest ways to do this in UNIX ?
Thanks,
David. (2 Replies)
Discussion started by: libin4u2000
2 Replies
glabels(1) General Commands Manual glabels(1)
NAME
glabels - Label and business card creation program for GNOME
SYNOPSIS
glabels-3 [OPTIONS] [label-filename...]
glabels-3-batch [OPTIONS] [label-filename...]
DESCRIPTION
glabels-3 is a lightweight program for creating labels and business cards for the GNOME desktop environment. It is designed to work with
various laser/ink-jet peel-off label and business card sheets that you'll find at most office supply stores. glabels-3 is pre-configured
with templates for many of these products. It also provides an interactive template designer for creating new templates according to user
specifications.
For full documentation see the gLabels online help.
glabels-3-batch is a command line utility to print labels previously prepared with glabels-3.
OPTIONS
-?, --help
Display a summary of available command-line options.
--usage
Display a short usage summary.
-v, --version
Print program version information.
Options specific to glabels-batch
-o filename, --output=filename
Set output filename to filename. (default="output.ps")
-i filename, --input=filename
Set name of file with data to be merged to filename. Typically this is a .csv file containing values to be printed on the labels.
-s n, --sheets=n
Set number of sheets to n. (default=1)
-c n, --copies=n
Set number of copies to n. (default=1)
-f n, --first=n
Set label on first sheet to start printing from to n. (default=1)
-l, --outline
Print outlines around labels. This is useful for testing printer alignment or printing proof sheets.
-C, --cropmarks
Print crop marks. Helpful for cutting up sheets.
-r, --reverse
Print mirror image of labels. This is useful for clear labels intended to be seen from the back through glass.
FILES
The $HOME/.glabels directory contains all user-defined templates.
SEE ALSO
The gLabels homepage at <http://glabels.org/>.
AUTHOR
Jim Evins <evins@snaught.com>
Jun 28, 2004 glabels(1)