Timeline for =IMPORTHTML forces content to date format
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 25, 2020 at 21:49 | comment | added | Tedinoz | Some days it's just not worth getting out of bed ;) | |
| Nov 25, 2020 at 14:57 | comment | added | Rubén - Volunteer Moderator -♦ | See Tyler's answer | |
| Nov 23, 2020 at 2:13 | comment | added | Tedinoz | @Ruben Stunning. Please do write an answer for this formula. This is infinitely better (more concise, elegant, refined, less complicated/convoluted) than my effort. | |
| Nov 23, 2020 at 2:03 | comment | added | Rubén - Volunteer Moderator -♦ |
Here is a formula that is better than the one in my previous comment =ArrayFormula(REGEXREPLACE(SPLIT(TRANSPOSE(SPLIT(JOIN("",TRANSPOSE(QUERY(TRANSPOSE({IMPORTXML(A1,"//tr/*"),TRANSPOSE(SPLIT(REPT(REPT("|,",9)&"*,",33),","))}),,1000000))),"*")),"|")," {0,}- {0,}","-"))
|
|
| Nov 22, 2020 at 23:43 | comment | added | John Tokish | Thank you for the information everyone! | |
| Nov 22, 2020 at 9:34 | comment | added | Tedinoz |
@Rubén I tried to replicate the inclusion of column() in the Xpath as you did in Trying to use Google Sheets importHTML() to import a table. It forces content to a date format. This would simplify this answer. Needless to say, I didn't manage it ;) Are you able to weave your magic over the Xpath?
|
|
| Nov 22, 2020 at 9:26 | history | answered | Tedinoz | CC BY-SA 4.0 |