Parsing a Delimited CSV File in Coveo

I was trying to find a way to take a single CSV file containing addresses, and parse each address into it’s own document.
The file had an address on every line, and was delimited with a ‘|’.

11||PARK|ST||01001|1113|AGAWAM|MA|N
21||STATION|ST||02108|1120|BOSTON|MA|N
27|A|GEORGE|ST||01944|1129|MANCHESTER|MA|N

After posting on the forums about getting this to work with the File Connector, I was told that the Database Connector was better suited for this.
https://answers.coveo.com/questions/4542/how-to-index-a-file-from-a-file-connector-source

To set this up there were a couple of moving pieces, so I thought I’d detail them in this blog post.
Read More