LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mwarner
 
Posts: n/a
Default unexpected line breaks in .csv

I have a spreadsheet with around 125 records and 130 fields. Not all of the
fields are populated for all records; several of the fields have no entries
at all.

When I save the file in .csv format, each record gets a line break in a
different place. I can't correlate it with the length of the record in
characters or fields, or with which fields are/aren't populated. It appears
that each record is being broken into 4 pieces.

This makes it impossible to import the file into the target application.
Can anyone help me eliminate or at least learn how to work around the
problem??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I get excell to ignore line breaks? LindaC Excel Discussion (Misc queries) 3 June 14th 05 08:20 AM
manual line breaks cwee Excel Discussion (Misc queries) 2 April 21st 05 05:48 PM
Adding line breaks by using find and replace soozie Excel Discussion (Misc queries) 3 March 6th 05 11:04 PM
Line breaks KatoKat Excel Worksheet Functions 1 March 1st 05 10:04 PM
can i save an existing .xls file as a .csv file using command line craigkan Excel Discussion (Misc queries) 2 February 18th 05 02:01 PM


All times are GMT +1. The time now is 12:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"