- Goal: process CSV file and import in PostgresSQL (FTP → CSV → PostgreSQL)
The issue I’m running into is that my CSV files have quotes around every field and the CSV processor seems to error on this.
I’ve tried adding a regex expression on the mapping here but it didn’t work as the mapping only does it thing after the data is parased and its a parsing error.
So then I realized I need to remove the quotes prior to the CSV module so I used the text parser to remove the quotes.
This works, but not then the CSV module won’t process the csv based text. I don’t get a bundle anymore.
I’m not too sure where to go from here… thoughts?