-
Notifications
You must be signed in to change notification settings - Fork 0
/
OFY.txt
42 lines (21 loc) · 1.14 KB
/
OFY.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
Subject: Converting CSV file to DSV file using column and cat command
First take a sample csv (Ex: ESS.csv)
ESS.csv is comma separated file with left and right enclosure is """
and field separator is ","
To convert the ESS.csv file to delimited file(i.e dsv) using column command
use below command
cat ESS.csv | column -t -s '"' -o '' | column -t -s ',' -o ';' > ESS.dsv
Command Explanation:
Above command changes left and right enclosure from " to none and
field separator is ";"
You can customize left enclosure as per your requirements
Example 2:
Change left and right enclosure from """ to "'" and field separator is ";"
cat ESS.csv | column -t -s '"' -o ''' | column -t -s ',' -o ';' > ESS.dsv
Example 3:
Change left and right enclosure from "'"" to ":" and field separator is ";"
cat ES.csv | column -t -s \'\'\' -o ':' | column -t -s ',' -o ';' > ES.dsv
Example files are available in github : https://github.com/hemanth22/CSVToCustomDSV
Github Wiki Guide link: https://github.com/hemanth22/CSVToCustomDSV/wiki/Guide-to-use-CSVToCustomDSV
How to download example use below command
git clone https://github.com/hemanth22/CSVToCustomDSV.git