|
1
|
1 NAME
|
|
|
2 ModifyTextFilesFormat.pl - Change CSV Textfile(s) into TSV Textfile(s)
|
|
|
3 and vice versa
|
|
|
4
|
|
|
5 SYNOPSIS
|
|
|
6 ModifyTextFilesFormat.pl TextFile(s)...
|
|
|
7
|
|
|
8 ModifyTextFilesFormat.pl [-h, --help] [--indelim comma | semicolon]
|
|
|
9 [--outdelim comma | tab | semicolon] [-q, --quote yes | no] [-r, --root
|
|
|
10 rootname] [-w, --workingdir dirname] TextFile(s)...
|
|
|
11
|
|
|
12 DESCRIPTION
|
|
|
13 Interchange CSV and TSV *TextFile(s)* format. Mutiple file names are
|
|
|
14 separated by spaces. The valid file extensions are *.csv* and *.tsv* for
|
|
|
15 comma/semicolon and tab delimited text files respectively. All other
|
|
|
16 file names are ignored. All the text files in a current directory can be
|
|
|
17 specified by **.csv*, **.tsv*, or the current directory name. The
|
|
|
18 --indelim option determines the format of *TextFile(s)*. Any file which
|
|
|
19 doesn't correspond to the format indicated by --indelim option is
|
|
|
20 ignored.
|
|
|
21
|
|
|
22 OPTIONS
|
|
|
23 -h, --help
|
|
|
24 Print this help message.
|
|
|
25
|
|
|
26 --indelim *comma | semicolon*
|
|
|
27 Input delimiter for CSV *TextFile(s)*. Possible values: *comma or
|
|
|
28 semicolon*. Default value: *comma*. For TSV files, this option is
|
|
|
29 ignored and *tab* is used as a delimiter.
|
|
|
30
|
|
|
31 -o, --overwrite
|
|
|
32 Overwrite existing files.
|
|
|
33
|
|
|
34 --outdelim *comma | tab | semicolon*
|
|
|
35 Output text file delimiter. Possible values: *comma, tab, or
|
|
|
36 semicolon* Default value: *comma*.
|
|
|
37
|
|
|
38 -q, --quote *yes | no*
|
|
|
39 Put quotes around column values in output text file. Possible
|
|
|
40 values: *yes or no*. Default value: *yes*.
|
|
|
41
|
|
|
42 -r, --root *rootname*
|
|
|
43 New text file name is generated using the root: <Root>.<Ext>.
|
|
|
44 Default new file name: <InitialTextFileName>FormatModified.<Ext>.
|
|
|
45 The csv, and tsv <Ext> values are used for comma/semicolon, and tab
|
|
|
46 delimited text files respectively. This option is ignored for
|
|
|
47 multiple input files.
|
|
|
48
|
|
|
49 -w, --workingdir *dirname*
|
|
|
50 Location of working directory. Default: current directory.
|
|
|
51
|
|
|
52 EXAMPLES
|
|
|
53 To convert Sample*.csv into TSV files, type:
|
|
|
54
|
|
|
55 % ModifyTextFilesFormat.pl --outdelim tab -q no -o Sample*.csv
|
|
|
56
|
|
|
57 To convert Sample1.tsv into NewSample1.csv without any quotes around
|
|
|
58 column data values, type:
|
|
|
59
|
|
|
60 % ModifyTextFilesFormat.pl --outdelim comma - q no
|
|
|
61 -r NewSample1 -o Sample1.tsv
|
|
|
62
|
|
|
63 AUTHOR
|
|
|
64 Manish Sud <msud@san.rr.com>
|
|
|
65
|
|
|
66 SEE ALSO
|
|
|
67 ModifyNewLineChar.pl
|
|
|
68
|
|
|
69 COPYRIGHT
|
|
|
70 Copyright (C) 2015 Manish Sud. All rights reserved.
|
|
|
71
|
|
|
72 This file is part of MayaChemTools.
|
|
|
73
|
|
|
74 MayaChemTools is free software; you can redistribute it and/or modify it
|
|
|
75 under the terms of the GNU Lesser General Public License as published by
|
|
|
76 the Free Software Foundation; either version 3 of the License, or (at
|
|
|
77 your option) any later version.
|
|
|
78
|
