multiple table in one CSV support

[cheebusjeebus]

Hello sir, i have a CSV document and he contain 3 tables inside. the table looks like this (see below):

# Inventory
id,name,quantity,taste
0,sugar,12,sweet
1,parsley,29,herbaceous
2,oregano,6,bold
3,garlic,1,savoury
4,black pepper,,zesty
5,sea salt,8,strong

# Customers
id,firstName,lastName
0,John,Burgess
1,Stacy,Morgan
2,Pierre,
3,Reginald,Greene
4,Lacy,Woodstock

dish,rating
eggs & sausage,4.3/5
hamburger,4.8/5
,
phở,3/5

as you see, each table is separated by 1 empty line (and optional comment to denote table name). CSVLint identify as one table erroneously, and I can't cause him to interpret each table separately. How can i do this? Is he a unimplemented features? Thank you sir.

[cheebusjeebus]

i suppose he may be confusing... what if you CSV have one column, and record is empty? he may appear as separate table erroneously. maybe for best support of this, he should wrap empty record in quotes (""), or wrap all in quotes (safest). maybe user can specify somehow? there must be a way.

example (one table):

animal
dog
cat

bird
sheep
goat
pig
walrus

he would need to be:

animal
dog
cat
""
bird
sheep
goat
pig
walrus

or:

"animal"
"dog"
"cat"
""
"bird"
"sheep"
"goat"
"pig"
"walrus"

[cheebusjeebus]

i also find other example, where title are not comments (more preferable design i think, more universal):

[BdR76]

I see what you mean, but it's highly unusual to store multiple datasets in one file, where each table has different amount of column and data types. There's no csv standard that supports this type of multiple different datasets in one file afaik. Which app or system is providing these type of dataset files?

The closest "standard" I can think of is using a data package, where each dataset is one .csv file plus a json file that holds all the metadata of all the csv files.

So I'm sorry, but no I don't think this is something the plugin will support.

[cheebusjeebus]

@BdR76 i appreciate the feedback. i agree it's a rare occurrence. i sincerely apologize as i can't recall exactly where i've found this, but having worked with delimited files like these very frequently, i have encountered this "combined" style 2, maybe 3 times in different places

(to the best of my knowledge: 1 is a fixed-width video game datafile, 2 is a CSV real estate website data export for available apartments, 3 i forget him).

i think its rare enough to not support (he sounds complicated to implement too), and user can grep or awk to retrieve desired table of CSV.

[cheebusjeebus]

oh! i find one in my serialization file/database collection (he contain my personal datas though, so i can't share exact, i'm sorry).

he is a QFX file converted to CSV, and his style is a little different, but similar:

Available Fruit,Quantity,Introduction Year
banana,26,1994
grape,4,1996
orange,399,1997




ID,Vegetable,Price,Notes
0,carrot,0.39,
1,cucumber,0.99,almost expire
2,beet,0.76,

he is LF newlines, and 4 to separate tables.

(i search all collection, i only have him ^ saved, i'm sorry)