All Questions

Tagged with
Filter by
Sorted by
Tagged with
37votes
16answers
29kviews

Converting CSV to TSV

I have a number of large CSV files and would like them in TSV (tab separated format). The complication is that there are commas in the fields of the CSV file, eg: A,,C,"D,E,F","G",I,"K,L,M",Z ...
6votes
7answers
31kviews

extract the 4th column from a csv file using unix command

I have a csv file formatted as below. "col1","col2","col3","col4" "1","text1","<p>big html text</p> ","4th column" "2","text2","<p>big2 html2 text2</p> ",...
  • 163
4votes
3answers
5kviews

replace column of a csv file with column from another file

I have two sample files like this: $ cat file1 abc,sachin cat,kumar $ cat file2 xyz pressure $ cat file3 xyz,sachin pressure, kumar I want the first column of file1 to be replaced with file2. ...
  • 91
0votes
3answers
178views

Extract data from the nested parenthesis in bash

I'd need a way to extract certain data and store it in file for auditing and migration. Here's my data look like. network vlan internal-vlan { description "internal-use" interfaces { ...