Add example of how to read CSV files and specify a delimiter

[xiaodaigh]

I can never figure out how to set the delim reading the readme.

It would good to actually add an example instead of just having the signature.

I tried

FileIO.File(format"CSV", delim='|')

FileIO.File(format"CSV"(delim='|'))

neither worked.

[davidanthoff]

The real issue is that for really no good reason delim is not a keyword argument, but a positional argument. I think that is the thing we should actually really change.

[xiaodaigh]

So given where we are at, how do I set the delim?

[davidanthoff]

Right now? Just the second argument: load("foo.csv", ';').

[xgdgsc]

What if the file suffix isn' t ".csv"?

[davidanthoff]

I believe load(File(format"CSV", filename)).

[xiaodaigh]

full working example

using DataFrames, CSV

CSV.write("a.txt", DataFrame(a=1:3, b = 1:3), delim='|', writeheader=false)

using FileIO, CSVFiles

@time a = load(File(format"CSV", "a.txt"), '|', header_exists=false) |> DataFrame