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