|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.mindprod.csv.CSVTuple
public final class CSVTuple
Break up a long CSV line into several shorter ones.
Use: java.exe com.mindprod.CSVTuple somefile.csv 4 Number is how many fields you want in each output line. Will lake a file like this: a,b,c,d,e,f and produce a,b,c,d a,b,c,e a,b,c,f Short lines are padded out to tuple fields with empty fields. x,y becomes x,y,,,
Field Summary | |
---|---|
(package private) static java.util.regex.Pattern |
SPLITTER
used to split Label comment fields apart |
Constructor Summary | |
---|---|
CSVTuple(java.io.File file,
char separatorChar,
char quoteChar,
char commentChar,
int tupleLength,
java.lang.String encoding)
break a CSV file into tuples, constructor. |
Method Summary | |
---|---|
static void |
main(java.lang.String[] args)
Simple command line interface to CSVTuple to brake a csv file into fixed length tuples. |
(package private) static java.lang.String |
rebuildLabelComment(java.lang.String comment,
int tupleLength)
comment has two lead comment chars, one stripped off, and are used to label the fields. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
static final java.util.regex.Pattern SPLITTER
Constructor Detail |
---|
public CSVTuple(java.io.File file, char separatorChar, char quoteChar, char commentChar, int tupleLength, java.lang.String encoding) throws java.io.IOException
file
- CSV file to be packed to remove excess space and quotes.separatorChar
- field separator character, usually ',' in North America, ';' in Europe and sometimes '\t' for
tab.quoteChar
- char to use to enclose fields containing a separator, usually '\"'. Use (char)0 if
you don't want a quote character.commentChar
- char to use to introduce comments. Use (char) 0 if none. Only one character allowed.tupleLength
- how many fields you want in each output record.encoding
- encoding of input and output.
java.io.IOException
- if problems reading/writing fileMethod Detail |
---|
static java.lang.String rebuildLabelComment(java.lang.String comment, int tupleLength)
comment
- field names separated by commas, with lead comment char.
public static void main(java.lang.String[] args)
args
- name of csv file r followed the desired length in fields of the fixed length tuples
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |