Repository navigation
CSV import - skip some rows? #1554
Description
From #1553, accidentally created in the wrong area. 😉
Hi all,
Thanks for all your support to develop this apps and I very happy using this apps,
Can I request new feature??
I frequently import csv but need some adjustment (rename the column name) later because a lot of non-used row above my columns name.
would do you like to add option to skip some row? so I can use "column name in first line" and no need to do some adjustment on my table.
Thanks for your support.
Dani
Reacted by Guillaume
Activity
justinclift commentedon Oct 2, 2018
@paskandani This is the right spot to do feature requests.
And yeah, it's no worries getting it wrong the first time around. GitHub can take a bit of getting used to, but it comes with practise. 😄
With your request, I'm trying to picture in my head what you mean by "skip some rows" + needing to rename the column?
I can imagine what skipping some rows does (eg don't import row say 2-50), but I'm not sure how that ties in with your normally needing to rename columns afterwards?
Is it something that would be clearer if you show a screenshot of an example import? Maybe showing stuff you're normally delete (before deleting it) and pointing out what you need to have skipped + what needs renaming?
That would probably give us the information we need, to understand what needs changing. 😄
paskandani commentedon Oct 3, 2018
Hi @justinclift
I'm sorry put request in wrong, im newbie with github.
Below example which I usually used by excel to import report text file as below.
Im will not use row 1-3 and use row 4 as my column name. So i select start import row to 4 and check the Mydata has header.
justinclift commentedon Oct 3, 2018
Ahhh yeah, that makes sense. It's a decent idea, and probably won't be hard to add. 😄
It probably won't be added for the next major release though, as we're trying to finish up stuff in preparation for that and we already have a pretty huge list of stuff to do. 😇
skyhirider commentedon Jul 7, 2024
Could this be added? I ran into the same problem, had to import several files where I needed to skip the first row and use the second one as the header.
Had to manually open each one, remove row, save then use import.
Having the tool do it for me would have been a time saver.