fork download
copy 
  1. #!/bin/bash
  2.  
  3. sed 's/^\("\([^"]\|""\)*"\|[^",]*\),\("\([^"]\|""\)*"\|[^",]*\),\("\([^"]\|""\)*"\|[^",]*\),\("\([^"]\|""\)*"\|[^",]*\)$/\1,\3,\5/'
Success #stdin #stdout 0s 4384KB
comments (?)
stdin
copy 
name,email,mobile,email
a,a@test.com,1234567890,a@test.com
name,email,"mobile,number",email
a,a@test.com,1234567890,a@test.com
name,email,"mobile number",email
a,a@test.com,1234567890,a@test.com
additional test cases,"quoting everywhere","""one"", ""two"", ""three"", ""four""!","tell me your secret"
"a","a@test.com","1234567890,234,""234""","a@test.com"
stdout
copy 
name,email,mobile
a,a@test.com,1234567890
name,email,"mobile,number"
a,a@test.com,1234567890
name,email,"mobile number"
a,a@test.com,1234567890
additional test cases,"quoting everywhere","""one"", ""two"", ""three"", ""four""!"
"a","a@test.com","1234567890,234,""234"""
https://ideone.com/7xKlGU
https://stackoverflow.com/questions/64881681/remove-duplicate-column-from-csv-in-ubuntu
language:
Bash (bash 5.0.3)
created:
4 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!