02-01-2008
help in inserting values in date format
how to assign values in this date format
a=`date +"%H%M%S"`
how to give value of H=22,here in this format so that i can grep 22nd hour.Below is the script
--------------------------------------------------------------------------
a=`date +"%H%M%S"`
for i in *.log
do
cat $i | grep $a | wc -l >> file1.txt
done
-------------------------------------------------------------------------------
actually wat i m doing is greping Particular hour in all the logs files and storing the count in file1.txt
i want a date format that can be flexible enough to input our own hour values,depending upon my requirements.so i need that kind of a format to be used in my script.
Last edited by ali560045; 02-01-2008 at 09:29 AM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Guys,
I want to insert some values from a log file into a temporary table. the values in the log file looks like this
SV_NAME CC_NAME CP_DISP_RUN_STATE
------- ------------------- -----------------
sble01 ALLTEL WorkMon24Hrs Running
I want to enter the... (2 Replies)
Discussion started by: ragha81
2 Replies
2. Shell Programming and Scripting
I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column.
I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this?
Sample input
02/27/09,23:52:31
02/27/09,23:52:52... (3 Replies)
Discussion started by: hazno
3 Replies
3. UNIX for Dummies Questions & Answers
I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd.
The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4".
This is what I use to change the format:
sed -i '' -e... (2 Replies)
Discussion started by: figaro
2 Replies
4. Shell Programming and Scripting
Hi,
input file
CCCC 1204 215764.85 9405410.40 1189
DDDD 4498 1503 4617 1507 4723 1517 4829 1528 4996 1540
DDDD 5199 1556 5278 1567 5529 1603 5674 1614 6076 1915
DDDD 6605 2371 7004 2779
CCCC ... (4 Replies)
Discussion started by: Indra2011
4 Replies
5. Shell Programming and Scripting
Hi All,
I have a directory containing multiple files.
and also a txt file which contains the list of all filenames and certain values.
I want to read the text file line by line and if its 2nd column is matched with the filename in directory, then it must insert the values in 7th column to... (14 Replies)
Discussion started by: CAch
14 Replies
6. Shell Programming and Scripting
hi all,
i have one shell script like this
#!/bin/bash -xv
ENV_NAME=`cat $IB_HOME_DIR/cfg/ibProfile.sh | grep "RDM_CONN" | cut -f 2 -d "@"`
CURRENT_DIR=`pwd`;
string=$IB_HOME_DIR
string1="$string/FRGFOLDER/input"
#sed "s/string3/$string1" frg_event_src.sql > modifiedinsert.sql
sqlplus... (2 Replies)
Discussion started by: ramsavi
2 Replies
7. UNIX for Dummies Questions & Answers
Hi Unix Gurus,
I would like to rename several files in a Unix Directory . The filenames can have more than 1 underscore ( _ ) and the last underscore is always followed by a date in the format mmddyyyy. The Extension of the files can be .txt or .pdf or .xls etc and is case insensitive ie... (1 Reply)
Discussion started by: pchegoor
1 Replies
8. Shell Programming and Scripting
Hi,
I have a requirement where I have an excel sheet with the below values
COL1 COL2 COL3
Germany URGENT NORMAL
I want to cut the values of this excel in such a way that I get the values and pass it to an insert statement
update tbfin set... (2 Replies)
Discussion started by: venkidhadha
2 Replies
9. Shell Programming and Scripting
hi ,
I'm new to Unix shell scripting.
I need help to insert read csv which has two columns -emp no and logged date.
csv file is a large file so i want to keep the insertion query in a separate .sql file.
csv file looks this:
empno | loggeddate
___________________
5666 ,... (5 Replies)
Discussion started by: preema
5 Replies
10. Shell Programming and Scripting
i try to set linux date & time in specific format but it keep giving me error
Example :
date "+%d-%m-%C%y %H:%M:%S" -d "19-01-2017 00:05:01"
or
date +"%d-%m-%C%y %H:%M:%S" -d "19-01-2017 00:05:01"
keep giving me this error :
date: invalid date ‘19-01-2017 00:05:01'
Please use CODE tags... (7 Replies)
Discussion started by: umen
7 Replies
LEARN ABOUT DEBIAN
px_timestamp2string
PX_TIMESTAMP2STRING(3) Library Functions Manual PX_TIMESTAMP2STRING(3)
NAME
PX_timestamp2string -- Convert paradox timestamp into formated string
SYNOPSIS
#include <paradox.h>
char * PX_timestamp2string(pxdoc_t *pxdoc, double timestamp, const char *format)
DESCRIPTION
Creates a string representation of a paradox timestamp as specified in the parameter format. The timestamp must be either retrieved with
PX_get_data_double(3) after calling PX_get_record(3) or by simply using the double value in the pxval_t struct as returned by
PX_retrieve_record(3). A timestamp contains both time and date information. The format string contains chars which stand for certain values
of the date/time. The following table lists all available characters with a meaning. All other characters are being copied unmodified to
the output string. If a special character shall not be interpreted it must be preceded with a backslash.
Characters and their meaning in date/time format string
Character Meaning
Y year, numeric, 4 digits
y year, numeric, 2 digits
m month, numeric
n month, numeric, no leading zeroes
d day of the month, numeric
j T{
day of the month, numeric, no leading zeros
T}
H hour, numeric, 24 hour format
h hour, numeric, 12 hour format
G T{
hour, numeric, 24 hour format, no leading zeroes
T}
g T{
hour, numeric, 12 hour format, no leading zeroes
T}
i minutes, numeric
s seconds, numeric
A AM/PM
a am/pm
L boolean for leap year
RETURN VALUE
Returns pointer to string on success and NULL on failure.
SEE ALSO
PX_time2string(3), PX_date2string(3)
AUTHOR
This manual page was written by Uwe Steinmann uwe@steinmann.cx.
PX_TIMESTAMP2STRING(3)