Software

Ask something
Discussion Locked

Why saving as csv in excel don't work?

0 helpful
5 replies

by lauraa

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Why when I save as csv in excel is the resulting file still leaving spaces in the fields? I am exporting a crystal report into excel as an excel file. I am then saving as a csv file to drop the spaces for a web upload. The numeric fields are working fine; the first name, last name and middle initial fields are returning with the spaces for the default field size. When i try to do a save as with junk info in an excel file it works fine.

Any help???

5 replies

by dklippert

When you bring the data into Excel, change the extension to something like .DAT. The parsing wizard will then come up and you can clean up your import.
If needed there is the TRIM() worksheet function that will eliminate the spaces and then you can Past Special values to tidy things up.

by lauraa

The wizard did not appear when I tried to open as a dat file. This is a report that will need to be generated every two weeks so i need to find a solution that will stick and be able to be followed by an accounting dept user.

Anything else??????

by dklippert

Then choose some other three letter extension.
When you find one that invokes the Parsing wizerd, record a macro to duplicate the process

by lauraa

There must be something in the way the report is coming from crystal; all other excel reports i save as .csv work just fine, no spaces or anything, but this one just won't go. we've worked out a fix on the export to the web page that seems to be working. thanx though.

This discussion is closed to new replies.