Running a macro from the command line on a file that exceeds excels row/column limit

**Eoco** · 08-30-2013, 02:43 PM

Hi,

I have been using a useful VB script that goes through a spreadsheet row by row, checks for duplicate cells in that row, deletes all the duplicates and shuffles all the cells along so there are no blanks.

It looks like this:

Please Login or Register  to view this content.

However, I now need to perform the same operation, only on a CSV file that has 48,051 columns and therefore wont load in excel due to its 16,000 column limit.

Can I run the script from the command line on the file?

How could I go about doing this?

Thanks in advance!

**tony h** · 08-30-2013, 04:56 PM

that is a lot of columns.
There are a couple of ways to do this: being a CSV file this is basically a text file and the blanks will be caused by a sequence of two commas or maybe two commas seperated by blanks. Have a look in the file.
1. You can use a text editor maybe WORD and do macro which loops around a find and replace of find ", ," replace "," (using the relevant number of spaces) until no more finds

2. You could also use the OPEN FILE, INPUT LINE, PRINT with a bit of code to do this in any VBA or scripting eg EXCEL

Maybe you could post a couple of sample lines of data and a more complete answer maybe forthcoming.