On 03/17/2014 02:32 PM, Tanstaafl wrote:
I'm working on a little problem that I'd really like to resolve. It
doesn't really have anything to do with Libreoffice, other than I
thought I might be able to use Calc to do the sort...
I have a text file. Each line is one record.
I can use the raw windows Sort command to sort the file, and that
works fine, but I need to sort it based on the second column, not the
first, and the windows sort command doesn't allow this.
The columns are separated by a space, but to complicate matters, the
second column can contain multiple space separated words.
All I need to do is sort the file based on the text found AFTER the
first space on each line (ie, the second column).
Is it maybe possible to do this somehow with Calc on the command line?
Or, does anyone have any other ideas?
The problem is the second column. Can you regenerate the text file
easily such as requerying a database and saving the file with column
delimiter such as colon, semicolon, or tab?
If not and the file is not very large or has patterns. you can use, you
can open it to text editor like Notepad. Then systematically replace
each pattern such as "0 a" with "0;a" using Find/Replace.
Along this line if you know a scripting language such as Python, Ruby,
or Perl a script using regular expressions might work.
Once the file has been cleaned up, Calc can do the data sorting.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy