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