Forum Discussion
Excel Problem with Importing .csv file with carriage return in a field
GeoffCommdirect The only way I could replicate the problem is by using the text import wizard on a Mac. See first picture.
Just opening the csv file from within its folder/directory opens it without fault, but with a warning for "Possible Data Loss". But that's no problem. Just save as a regular xlsx file. See next picture.
In windows environment, importing via "Get & Transform", without any change in settings, causes no problems. See next picture.
And directly opening the file has a similar effect as on a Mac. No fault (just ignore the number formats in B and C) but the same "Possible data loss" message.
Are you on a Mac? If so, perhaps not "best practise" but in this case, just open the file, i.e. don't import.
Riny,
Thank you for the advice, however we currently use the Excel Data\From Text import as we have fields that contain greater than 15 numbers in a string normally 16 characters.
If we open the file in excel the row does not wrap after the carraige return, however excel converts any numbers after the 15th character to a zero , thus currupting the data we are trying to import.
So the carriage return not being interpreted by excel in the import causes us a problem even though when import we have the Tesxt qualifier as " and the the file being imported uses " " to define the contents of the field.