Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

How can I take union of two ods according to their column ?

What I want, more specificlly ;

  • first compare two ods according to column B
  • then merge them
  • if there is a intersection, ask me what to do

OR

  • compare two ods files
  • notify which one has same name, according to column B

Can you recommend me a software, which is available in 12.04, in order to manage one of these wish?

share|improve this question

1 Answer 1

up vote 0 down vote accepted

Rather than searching for a GUI tool, you may find it is quicker to export the data to character-delimited files and use the GNU tools for manipulating text files, like :

  • join
  • sort
  • diff

If you are not so inclined but don't mind spending a little money ($30), I find Beyond Compare 3 to be an excellent merge and compare tool, with a specific mode for data (although you'll still probably have to export to a CSV file).

Disclaimer: I have no financial interest in Scooter Software, I'm merely a happy user of their product on both Windows and Ubuntu.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.