: !/bin/sh # get info from upfile log csv refid="$1" upfilelog_file="topdat/upfile/upfile2_log.csv" awk -F',' -v"refid=$refid" ' { if ( $2 == refid ) { f = 0 printf("datetime=\"%s\";\n", $(++f)) printf("datarefid=\"%s\";\n", $(++f)) printf("accountnumber=\"%s\";\n", $(++f)) printf("invoicenumber=\"%s\";\n", $(++f)) printf("totalcost=\"%s\";\n", $(++f)) printf("dtype_idx=\"%s\";\n", $(++f)) printf("upserviceproviderdir=\"%s\";\n", $(++f)) printf("updismainttype=\"%s\";\n", $(++f)) printf("fullinfile=\"%s\";\n", $(++f)) } }' < "$upfilelog_file"