CSV data contains quotes on every field

How To
,
1

- 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.
image

image
image402×623 28.1 KB

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.

image
image1023×473 34.2 KB

This works, but not then the CSV module won’t process the csv based text. I don’t get a bundle anymore.
image

I’m not too sure where to go from here… thoughts?

2

Welcome to the Make community!

Could you please upload your CSV file here?

Save the contents in your text editor, and upload it here into this discussion thread.

Uploading them here will look like this:

csv-file.csv (12.3 KB)

This will allow others to better assist you. Thanks!

2 Likes
3

Won’t let me upload csv files…? can only be pictures, pdf file.

Here is a sample table of the csv. Here is a link->

DATETIME LAeq LAFmax LA10 LA50
2/4/2024 0:01 45.14 47.56 45.85 45.08
2/4/2024 0:02 44.4 48.08 45.27 44.1
2/4/2024 0:03 44.16 46.81 45.16 44.12
4

try renaming it to .txt extension.

2 Likes