csv file changing format when opened from windows share

Joined
Sep 6, 2012
Messages
5
Reaction score
0
Points
1
The company I did some work needed to move all their files from a MAC server to a Windows server because the server was not trustworthy hardware wise.

Now I moved all the files to the windows server and created a share for the office MAC's to connect to.

In particular csv files which worked just fine on the MAC server are now not formatted correctly any longer. For instance, several columns of data which resided on ONE row now encompass several rows and are not usable. As if every 6-7 columns the row was chopped up and created a new row, dividing data that once lived on one row together.
 
Joined
Oct 1, 2007
Messages
7,163
Reaction score
275
Points
83
Location
UK
Your Mac's Specs
Mac Mini i5 (2014 High Sierra), iPhone X, Apple Watch, iPad Pro 12.9, AppleTV (4)
Just copying a file from place to place (allowing for corruptions) can't change it's format.

I'd suggest that the copying method applied some kind of transformation. Unix carriage returns for instance can create cross platform issues if the transformation of the file is not handled correctly.

I'd ask about how the files were moved and I'd also look at the files in a plain text editor and see if they contain extraneous commas at the points you have extra rows/columns.

Also, are you using the same application to open the files?
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top