Commas in numbers not handled by vector_paste()

[MilesMcBain]

Only just come across this great addin. Will be really useful!

However, I need to add that this is quite an important issue. Many official reports, especially those with budgets involved, quote numbers with the thousands separator (e.g. www.sfc.ac.uk/nmsruntime/saveasdialog.aspx?lID=19286&sID=11697).

There's a locale issue here also. In most continental European countries the comma is used as the decimal point marker.

Both of the above don't work well without manual intervention.

Originally posted by @drchriscole in #7 (comment)

[MilesMcBain]

E.g. trying to paste this as vector:

43,369,258 , -1,639,060 , 41,730,197

Gives this:

datapasta::vector_paste()
c("43", "369", "258", "-1", "639", "060", "41", "730", "197")

[MilesMcBain]

This turns out to be quite difficult in practice. I don't try to guess the separator for vectors since the heuristic I have for tables works on minimising the variance in number of columns per line.

So the split is just a simple comma or space split. readr guesses the type from there.