Login to follow
CsvUtil

CsvUtil (ODC)

Stable version 1.0.4 (Compatible with ODC)
Uploaded on 01 April 2025 by BlueMeme Inc.
CsvUtil

CsvUtil (ODC)

Documentation
1.0.4

Instructions for Loading
1. Add the dependencies that allow the usage of the component


2. Understand the configurations

- Encode: Encode of Binary File. (Default is utf-8, see here for available encode names)

- IsSkipHeader: Whether skip first head line (Default is true)

- IsIgnoreColumnChange: Whether ignore or raise error if # of fields changed (Default is true)

- FieldDelimiter: Delimiter of the field (Default is comma, use Chr(9) for tab)

- IsDisableDoubleQuote: Disable double quote enclose/escape.(Default is true).
 Set to false ONLY IF your data DO NOT contain comma/CR/LF/double quote

- IsDropCommentRow: Whether drop the row that started with # (Default is true)

- CustomHeader: Custom Header Row. Use this if your CSV has No Header or Need Override JSON Property

3. Convert CSV to JSON
Call CsvToJson Action to convert CSV to JSON


4. Deserialize JSON to List



Instructions for Exporting

1. Add the dependencies that allow the usage of the component



2. Understand the configurations

- Encode: Encode when exporting Binary. (Default is utf-8, see here for available encode names)

- HasBOM: BOM when exporting Binary. (Default is false, Learn more here)

- IsShowHeader: Whether export head line (Default is true).
 If CustomHeader specified,export CustomHeader as head line. Otherwise, export the name of Attributes as the headline..

- FieldDelimiter: Delimiter of the field (Default is comma, use Chr(9) for tab)

- EncodeMode: Mode of escape special characters (Default is auto)
 auto: Automatically escape if need
 quote: ALWAYS escape
 noquote: DO NOT escape but will throw exception if there are special character included
 noquote_nocheck: DO NOT escape

- LineSeparator: Line separator (Default is CRLF)

- CustomHeader: Custom head row when IsShowHeader is enabled


3. Serialize List to JSON

You MUST set [Serialized Default Values] to Yes


4. Convert JSON to CSV
Call JsonToCsv Action to convert JSON to CSV