do you cats use any external libraries to parse CSV files?

i think there is snippets already from the N/file module that'll parse them

use https://www.papaparse.com/

http://netsuite.custhelp.com/app/help/helpcenter.nl?fid=section_157072584764.html I see... i was thinking about sample 3

can I load the papaparse min file in my define or do I have to import via relative path

im not sure what the difference between those 2 are

.split(/(?!\B"[^"]*),(?![^"]*"\B)/);

I split with this normally, it doesn't split commas in speech marks ^_^"

ok, thank you

if you are going to do it manually like that, you might want to use array destructuring to concisely pull out the columns to variables (assuming SS2.1)

Thank @stalbert I want to use the column headers instead of splitting on , and then counting the columns to get the data I want, that is the reason for the question in the first place

you'd probably already be done if you were using papaparse.

@stalbert @battk so one issue is I have to send papaparse a string of the CSV and the file is 170 MB so I can't load vs getContents, any way to get around this

hope there are no character escapes and use string splitting

That's what I feared but thought I'd ask

id actually look into modifying papaparse to support netsuite's file streaming