It's a hideous formula, and there's GOT to be a better/neater way, but... it seems to work!
Code: Select all
=ArrayFormula('Raw import'!A:A&","&'Raw import'!B:B&","&'Raw import'!C:C&","&'Raw import'!D:D&","&'Raw import'!E:E&","&'Raw import'!F:F&","&'Raw import'!G:G&","&'Raw import'!H:H&","&'Raw import'!I:I&","&'Raw import'!J:J&","&'Raw import'!K:K&","&'Raw import'!L:L&","&'Raw import'!M:M&","&'Raw import'!N:N&","&'Raw import'!O:O&","&'Raw import'!P:P&","&'Raw import'!Q:Q&","&'Raw import'!R:R&","&'Raw import'!S:S&","&'Raw import'!T:T&","&'Raw import'!U:U&","&'Raw import'!V:V)
Oh, and I had to change the spreadsheet settings for "French", to make the graph work again, what with the commas vs semicolon thing.
I think beteljuice's php script is the way forward, at least for those that can use php on their server.
If not, feel free to copy that spreadsheet above and put your own dayfile.txt location in A1 of Raw Import and watch the magic happen