Hi,
I have a file with 2 column worth of data as in the figure. I’ve been trying to find a way to save these two columns in a single csv format file but have not see any ways to do this in Sublime. Please, let me know if there is any trick to do this. Thanks.
It’s a bit unclear from the description, but assuming there are the exact same amount of rows in both tabs and you want to end up with two columns in the left tab, this is what I would do (key bindings should work on Windows):
CSV are just text files, there’s nothing special you need to do to save as a CSV. If you want lots of CSV-specitic functionality a spreadsheet will probably work best.
The spreadsheet works fine for small number of rows and columns. Anything above 10,000 or more rows and columns, any spreadsheet apps will struggle. However line editors such as Sublime can efficiently display and manipulate such an extremely big array of texts. The issue with Sublime is that it saves each individual columns into separate files. It will be great Sublime has a capacity to save the file with multiple columns into some sort of tabular format.
The OPs screenshot shows a 2 column layout of views into unrelated files.
This kind of displaying/aranging content of 2 files is completely unrelated with columns of spreadsheets.
Thus saving content of 2 or more individual views into a single file is definetely not a use case of ST or any other multilayout text editor.
Note that any kind of layout with any number of columns and rows is possible in ST.
I just loaded two million line files in LibreOffice Calc and performance is perfectly fine - significantly better than making a million multi-line edits in Sublime Text. If the spreadsheet app you’re using can’t handle 10k rows or columns then I suggest finding a better one.