Package com.simplicite.util.tools
Class CSVTool
- java.lang.Object
-
- com.simplicite.util.tools.CSVTool
-
- All Implemented Interfaces:
java.io.Serializable
public class CSVTool extends java.lang.Object implements java.io.Serializable
CSV toolbox- See Also:
- Serialized Form
-
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description static java.lang.String
csvHeader(ObjectCore obj)
Generates CSV header for objectstatic void
cvsToObject(ObjectCore obj, java.lang.String csv)
Converts CSV message into object fieldsstatic void
cvsToObjectFilters(ObjectCore obj, java.lang.String csv)
Converts CSV message into object filtersstatic java.util.List<ObjectField>
getVisibleColumns(ObjectCore obj, java.lang.String mode, boolean tech)
Visible columns to exportstatic boolean
isFormVisible(boolean full, ObjectCore obj, ObjectField f)
Is field visible for CSV export in a single record contextstatic boolean
isListVisible(boolean full, ObjectCore obj, ObjectField f)
Is field visible for CSV export in a multiple records contextstatic java.lang.String
objectListItemToCsv(ObjectCore obj, java.lang.String[] vals)
Converts object list into CSVstatic java.lang.String
objectToCsv(ObjectCore obj)
Converts object fields into CSVstatic java.lang.String
objectToCSV(ObjectCore obj, java.util.List<java.lang.String[]> rows, java.lang.String mode, java.lang.String sep, java.lang.String quote, boolean tech)
Export to CSVjava.lang.String[]
parse(java.lang.String line)
Parse CSV string into string arrayjava.lang.String[]
parse(java.lang.String line, boolean trim)
Parse CSV string into string arrayjava.lang.String
serialize(java.lang.String[] fields)
Serialize string array into CSV stringjava.lang.String
serialize(java.util.List<java.lang.String> fields)
Serialize string list into CSV string
-
-
-
Constructor Detail
-
CSVTool
public CSVTool(char separator, char quote, java.lang.String cr)
Constructor: CSV tool (parser, ...)- Parameters:
separator
- Separator (e.g. ,)quote
- Quote character (e.g. ")cr
- Carriage return substitution (e.g. "%CR%"), can be a regular expression
-
CSVTool
public CSVTool(char separator, char quote)
Constructor: CSV tool (parser, ...)- Parameters:
separator
- Separator (e.g. ,)quote
- Quote character (e.g. ")
-
-
Method Detail
-
parse
public java.lang.String[] parse(java.lang.String line)
Parse CSV string into string array- Parameters:
line
- Input CSV string- Returns:
- Array of strings
-
parse
public java.lang.String[] parse(java.lang.String line, boolean trim)
Parse CSV string into string array- Parameters:
line
- Input CSV stringtrim
- Trim values- Returns:
- Array of strings
-
serialize
public java.lang.String serialize(java.lang.String[] fields)
Serialize string array into CSV string- Parameters:
fields
- String array- Returns:
- CSV string
-
serialize
public java.lang.String serialize(java.util.List<java.lang.String> fields)
Serialize string list into CSV string- Parameters:
fields
- String list- Returns:
- CSV string
-
csvHeader
public static java.lang.String csvHeader(ObjectCore obj)
Generates CSV header for object- Parameters:
obj
- Object- Returns:
- CSV headers
-
objectToCsv
public static java.lang.String objectToCsv(ObjectCore obj)
Converts object fields into CSV- Parameters:
obj
- Object- Returns:
- CSV data
-
cvsToObject
public static void cvsToObject(ObjectCore obj, java.lang.String csv)
Converts CSV message into object fields- Parameters:
obj
- Objectcsv
- CSV message (header + data)
-
cvsToObjectFilters
public static void cvsToObjectFilters(ObjectCore obj, java.lang.String csv)
Converts CSV message into object filters- Parameters:
obj
- Objectcsv
- CSV message (header + filter data)
-
objectListItemToCsv
public static java.lang.String objectListItemToCsv(ObjectCore obj, java.lang.String[] vals)
Converts object list into CSV- Parameters:
obj
- Objectvals
- List item data- Returns:
- CSV data
-
isListVisible
public static boolean isListVisible(boolean full, ObjectCore obj, ObjectField f)
Is field visible for CSV export in a multiple records context- Parameters:
full
- Full mode?obj
- Objectf
- Field- Returns:
- true if field is visible in a multiple records context
-
isFormVisible
public static boolean isFormVisible(boolean full, ObjectCore obj, ObjectField f)
Is field visible for CSV export in a single record context- Parameters:
full
- Full mode?obj
- Objectf
- Field- Returns:
- true if field is visible in a single record context
-
getVisibleColumns
public static java.util.List<ObjectField> getVisibleColumns(ObjectCore obj, java.lang.String mode, boolean tech)
Visible columns to export- Parameters:
obj
- Objectmode
- Export modetech
- Technical export- Returns:
- Visible columns to export
-
objectToCSV
public static java.lang.String objectToCSV(ObjectCore obj, java.util.List<java.lang.String[]> rows, java.lang.String mode, java.lang.String sep, java.lang.String quote, boolean tech)
Export to CSV- Parameters:
obj
- Objectrows
- Recordsmode
- Full or listsep
- Columns separator (default ;)quote
- Quote (default ")tech
- Technical fields- Returns:
- CSV data
-
-