1. I extract the details from database
2. Put it in a text file. I separate 3 fields by "|" (Pipe) in the text file.
3. I will convert this text file to an excel sheet. The excel sheet will have 3 columns. In the last column i have "Y" or "N".
Now I want only "Y" in my excel sheet. All "N" from the excel should be filtered. Where can it be done? Can I filter it after converting the text file to excel? Or I have to do it before converting the text file to excel?
Thanks in advance.
Try:
Step 1:
Step 2
Convert back to excel sheet, with delimitter |
I have 3 columns in an excel sheet.
c1 c2 c3
EIP_ACCOUNT SMALL_TS_01 select A.* from acc;
All the above 3 col shoud be passed a variable in the unix code.
1.How to read an excel file
2.How to pass these data as variable to the unic script (1 Reply)
Hi All,
I am having an excel sheet with pre-defined format which our business team specified, what i need to do is i have to write a script which need to pick values from database and update specified cells in excel sheet..
can any one please help me in this regard..
I am able to pull the... (3 Replies)
Hi Guys..
Need your help to format the output of my shell script.
I am using spool command to take out put in csv file.
below is my code. (for example)
col USERNAME for a15
col EMAIL for a30
col FULL_NAME for a20
col LAST_LOGIN for a40
col DATE_CREATED for a40
SPOOL 120.csv... (3 Replies)
hi,
i have a text file that looks like this!
i want to generate an excel sheet out of it, removing all the junk data except the addresses
that look like
. Arrow Electrical Services
Rotating Machinery, Electrical Contracting & Mining Specialists
Onsite maintenance, breakdown... (8 Replies)
Hi,
i have some data in a temporary file in Unix (the data is taken from the result of an SQL query). Now i want to dump that data into an excel sheet. How to do that. Someone please advise. Thanks
Regards,
Vinit (3 Replies)
Hello,
I have the following data format in a log file :
a : x1
b : x2
c : x3
d : x4
--------
a : x5
b : x6
c : x7
d : x8
so the same fields ( a ,b ,c,d) repeated many times in the same log file but with different "x" values (x5,x6,x7,x8).
I need a script to save this data in an... (6 Replies)
Hi,
I want to write a program to copy a log file to Excel sheet. Excel sheet has four columns MethodName , Code , Description, Details and Time.
I want to pick these info from text file and put it in excel sheet.
here is how the text file looks -
04.17.2014 08:06:12,697... (1 Reply)
Hi Folks,
Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are
1excel.xslx
2excel.xslx
3excel.xslx
now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies
LEARN ABOUT DEBIAN
nup
NUP(1) General Commands Manual NUP(1)NAME
nup - multiple pages per sheet with dvi2ps
SYNOPSIS
nup [ [ -p paper ] [ -2 ] [ -4 ] [ -8 ] [ -l ] [ -n ] ]
DESCRIPTION
This manual page documents briefly the nup command. This manual page was written for the Debian GNU/Linux distribution because the origi-
nal command hadn't manual page.
Nup puts multiple logical pages onto each physical sheet of paper with dvi2ps. The input PostScript file should be of dvi2ps
The -p paper option is to set the paper size which is available with dvi2ps.
The -2 option is to put 2 logical pages on each sheet of paper.
The -4 option is to put 4 logical pages on each sheet of paper.
The -8 option is to put 8 logical pages on each sheet of paper.
The -l option is to surround a page with frame.
The -n option in not to shrink each logical pages.
EXAMPLES
to print 2 pages in a sheet:
dvi2ps foo.dvi | nup -2 | lpr
to print 8 pages in a B4 paper:
dvi2ps foo.dvi | nup -8 -p b4 | lpr
to print 4 pages in a letter size paper with frame:
dvi2ps foo.dvi | nup -4 -p letter -l | lpr
to print 2 B5 size pages in a B4 paper:
dvi2ps -o b5 foo.dvi | nup -2 -n -p b4 | lpr
SEE ALSO dvi2ps(1)AUTHOR
This manual page was written by Atsuhito Kohda <kohda@debian.org>, for the Debian GNU/Linux system (but may be used by others).
NUP(1)