UPDATE: I am leaving my original answer just in case it might be helpful if the answer above, which includes undocumented functionality, does not continue to work. So, if you wanted to force a file to be split on the TAB character, it would look something like IMPORTDATA("url","\t") In effect the documentation should look something like the following: IMPORTDATA("url","delimiter") As of writing this, the official documentation makes no reference to this delimiter. In a comment below, Poul shared that he has found an undocumented parameter for the IMPORTDATA() function by which you can specify the delimiter to split the data. SUMMARY OF THE ISSUE: By default the IMPORTDATA() function will properly process a tab-delimited file only if the file name ends with the extension. ![]() I am posting the answer here in hopes that someone else who googles their way here will be saved the headache and can be helped by how I devised a solution. ![]() NOTE: I know this question was asked back in 2014 and I am answering this question some 5 years later.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |