Search Results

use a while loop.

while true
do
echo "enter directory for output file [e.g: /home/admin/dst/]:"
read OUTPUTFILE
if [ ! -d $OUTPUTFILE ] ;
then
echo "ERROR: invalid...

Try something like this..


[ ! -d test_2 ] && mkdir test_2 || touch test_2/test.txt

awk 'FNR==4{split(FILENAME,a,"_");dt=a[6]"_"a[7]"_"substr(a[8],1,4);print dt","$0}' Bounce*

$ nawk 'BEGIN{print FILENAME}' a.txt
a.txt

FILENAME - The name of the current input file. If no files are specified on the command line,the value of FILENAME is "-". However, FILENAME is...

Try (not tested):
awk 'FILENAME!=prevfile{
match(FILENAME,/[0-9]{2}_[A-Z][a-z]{2}_[0-9]{4}/)
dt=substr(FILENAME,RSTART,RLENGTH)
prevfile=FILENAME}
FNR>=4{print dt "," $0}'...

for i in *.csv ; do
echo $(basename $i .csv | cut -d_ -f6-),$(tail -1 $i)
done > output.csv

Use below code to give date from the file name into the file entry...

As you have not clearly mentioned how you want the output of your csv, You can just add what you want to add(just grep after...

awk 'BEGIN {FS="[/,: ]"}{$4=($6=="PM"?($4==12?$4:$4+12):($4==12?0:$4)); $6=""} {print $1"/"$2"/"$3","$4":"$5}'

for 24Hrs conversion

The variable latestb must be containing "/" characters. This is confusing sed as you have used "/" as the delimiters for s, pattern, replacement and flags. Try:
sed -e "s:changeme:$latestb:g"...

$ echo "Jan" | awk 'BEGIN{months=" JanFebMarAprMayJunJulAugSepOctNovDec"}{print index(months,$0)/3}'
1
$ echo "Feb" | awk 'BEGIN{months=" JanFebMarAprMayJunJulAugSepOctNovDec"}{print...

Try searching for my posts - I gave some instructions about this.
But in short way:

USE:
"${variable}"
instead of
$variable