I have converted data written on excel sheet in unix through shell & perl prg
now the problem is I want that if starting columns of the xls sheet is Blank than when data is converted into unix then it should appear with this '|' sign. but it appearing like this:
hfgg|tytt|
but I want like... (2 Replies)
hi friends i want to know details of `exec` exact use of this command .....
actually i went through the man page but i didn`t get the satisfactory ...conclusion....
thaks in advance.... (1 Reply)
find /A/B/C/{1,3,5,7} -name "*.txt" -o -name "*.csv" -o -name "*.TXT" -o -name "*.dat" |xargs ls -ltr |awk '{print $8 ,$9}' > result.xls
it will give the result that is $8 and &9 in the result file...
let say i need the result is a excel file....and i need the result to be print like $8 field... (10 Replies)
I just started to learn unix -
need help to write a script to query a logfile and produce the results that
contains a specific word "alarm" for a period from X day to Y day.
I really have no idea how to begin - :(
please help...
____________________________________________________
#... (1 Reply)
I would like to use the result of a query in another query. How do I redirect/add the output to another variable?
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
echo $row,"\n";
}
odbc_close($connect);
?>
This will output hostnames:
host1... (0 Replies)
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
hi
i want to make script. where i want to query from the user yes or no
exp: do you want to proceed :
y for yes
n for NO.
how this is possible in unix (3 Replies)
Hi expert,
I have a script which is connecting with sql internally, fetch same data, store it in a file and then from os I cat this file and sending it to mail (windows outlook).
This is working fine, I just need to know wether we can add some html codes with the sql query like we can add... (0 Replies)
Below i have the sample code. i need to pass the entire query from file or as parameter and read the results and write into a output file.
here the number of columns are unknown. some times it may be 2,3 or entire columns from the table.
read all the column results and write into a comma... (0 Replies)
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
LEARN ABOUT HPUX
packingrules
packingrules(4) Kernel Interfaces Manual packingrules(4)NAME
packingrules - packing rules file for cachefs
DESCRIPTION
is a packing rules file for packingrules contains a list of directories and files that are to be packed. It also contains a list of direc-
tories and files that are to be specifically excluded from packing. See cachefspack(1M).
Many users choose to manually create the packing rules file and edit it by hand. Users can edit the packingrules (using any editor) to
permanently change the packingrules file, or to gain access to more powerful options that are not available from the command line (such as
the command). It is much easier to enter complex wildcard expressions by editing the packingrules file.
Following is a description of the lines in a packing rules file. Blank lines and lines that begin with a pound sign are ignored. Lines
can be continued by placing a backslash () immediately before the newline character. All other lines in the packingrules file have one
of the following formats:
This line identifies a directory (or pair of directories)
under which files should be packed. At least one directory name must be specified. The arguments must be fully qualified
path names and may include environment variables.
This line enumerates a list of files and subdirectories
beneath the current directory to be packed. This specification is recursive. That is, specifying the name of a directory
automatically includes all files and subdirectories it contains.
This line enumerates a list of files that are not to be packed.
Regular expressions are permitted.
There are important differences between the arguments to the and the statements. The arguments to statements can contain slashes and are
interpreted as file names relative to the directories. The arguments to statements are simpler names or expressions that cannot contain
slashes. An statement will not override a LIST statement. statements only exclude files that are found beneath listed directories.
If the first name argument to a or an statement begins with an exclamation point the remainder of the statement will be executed as a com-
mand that will be run in the current directory. The output of the command will be treated as a list of newline separated file names to be
packed command) or to be excluded from the packing list command). For the command, the resulting file names will be interpreted relative
to the enclosing directory.
Blanks can be embedded in an argument by escaping them with a backslash () or enclosing the argument in double quotes (` " '). Double
quotes can be passed in arguments by escaping the double quotes with a backslash ().
lines only apply to the statement that precedes them. lines can appear before any statement (in which case they apply to all or after a
statement (in which case they only apply to the that precedes them). Any number of these statements can occur in any combinations. The
order is not important.
EXAMPLES
The use of these statements is illustrated in the following packing rules file.
#
# Ignore junk files.
#
IGNORE core *.o *.bak *%
#
# Pack everything in the work subdirectory and in a few
# favorite mailboxes.
#
BASE /net/bigserver/export/home/myname
LIST work
LIST m/incoming
LIST m/action
LIST m/pending
#
# Pack two important project directories but skip
# all postscript output.
#
BASE /net/bigserver/export/projects $HOME/projects
LIST poindexter epiphany
IGNORE *.ps
#
# Pack the foonly package.
#
BASE /net/bigserver/opt/foonly /opt/foonly
LIST !cat .packinglist
#
# Also pack the latest executables for the standard
# build environment.
#
BASE /net/bigserver/export/buildenv $HOME/buildenv
LIST !find . -type f -a -perm -111 -a -print
AUTHOR
was developed by Sun Microsystems, Inc.
SEE ALSO cachefspack(1M).
packingrules(4)