Converts csv to AWS DynamoDB STX/ETX ASCII delimited format

csv2dyn.awk

# converts a csv file to a dynamodb compatible stx/etx acsii delimited file
# awk -F, -v types=n,s,s,s,s,s,n,n -f csv2dyn.awk mydata.csv > dynamo.txt

BEGIN {
    STX="\02"
    ETX="\03"
    split(types, dtypes, ",")
}

NR == 1 {
    split($0, columns, FS)
}

NR > 1 {
    row=""
    split($0, values, FS)
    for (i = 1; i <= NF; i++) {
        row = row columns[i] ETX "{\"" dtypes[i] "\":\"" values[i] "\"}"
        if (i < NF) row = row STX
    }
    print row
}