CSV Processor

CSV [csv]

This processor allows you to extract fields from a string that is in a CSV format. The CSV can have any separator and works only if the columns are in the same order. This processor also allows you to convert the fields after they are extracted to different formats.

• field - required
• targetField (optional)
• separator (optional)
• quoteChar (optional)
• columns [array] (optional) - if you don;t it will show the fields as numbers
• autoGenerateColumnNames [boolean - default = true]
• skipEmptyColumns required [boolean - default = false]
• convert [this is a json object with key:values where the key is the field and the value is the type as specified in the Convert processor] (optional) EG

Example

{
	"steps": [{
		"csv": {
			"config": {
				"field": "message",
				"separator": "/t",
				"columns": [
					"Shipment",
					"OrderDT",
					"PrintDT",
					"ShipDT",
					"Commitment",
					"DelvDate"
				],
				"skipEmptyColumns": "false",
				"autoGenerateColumnNames": "false"
			}
		}
	}]
}