Removing Columns about rapidcsv

[jtaylorme]

Thanks. Enjoy your vacation.

[jtaylorme]

Thank you VERY much. I will give it a whirl.

[jtaylorme]

I think it may also be removing the wrong column header, at times, and/or not removing the column header. I tried saving and reloading the csv file after 3-4 removals to overcome the problem but am getting errors about columns not existing, even though i hadn't removed them yet. When I look at the file I find headers I already deleted along with ones missing that I haven't deleted. Seems to add weight to my earlier guess.

jim

[jtaylorme]

As far as I can tell, deleting by Index works as expected. I tried deleting from left to right and right to left and both approaches worked.

Jim

[d99kris]

Thanks for reporting the issue. I'll try to look into this.

[jtaylorme]

Did some experimenting and as far as I can tell. It is keeping the original header list on RemoveCol. It removes the column in the data but if column names are being used it doesn't remove it from the header reference data. Didn't test row names but probably want to check that as well. I put in a message box and, for example, if Item# is in column 8 and I delete a couple of columns prior to column 8 and tell it to show what column Item# is in it still tells me it is in column 8. Hope this is accurate info and it helps. May also want to verify that Insert Column/Row is updating name reference data as well. Thanks again.

[jtaylorme]

Thought I had it fixed and was going to send code for what I did but I am apparently missing how the header names are maintained. I would remove the appropriate one but it wasn't changing the original, apparently, so it would come back with the original header mapping on the next Remove :-(

[d99kris]

I can also reproduce the problem and have some idea on how it can be fixed. I'm not sure when I can get it done though as I'm going for vacation this week and next, but will update here in case I get something in.

[jtaylorme]

Thought I had it fixed and was going to send code for what I did but I am apparently missing how the header names are maintained. I would remove the appropriate one but it wasn't changing the original, apparently, so it would come back with the original header mapping on the next Remove :-(

[d99kris]

The above commit should fix accessing by labels after document edit, such as insertion or removal of rows/columns. Let me know if there are still any issues relating to this. Thanks!

[jtaylorme]

As far as I can tell that did the trick. Haven't tried rows but column stuff seems to be in order now. Thanks again.

[d99kris]

Good to hear! 👍