denrich 4 Posted March 24, 2015 Report Share Posted March 24, 2015 Hello uboters, Anybody have a trick on how to save a ubot table to a csv file and the data won't jump from column 1 to column o. The data from column 1 has multiple lines sometimes so they will jump from column 1 to column 0 and I need them to populate in the same single column. Attached a few example of what I mean. Thanks for the help Quote Link to post Share on other sites
deliter 203 Posted March 24, 2015 Report Share Posted March 24, 2015 ubot starts at column zero,whereas most spreadsheets start at 1,try column 1&2,instead of 0&1 I can't get spreadsheets to work in Open Office if any one knows how to (related question I think) ?? they work fine on exel,I click the comma delimiter on startup,they used to work,a lot like the picture above,kind of all over the place @Denrich does the table look ok inside the debugger before saving yes?that would be the same for me Quote Link to post Share on other sites
denrich 4 Posted March 24, 2015 Author Report Share Posted March 24, 2015 Hey Deliter, thanks for the reply, I actually found my answer from this forum Quote Link to post Share on other sites
gavind 6 Posted March 25, 2015 Report Share Posted March 25, 2015 Hi Denrich, if it's not too much to ask, can you post the quick steps on how you got this resolved? This will be for users having this issue in the future. Quote Link to post Share on other sites
Digital101 4 Posted March 26, 2015 Report Share Posted March 26, 2015 You might want to try changing the delimiter to something other than a comma. The problem is that a lot of times you find commas in the data itself and that screws everything up. I have found that using semicolons rather than commas can fix the situation. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.