Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
I work with spreadsheets for my business. The source files start out as csv, but change when I save them as spreadsheets. The spreadsheets are not used for math functions, only products & attributes. My business is an e-commerce site. Occasionally, items I have on my site become unavailable, so I need to update to remove the items. The problem is that I have so many items loaded, a 4 digit number, and the source files go into 5 digit numbers. It takes hours to manually do a visual comparison of product codes. Is there a program to compare 2 files for matching entries to flag the lines in the smaller file that either are or are not in the larger file?
You can use meld for this. It visually shows you the difference, and you can update one or the other with individual changes if you want. It's available in most distributions repository for installation.
If you are looking to delete items and the file is too large verify manually, you should be using a data base system. How do you verify the changes (deletions) are effective?
Actually if you store the copies in a spreadsheet, then the lookup fucntion should do.
At a glance, I am not sure meld will really help, but I will look again later. It does not seem to be on this DVD, but I can check others. I run on a live DVD, not installed. I was having trouble trying to multi-task, looking into meld while testing compare. I don't actually delete any items. Instead, I simply switch them to unavailable. In the admin area, I can see the availability status as yes or no. I tried compare both ways, from the small & from the large. In each case, it gave me a list of several deleted lines & numerous changes it was making. It kept crashing my system & I was unable to determine the cause or reason for the changes. Basically, I am hoping to find a way to distinguish the product codes that I need to switch off from those that I don't.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.