I have three cron entries in a file /cron_entries as
15 * * * * /bin/hourjobs > /tmp/hrjob.log 2>&1
..................
....................
I am trying to read this file in for loop using code below:
cron=`cat /cron_entries`
for line in $cron
do
printf... (4 Replies)
Hi all,
I am trying to extract the values ( text between the xml tags) based on the Order Number.
here is the sample input
<?xml version="1.0" encoding="UTF-8"?>
<NJCustomer>
<Header>
<MessageIdentifier>Y504173382</MessageIdentifier>
... (13 Replies)
I have a text file with a list of items/patterns:
ConsensusfromCGX_alldays_trimmedcollapsedfilteredreadscontiglist(229095contigs)contig12238
ConsensusfromCGX_alldays_trimmedcollapsedfilteredreadscontiglist(229095contigs)contig34624... (1 Reply)
$ cat file.log
Message Number = : Sending message 10:50:16^|^reqhdr.dummyid^=^02^|^reqhdr.timezone^=^GMT+05:30^|^DUMMYREQUEST^=^BH||||||||||||||||||$BD|OL|C|V||DummyAcctNo|02||24/12/2011|ST_DDM|DDM||||||||reqUUID110612105016$BT||||||||||||||||||$] Length
I have the above line in the... (4 Replies)
Hi,
I need some help on how to print the whole data for unmatched pattern. i have 2 different files that need to be checked and print out the unmatched patterns into a new file. My sample data as follows:-
File1.txt
Id Num Activity Class Type
309 1.1 ... (5 Replies)
Hello,
I am new to awk and I am trying to figure out how to print an output based on user input.
For example:
ubuntu:~/scripts$ steps="step1, step2, step3"
ubuntu:~/scripts$ echo $steps
step1, step2, step3
I am playing around and I got this pattern that I want:
... (3 Replies)
OS : RHEL 6.5
Shell : Bash
With the following bash shell script, when I enter password, it won't be printed in the screen.
But, I would like Asterisk character to be printed instead of the real characters. Any idea how ?
$ cat pass.sh
echo "Enter the username"
read username
echo... (3 Replies)
Hi All,
i want to write a shell script read below file line by line and want to exclude the lines which contains empty value for MOUNTPOINT field.
i am using centos 7 Operating system.
want to read below file.
# cat /tmp/d5
NAME="/dev/sda" TYPE="disk" SIZE="60G" OWNER="root"... (4 Replies)
Hi,
I am trying to extract data based on certain conditions. My sample input file as below:-
lnc-2:1 OnePiece tra_law 500 688 1 . . g_id "R792.8417"# tra_law_id "R792.8417.1"# g_line "2.711647"# KM "8.723820"#
lnc-2:1 OnePiece room 500 510 1 . . g_id "R792.8417"# tra_law_id "R792.8417.1"#... (7 Replies)
Discussion started by: bunny_merah19
7 Replies
LEARN ABOUT DEBIAN
alzabo::sqlmaker::postgresql
Alzabo::SQLMaker::PostgreSQL(3pm) User Contributed Perl Documentation Alzabo::SQLMaker::PostgreSQL(3pm)NAME
Alzabo::SQLMaker::PostgreSQL - Alzabo SQL making class for PostgreSQL
SYNOPSIS
use Alzabo::SQLMaker;
my $sql = Alzabo::SQLMaker->new( sql => 'PostgreSQL' );
DESCRIPTION
PostgreSQL-specific SQL creation.
METHODS
Almost all of the functionality inherited from "Alzabo::SQLMaker" as is. The only overridden methods are "limit()" and "get_limit()", as
PostgreSQL does allow for a "LIMIT" clause in its SQL.
EXPORTED SQL FUNCTIONS
SQL may be imported by name or by tags. They take arguments as documented in the PostgreSQL documentation (version 3.23.39). The func-
tions (organized by tag) are:
:math
PI
RANDOM
ABD
CEIL
DEGREES
FLOOR
FACTORIAL
SQRT
CBRT
EXP
LN
RADIANS
ACOS
ASIN
ATAN
ATAN2
COS
COT
SIN
TAN
ROUND
TRUNC
LOG
POW
MOD
TO_CHAR
:string
LENGTH
CHAR_LENGTH
CHARACTER_LENGTh
OCTET_LENGTH
TIRM
UPPER
LOWER
INITCAP
ASCII
TO_ASCII
STRPOS
POSITION
TO_NUMBER
TO_DATE
TO_TIMESTAMP
REPEAT
RPAD
LPAD
SUBSTR
:datetime
NOW
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
TIMEOFDAY
ISFINIT
TIMESTAMP
TO_CHAR
DATE_PART
DATE_TRUNC
EXTRACT
OVERLAPS
:network
BROADCAST
HOST
NETMASK
MASKLEN
NETWORK
TEXT
ABBREV
:aggregate
These are functions which operate on an aggregate set of values all at once.
COUNT
AVG
MIN
MAX
SUM
STDDEV
VARIANCE
:system
These are functions which return information about the Postgres server.
CURRENT_USER
SYSTEM_USER
USER
:control
These are flow control functions:
NULLIF
COALESCE
:misc
These are functions which don't fit into any other categories.
ENCRYPT
ENCODE
DECODE
FORMAT
INET_NTOA
INET_ATON
BIT_OR
BIT_AND
PASSWORD
MD5
LOAD_FILE
:common
These are functions from other groups that are most commonly used.
NOW
COUNT
AVG
MIN
MAX
SUM
DISTINCT
AUTHOR
Dave Rolsky, <dave@urth.org>
perl v5.8.8 2007-12-23 Alzabo::SQLMaker::PostgreSQL(3pm)