I have file as below
column1|column2|column3|column4|column5|
fill1|fill2|fill3|fill4|fill5|
abc1|abc2|abc3|abc4|abc5|
.
.
.
.
i need to remove column2,3, from that file
column1|column4|column5|
fill1|fill4|fill5|
abc1|abc4|abc5|
.
.
.
I have file as below
column1|column2|column3|column4|column5|
fill1|fill2|fill3|fill4|fill5|
abc1|abc2|abc3|abc4|abc5|
.
.
.
.
i need to remove column2,3, from that file
column1|column4|column5|
fill1|fill4|fill5|
abc1|abc4|abc5|
.
.
.
$ awk '{FS=OFS="|";print $1,$4,$5}' a.txt
lumn1|column2|column3|column4|column5|||
fill1|fill4|fill5
abc1|abc4|abc5
OR...
$ cat file
column1|column2|column3|column4|column5|
fill1|fill2|fill3|fill4|fill5|
abc1|abc2|abc3|abc4|abc5|
abc1|abc2|abc3|abc4|abc5|
$ awk 'BEGIN{FS=OFS="|"}{$2=$3="";gsub(/[|]+/,"|")}1' file
column1|column4|column5|
fill1|fill4|fill5|
abc1|abc4|abc5|
abc1|abc4|abc5|
$ awk 'BEGIN{FS=OFS="|"}{$2=$5="";gsub(/[|]+/,"|")}1' file
column1|column3|column4|
fill1|fill3|fill4|
abc1|abc3|abc4|
abc1|abc3|abc4|
sed 's/|[a-zA-Z0-9]*|[a-zA-Z0-9]*//' filename