Search Results

that's why I proposed the MySQL- function DATE_FORMAT. For an SQL server, how about any of these (from this URL...

I'm not an SQL expert, but still believe this could all be done in SQL without needing awk or sed. And, you showed us the output you said you want with <space> as a field separator and then say that...

Try using a FOR loop:
FOR %i IN (sec*.txt) DO find %i /c /v ""

sed 's/\(if.*LOGNAME.*\)]/\1 –a $LOGNAME != su4 ]/'

--ahamed

Changing my awk script to:
awk -F'[.]' '
FNR == 1 {
t = substr($1, 5)
}
{ h[substr($1, 3, 2)]
}
END { for(i = 0; i < 24; i++)
if(!((hour = sprintf("%02d", i)) in h))
out = (out != "" ?...

You can test if the file is present:
if [ -f /path/to/file ]; then
process file
fi

In case the target file is (part of) a shell script, then consider rewriting
if [ ... ]
then
...
fi
as
case $LOGNAME in
sam);;
su1);;
su2);;
su3);;
su4);;
*)
...
;;
esac
Further...

if [ $LOGNAME != sam –a $LOGNAME != su1 –a $LOGNAME
!= su2 –a $LOGNAME != su3 ]
contains a syntax error. Probably your mean:
if [ $LOGNAME != sam –a $LOGNAME != su1 –a $LOGNAME != su2 –a $LOGNAME...

If you have GNU Parallel GNU Parallel - GNU Project - Free Software Foundation (http://www.gnu.org/software/parallel/) installed you can do this:
parallel '{} >{.}.out' ::: sample*.shor:
seq 4 |...

This could be either keyed on the command line or filed and run as a script. The wait will hold up further processing until all background tasks have completed.

Would you be wanting all the...

Here is a basic alternative POSIX shell script you could try. I hope it is readable:

max=$1 # set max to the first parameter of the script
IFS=, #...

# ./justdoit file
please give the your value(s)= test , tess121 , unix 12 1999999
sam,22,29,test,tess121,unix,12,1999999,23,24,25,26,22

#!/bin/bash
fix=3;x=1;fs=$(grep -o '[,:;.*|]'...

In the perl command, we are removing the control characters

ASCII Character Set (http://www.robelle.com/smugbook/ascii.html) ( check out for 33 )

Because your file is windows based.
...

remove those characters by using the below command.

perl -pe 's/\033\[[^m]*m//g' < input.txt > output.txt

now open the output.txt and see, whether those weired characters are there or not
...

The input data you gave contains no lines that actually match the lines you want. :wall:

So I still can't tell if it works, how could I possibly test it? :wall:

...But might be closer to...

One error is due to value with leading space entered by user. Also I made few correction in your script.
echo -n "ENTER VALUE BETWEEN 01-31 "
read value
count=`tail -1 filecount.txt | tr -d " "` ...

what is your o.s platform and shell?

try like this..
echo -n "ENTER DATE "
read value
s=1;last=$value
## if your value contains "i" in the front of your value then --> last=$(echo $value|sed...

try execute with same subshell..(read(with pipe) executed normally in separate shell and we can use "(........)" ) for process in the same shell..
(this means --> grouping with parentheses)
#...