12-10-2012
There is a script which everyday generates a new csv file.
By merge I mean: each different sheets which were created for each day should be all together in 1 file but different sheets.
thats why just copy-paste everyday doesnt answer.
10 More Discussions You Might Find Interesting
1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
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
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
LEARN ABOUT SUNOS
postdaisy
postdaisy(1) User Commands postdaisy(1)
NAME
postdaisy - PostScript translator for Diablo 630 daisy-wheel files
SYNOPSIS
postdaisy [-c num] [-f num] [-h num] [-m num] [-n num] [-o list] [-p mode] [-r num] [-s num] [-v num ] [-x num] [-y num] [file...]
/usr/lib/lp/postscript/postdaisy
DESCRIPTION
The postdaisy filter translates Diablo 630 daisy-wheel files into PostScript and writes the results on the standard output. If no files are
specified, or if - is one of the input files, the standard input is read.
OPTIONS
-c num Print num copies of each page. By default only one copy is printed.
-f name Print files using font name. Any PostScript font can be used, although the best results will be obtained only with constant-width
fonts. The default font is Courier.
-h num Set the initial horizontal motion index to num. Determines the character advance and the default point size, unless the -s option
is used. The default is 12.
-m num Magnify each logical page by the factor num. Pages are scaled uniformly about the origin, which is located near the upper left
corner of each page. The default magnification is 1.0.
-n num Print num logical pages on each piece of paper, where num can be any positive integer. By default, num is set to 1.
-o list Print pages whose numbers are given in the comma-separated list. The list contains single numbers N and ranges N1 - N2. A missing
N1 means the lowest numbered page, a missing N2 means the highest. The page range is an expression of logical pages rather than
physical sheets of paper. For example, if you are printing two logical pages to a sheet, and you specified a range of 4, then two
sheets of paper would print, containing four page layouts. If you specified a page range of 3-4, when requesting two logical pages
to a sheet; then only page 3 and page 4 layouts would print, and they would appear on one physical sheet of paper.
-p mode Print files in either portrait or landscape mode. Only the first character of mode is significant. The default mode is portrait.
-r num Selects carriage return and line feed behavior. If num is 1, a line feed generates a carriage return. If num is 2, a carriage
return generates a line feed. Setting num to 3 enables both modes.
-s num Use point size num instead of the default value set by the initial horizontal motion index.
-v num Set the initial vertical motion index to num. The default is 8.
-x num Translate the origin num inches along the positive x axis. The default coordinate system has the origin fixed near the upper left
corner of the page, with positive x to the right and positive y down the page. Positive num moves everything right. The default
offset is 0.25 inches.
-y num Translate the origin num inches along the positive y axis. Positive num moves text up the page. The default offset is -0.25
inches.
EXIT STATUS
The following exit values are returned:
0 Successful completion.
non-zero An error occurred.
FILES
/usr/lib/lp/postscript/forms.ps
/usr/lib/lp/postscript/ps.requests
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWpsf |
+-----------------------------+-----------------------------+
SEE ALSO
download(1), dpost(1), postdmd(1), postio(1), postmd(1), postprint(1), postreverse(1), posttek(1), attributes(5)
SunOS 5.10 9 Sep 1996 postdaisy(1)