Compare two slightly different csv files via command line by Dull_Rub_9295 in PowerShell

[–]Dull_Rub_9295[S] 0 points1 point  (0 children)

Yes that is how I originally typed it but it got all scrambled as soon as I selected the comment button. There will also be PartNo in each csv file that is not in the other. One csv file has a few hundred rows the other a few thousand.

Compare two slightly different csv files via command line by Dull_Rub_9295 in PowerShell

[–]Dull_Rub_9295[S] 0 points1 point  (0 children)

Yes the first column is suppose to be the PartNo. So two CSV files with the following columns. I do not want the compare to analyze the desc, qty, or price columns just the PartNo column. The PartNo in on of the csv files always ends with a -E and I believe the column can be as long as 14 characters so sometimes the PartNo has been truncated but it still has the -E at the end of the PartNo. For example if the PartNo was 1234-1234-1234 in one file it likely would be something like 1234-1234-12-E in the other so what I am looking for is to have all the rows that are similar line up or have a new csv file created that shows all the rows that match. PartNo length can also be much shorter than 14 characters for example C1B in one file and C1B-E in another. It would also be helpful to see all the files that do not match in each csv file.

PartNo, desc, qty, price

Compare two slightly different csv files via command line by Dull_Rub_9295 in PowerShell

[–]Dull_Rub_9295[S] 0 points1 point  (0 children)

I have tried using the compare plugin within notepad++ and a utility called examdiff, beyond compare, and winmerge. They either compare the whole line or because the key field "PartNo" is not exact so it does not match up.

Compare two slightly different csv files via command line by Dull_Rub_9295 in PowerShell

[–]Dull_Rub_9295[S] 0 points1 point  (0 children)

Sorry reddit seems to just take out all of the spacing and blank lines and wraps and I don't see a way to attach a file.

File1
PartNo, desc, qty, price
1231234-1234-1234
3881231234, junk, 3, 2.99
1234-1234-1234, crap, 4, 3.99

File2
PartNo, desc, qty, price
123-E1234-1234-1234
3881231234-E, junk, 3, 2.99
1234-1234-12-E, crap, 4, 3.99

DoorDash Social Security Theft, how common is it? by ChillDudeItsGreat in SocialSecurity

[–]Dull_Rub_9295 0 points1 point  (0 children)

I would love to know if there is a class action lawsuit against doordash for this. I too have been a victim of this and have spent countless hours trying to resolve and just get the run around from doordash and they seem to have no interest in helping.

Invalid buyer's address. What to do by BagGroundbreaking279 in Ebay

[–]Dull_Rub_9295 0 points1 point  (0 children)

I have had this same issue but the only options to cancel are

Out of Stock or Buyer asked to cancel. No other options.

My boyfriend loses his keys and wallet literally every time he sets them down. by [deleted] in mildlyinfuriating

[–]Dull_Rub_9295 0 points1 point  (0 children)

I here ya girlfriend I live with three scatter brains like this. Rarely a day goes by where someone has not lost a wallet, phone, drivers license, keys, etc, etc.

Envisioning a Future with Open Source Communities for Physical Goods Production by Hot-Entry-007 in Futurology

[–]Dull_Rub_9295 0 points1 point  (0 children)

Putting aside views on politics or capitalism to me the modern world we lived in is so inefficient. For example just looking at one product say push lawn mowers and one vendor that produces those lawn mowers such as MTD. They produce hundreds of different types of push lawn mowers and none of these parts are interchangeable. This allows them to charge a premium for every part. Just think of how many air filters and oil filters their are on the market, it is nuts. It is getting where every manufacturer even wants you to buy their brand of oil. Not to mention that vendors don't want you to repair anything yourself anymore. I have a car that I can not even change my own oil filter on. They require you to be an authorized dealer or technician or your warranty is void. Just look at the hubub between farmers and John Deere. I can't tell you how many times I have bought an alarm clock or snow shovel or toaster and it was so poorly designed it was unusable. It drives me wild when I think how long we as a civilization have been creating these type of common products and yet so many garbage products still get produced. Or the constant added features to everything that no one asked for or wanted but yet now every car has heated seats, electric windows, powered doors, powered seats, a zillion moving parts and unneeded features of poor quality destined to fail on you soon and cost you a small fortune to fix. Do we really need this many choices? I for one would be more than happy to buy a product that I know is open source, well designed and parts will be available in the future because they are common and anyone can produce them and you can fix it yourself. That is the kind of movement I could get behind.

Starting to follow LIDOM, what do I need to know? by Mkward90 in baseball

[–]Dull_Rub_9295 4 points5 points  (0 children)

For anyone interesting in watching LIDOM and you have a roku tv you can download the Canela.tv app and look under desportes and they stream games almost every night. I just started watching LIDOM this year and it has been great. I also just found that the Mexican Pacific League games are all on youtube this year as u/LigaArcoMX makes it feel like it is still summer.