Sidebar Sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

macOS Arg, data issue is driving me mad.

D

detz

macrumors 65816
Original poster
Jun 29, 2007
1,051
0
I've been sent a whole bunch of excel files from a client and I need to get that data out and make use of it in the app. The issue is the data is in excel, it's not consistent and has weird MS characters in it. The biggest issue is probably that the second column has everything from quotes to commas to newlines so if I try to export it as csv it breaks. I've tried exporting in ever type to see if there was a way I could parse it but I'm out of ideas. There must be a way, I mean excel and numbers both read the xsl and csv files correctly but I can't get anything else to.

Is there a way I can export this from one of these programs into a meaningful portable way?
 
L

lazydog

macrumors 6502a
Sep 3, 2005
709
6
Cramlington, UK
Are you sure the csv is broken? csv can handle quotes, commas and new line characters - fields are quoted if they contain the separator character and any quote characters are escaped (off hand I think a quote character is escaped as "").
The other thing you could do is change the separator character to something you know the data isn't using... perhaps ^, @ or $ and then export again.

b e n
 
GroovyLinuxGuy

GroovyLinuxGuy

macrumors regular
Apr 2, 2006
139
0
Canada
I don't know if this will work or not, but try opening the files in OpenOffice

http://www.openoffice.org/

It may allow you to save it as another format. I have done this in the past for weird acting excel and word docs and sometimes it works but conversly sometimes it doesn't.

Cheers
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom