What is your goal?
I’m trying to parse a csv from the state of California and want it to email me the relevant data (just the stuff in my county).
What is the problem & what have you tried?
However, the first line of the csv is a status. The column headers starts on line 2. I’ve tried a clean data tool with {{replace(toString(3.data); “/^.*?\n/”; “”)}} and then forward it on but the csv parser still isn’t recognizing the column headers when I try to do a filter and move it into the array aggregator.
Create public scenario page
https://eu1.make.com/public/shared-scenario/JZ53X5aoVjH/integration-http-archive-text-parser
Hey there,
can you show some screenshots or share a sample here for testing?
Here’s a screenshot of the csv. I’ve also made my scenario public. I only need the license of type 47, the name, address, city, and only the ones from specific counties.
I’ve also made my scenario public.
Hey I was able to do it for you basically you had it so close. Needed to add the name of the headers in. Then you will be able to map it in the aggregator.
Be really careful the file is so huge is causes MAKE to lag a lot if you use an iterator on the csv you will blow through every operation. Make sure you use the map function after your array aggreagator and filter on your city.
This is the first file so it has everything. Subsequent ones won’t have that. Thank you so much!
1 Like
