XLS to CSV for decision analysis ...

xls_csv.sh

#!/usr/bin/env bash
awk -F, '
BEGIN {
printf("\"id\",\"choices\",\"group\"\n");
}
{
        if (NR > 1)
                {
                        str = ""; 
                        for(i = 7; i <= NF; i++) 
                                { 
                                        str = str $i; 
                                        gsub("\"", "", str); 
                                        sub(/[0-9]+/, "", str);
                                }; 
                                printf("\"%d\",\"%s\",\"control\"\n", NR - 1, str);
                        }
                }' addiction.csv  > addiction_control.csv