How to remove trailing commas from a CSV file?

[BrentCOS]

Hi,

I've created a CSV file that has no header. Each row represents a customer order and each cell in that row contains an item from that order. An order can have 1 item or up to 45 items in an order. The problem is that Excel is placing a lot of commas at the end of each row and I'm trying to use the CSV file in a machine learning algorithm w/in Python and it doesn't like the commas. Any idea how to remove them? I've Googled exhaustively for a solution but nothing has worked.

What my file looks like now (Excel doesn't show you the commas but when I open the file in Notepad ++, you can see all of them (see 2nd screenshot below))

When the CSV file is opened in Notepad ++, you can see all of the commas:

 

[6StringJazzer]

When a csv file is generated, all rows must have the same number of fields, and this number will be based on the longest record. You could do a find and replace in Notepad++ by checking Regular Expression and replacing this

,*$

with the null string.

If you do this frequently a VBA solution could open and edit the csv file treating it as a text file.