dirtylittlesql.com

dirtylittlesql.com copied to clipboard

Currently theres no info on what delimiters it supports and for sure it does no support a semicolon (;) and also option to skip n lines from top is often important as those can contain other information like column names, headers etc .

A CSV file stores data in rows and the values in each row is separated with a separator, also known as a delimiter. The most common delimiters are: a comma (,), a semicolon (;), a tab (\t), a space ( ) and a pipe (|). But theoretically anything can be a delimiter as long as it is consistent.

I've tried to make it as tolerant as possible without trying to cater for every permutation of CSV, because there are so many. Given a file with a 'csv' suffix it will assume it is comma separated (and ignore any leading lines). Given a *.txt file it will attempt to guess the delimiter based on the first x rows. It doesn't support space as a delimiter.

Is there a way to tell it that the delimeter is a colon? I've got a file with two values on each line separated by a colon, but can't get it to load.