I have a comma seperated file and would like to remove an empty column from this file.
For example, the file could be:
a,,b,c a,,b,c a,,b,c
This means that the second column is empty. The resulting file then should be
a,b,c a,b,c a,b,c
This should work for more than one empty column. Does anyone know how to remove such blank column or columns from a comma separated file:confused: