comparison docs/scripts/txt/ModifyTextFilesFormat.txt @ 0:4816e4a8ae95 draft default tip

Uploaded
author deepakjadmin
date Wed, 20 Jan 2016 09:23:18 -0500
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:4816e4a8ae95
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