Bashscripts.org

#!/bin/bash
# Make a human-readable version of the first argument passed to the script (./script.sh <argument 1>)
file=$1
# reset the counter
i=0
# Do a line by line loop of the file supplied in argument 1 (or as it is now known, $file)
# The IFS variable tells us what we should look for to create an itteration inside for(1)
# old_IFS is just a way to reset the IFS when we're done :)
old_IFS=$IFS
IFS="
"
# The for(1) loop will read the $file and sort it according to column 1, the date in your supplied example.
for i in $(cat $file | sort -t',' -k1,1); do
   # This adds the second column to an array named "array1"
   array1[$i]=$(echo $i | cut -d',' -f2)
   # This adds the third column to an array named "array2"
   array2[$i]=$(echo $i | cut -d',' -f3)
   # Increment the elemental counter :)
   ((i++))
done
IFS=$old_IFS
# Echo the entire array (and since it's space separated we replace all spaces with commas)
total_logins=$(echo ${array1[*]} | replace " " ",")
total_unique=$(echo ${array2[*]} | replace " " ",")

echo "total_logins=$total_logins"
echo "total_unique=$total_unique"

hanna:~> ./test.sh test.txt
total_logins=4485,5817,10671
total_unique=3148,3954,6503

./login-count: line 23: replace: command not found
./login-count: line 24: replace: command not found

total_logins=$(echo ${array1[*]} | sed -e 's/[ ]\{1,\}/,/g')
total_unique=$(echo ${array2[*]} | sed -e 's/[ ]\{1,\}/,/g')

#!/bin/bash
# Parse data from login file to pass to Google Charts

# Locate the stat file
statfile="../statsdata/login.stats"

# Read in the last 10 entries
file=`tail -10 $statfile`

# reset the counter
i=0

# Do a line by line loop of the file supplied in argument 1 (or as it is now known, $file)
# The IFS variable tells us what we should look for to create an itteration inside for(1)
# old_IFS is just a way to reset the IFS when we're done :)
old_IFS=$IFS
IFS="
"
# Sort the total and unique logins
for i in $file; do
   # This adds the second column to an array named "array1"
   array1[$i]=$(echo $i | cut -d',' -f2)
   # This adds the third column to an array named "array2"
   array2[$i]=$(echo $i | cut -d',' -f3)
   # Increment the elemental counter :)
   ((i++))
done
IFS=$old_IFS

# Echo the entire array (and since it's space separated we replace all spaces with commas)
total_logins=$(echo ${array1[*]} | sed -e 's/[ ]\{1,\}/,/g')
total_unique=$(echo ${array2[*]} | sed -e 's/[ ]\{1,\}/,/g')

# Print the result
echo "total_logins=$total_logins"
echo "total_unique=$total_unique"

line 53: 2010-01-08: value too great for base (error token is "08")

   50  # The for(1) loop will read the $file and sort it according to column 1, the date in your supplied example.
    51  for i in $MYFILE; do
    52     # This adds the second column to an array named "array1"
    53     array1[$i]=$(echo $i | cut -d',' -f2)
    54     # This adds the third column to an array named "array2"
    55     array2[$i]=$(echo $i | cut -d',' -f3)
    56     # Increment the elemental counter :)
    57     ((i++))
    58  done
    59  IFS=$old_IFS

#!/bin/bash

echo; echo "[fn: distinguish_logins]"; echo

#function distinguish_logins ()
#{
rm ./logins_total.log
rm ./logins_unique.log
unset LOGINS_TOTAL[*]
unset LOGINS_UNIQUE[*]

echo "cat ./log_records.log"
echo "~~~~~~~~~~~~~~~~~~~~~"
cat ./log_records.log
echo

printf "%-11s" "Record"
printf "%+11s" "Log Total"
printf "%+11s\n" "Log Unique"
printf "%-11s" "~~~~~~"
printf "%+11s" "~~~~~~~~~"
printf "%+11s\n" "~~~~~~~~~~"

let -i count=0
for LOG in $(cat ./log_records.log); do
   let count=count+1
   echo $LOG | cut -d, -f2 >> ./logins_total.log
   echo $LOG | cut -d, -f3 >> ./logins_unique.log
   LOG_DATE[$count]=$(echo $LOG | cut -d, -f1)
   LOGINS_TOTAL[$count]=$(echo $LOG | cut -d, -f2)
   LOGINS_UNIQUE[$count]=$(echo $LOG | cut -d, -f3)
   printf "%-11.10s" ${LOG_DATE[$count]}
   printf "%+11.10s" ${LOGINS_TOTAL[$count]}
   printf "%+11.10s\n" ${LOGINS_UNIQUE[$count]}
#   echo "${LOGINS_TOTAL[$count]} ${LOGINS_UNIQUE[$count]}"
done
echo

echo "Logins Total:"
echo "~~~~~~~~~~~~~"
cat ./logins_total.log
echo
echo "Logins Unique:"
echo "~~~~~~~~~~~~~~~"
cat ./logins_unique.log
echo

echo -n "LOGINS_TOTAL="
for (( i = 1; i <= $count; i++ )); do echo -n "${LOGINS_TOTAL[$i]},"; done; echo
echo -n "LOGINS_UNIQUE="
for (( j = 1; j <= $count; j++ )); do echo -n "${LOGINS_UNIQUE[$j]},"; done; echo
echo "[done]"; echo

#}

exit 0

[fn: distinguish_logins]

cat ./log_records.log
~~~~~~~~~~~~~~~~~~~~~
2010-01-01,4485,3148
2010-01-02,5817,3954
2010-01-03,10671,6503

Record       Log Total Log Unique
~~~~~~       ~~~~~~~~~ ~~~~~~~~~~
2010-01-01        4485       3148
2010-01-02        5817       3954
2010-01-03       10671       6503

Logins Total:
~~~~~~~~~~~~~
4485
5817
10671

Logins Unique:
~~~~~~~~~~~~~~~
3148
3954
6503

LOGINS_TOTAL=4485,5817,10671,
LOGINS_UNIQUE=3148,3954,6503,
[done]

#!/bin/bash

while IFS=' ,' read DATE TOTAL UNIQUE
do LOGINS_TOTAL+=( "$TOTAL" )
   LOGINS_UNIQUE+=( "$UNIQUE" )
done < <(tail -10 ../statsdata/login.stats)

# Echo the entire array (and since it's space separated we replace all spaces with commas)
# and Print the result
echo "total_logins=$(sed -e 's/[ ]\{1,\}/,/g' <<<"${LOGINS_TOTAL[@]}")"
echo "total_unique=$(sed -e 's/[ ]\{1,\}/,/g' <<<"${LOGINS_UNIQUE[@]}")"