UNIX for Beginners Questions & Answers

2019 NGS-A Gene and Chromosomal Position List,,,,
Gene Symbol,HGNC ID,Transcript Number,Chromosomal Position/Interval ,Required (Exome and Genome Labs)
VPS13B,HGNC:2183,NM_017890.4,chr8 100493900-100493909,yes
VPS33B,HGNC:12712,NM_018668.4,chr15 91543131,

chr8	100493899	100493909	VPS13B
chr15	91543130	91543131	VPS33B

chr8	100493900	100493909	VPS13B
chr15	91543130	91543131	VPS33B

awk -F, 'FNR > 2 {for(i=1;i<=NF;i++){if($i~/^chr/){a=$i}} print a,$1}' file | awk -F'[ :-]' 'NF==3{$4=$3;$3=$2} {$1=$1} 1' OFS='\t' | awk -F'\t' '{print $1,$2-1,$3,$4}' OFS="\t" out

awk -F "[, -]" '
!/^VPS/         {next}
($0 ~ "-")      {print $4, $5, $6, $1; next}
                {print $4, ($5-1), $5, $1}
' OFS="\t" file

awk -F, '/VPS/{num=split($4,array,"[ -]");if(num==3){print array[1],array[2]+1,array[3],$1};if(num==2){print array[1],array[2]-1,array[2],$1}}'   Input_file | column -t

awk -F "[, -]" '
!/^[A-Z]/         {next}
($0 ~ "-")      {print $4, $5, $6, $1; next}
                {print $4, ($5-1), $5, $1}
' OFS="\t" in

ID	-1	Transcript	Gene
chr8	100493900	100493909	VPS13B
chr15	91543130	91543131	SPS33B

chr8	100493900	100493909	VPS13B
chr15	91543130	91543131	SPS33B

!/:/    {next}

!/^[A-Z][A-Z]/    {next}

awk -F '[, -]' '$4~/^chr/{if(!$6) {$6=$5; $5-=1} print $4, $5, $6, $1}' OFS='\t' file