commons.cfm

<!--- https://commons.apache.org/proper/commons-csv/apidocs/org/apache/commons/csv/package-summary.html --->
<cfset oCSV = createobject( "java", "org.apache.commons.csv.CSVFormat" )>
<cfset oParserObj = createobject( "java", "org.apache.commons.csv.CSVParser" )>
<cfdump var="#oParserObj#" expand="false">

<cfset oIOFile = createobject( "java", "java.io.File" ).init( expandpath( "./CLIENTIMPORT.csv" ) )>
<cfset oCharset = createobject( "java", "java.nio.charset.StandardCharsets" )>
<cfset oFormat = oCSV.EXCEL.withDelimiter( "|").withFirstRecordAsHeader().withQuote(javacast("char","")).withRecordSeparator("\r\n")>

<cfdump var="#oIOFile#" expand="false">
<cfdump var="#oCharset#">
<cfdump var="#oFormat#" expand="false">

<cfset oParser = oParserObj.parse(
	oIOFile,
	oCharset.UTF_8,
	oFormat
)>
<cfdump var="#oParser#" expand="false" label="oParser">
<cfdump var="#oParser.getHeaderMap()#">

<cfset arrRecords = oParser.getRecords()>
<cfdump var="#arrRecords#">
<cfloop array="#arrRecords#" index="oRecord">
	<cfdump var="#oRecord.toMap()#">
</cfloop>