D
David
I have a user that when they try to open a CSV file from the desktop or any
other location the file does not open correctly. When the file is opened on
other machines using Excel it opens correctly.
What seems to be happening is in column A we are getting the first 14
characters of the line and in column B we are getting the next 10 characters
and in column C we are getting the rest of the line. The system is not
parsing the record out because we are still seeing the quotes and commas in
the columns.
When we run the text to columns wizard on column C it parses out the record
correctly.
I am not sure what the issue could be that is opening the file in a "fixed
with" method ... because this is happening it seems on all CSV files.
The user tried to reinstall Excel and I personally did a repair on Excel and
the issue is still present.
Any ideas?
David
other location the file does not open correctly. When the file is opened on
other machines using Excel it opens correctly.
What seems to be happening is in column A we are getting the first 14
characters of the line and in column B we are getting the next 10 characters
and in column C we are getting the rest of the line. The system is not
parsing the record out because we are still seeing the quotes and commas in
the columns.
When we run the text to columns wizard on column C it parses out the record
correctly.
I am not sure what the issue could be that is opening the file in a "fixed
with" method ... because this is happening it seems on all CSV files.
The user tried to reinstall Excel and I personally did a repair on Excel and
the issue is still present.
Any ideas?
David