TOTAL FULL PARTIALORDER  FULLORDER  DEVICENAME
10    2    123456        456789     OHWIL8499IPM101
8     0    345678        789605     OHCIN8499IPM102

DEVICENAME       ORDERNUMBER  SHIPDATE  TYPE      SYSTEMSKU
OHWIL8499IPM101  123456       ASAP      PROJECT1  12345678
OHWIL8499IPM102  123456       ASAP      PROJECT1  12345678
OHWIL8499IPM103  123456       ASAP      PROJECT1  12345678
OHWIL8499IPM104  123456       ASAP      PROJECT1  12345678
OHWIL8499IPM105  123456       ASAP      PROJECT1  12345678
OHWIL8499IPM106  123456       ASAP      PROJECT1  12345678
OHWIL8499IPM107  123456       ASAP      PROJECT1  12345678
OHWIL8499IPM108  123456       ASAP      PROJECT1  12345678
OHWIL8499IPM109  456789       ASAP      PROJECT1  12345678
OHWIL8499IPM110  456789       ASAP      PROJECT1  12345678

#!/bin/bash
currentUser=$(/bin/ls -la /dev/console | /usr/bin/cut -d ' ' -f 4)
LOGFILE="/Users/$currentUser/Desktop/kit.csv"
SRCFILE="/Users/$currentUser/Desktop/input.csv"

orderFull=$(cat "$SRCFILE" | sed 's/,/ /g' | awk '{print $4}')
orderPartial=$(cat "$SRCFILE" | sed 's/,/ /g' | awk '{print $3}')
device_name=$(cat "$SRCFILE" | sed 's/,/ /g' | awk '{print $5}')
quantityNum=$(cat "$SRCFILE" | sed 's/,/ /g' | awk '{print $1}')
quantityFull=$(cat "$SRCFILE" | sed 's/,/ /g' | awk '{print $2}')
shipDate=ASAP
projectType=Project1
systemSku=1235678
number=$(echo "$device_name" | head -c 9| tail -c 4)

max_sequence_name=$()
max_sequence_num=$(echo $max_sequence_name | rev | cut -c 1-3 | rev)
if [ -z "$max_sequence_name" ];
then
    max_sequence_name=device_name
    max_sequence_num=100
fi
array_new_sequence_name=()
for i in $(seq 1 $quantityNum);
do
    cnum=$((max_sequence_num + i))
    array_new_sequence_name+=($(echo $device_name$cnum))
done
for sqn in ${array_new_sequence_name[@]};
do
    echo "$sqn,$orderNumber,$shipDate,$projectType,$systemSku,$number >> $LOGFILE
done

if [ "$quantityFull" = 0 ]; then
  orderNumber=$(echo "$orderPartial")
else
  math=$(expr $orderPartial - $orderFull)
  #ENTER CODE HERE TO DETERMINE WHICH NAMES TO CHANGE ORDER NUMBER ON
  orderNumber=$(echo "$orderFull")

fi