+ Reply to Thread
Results 1 to 2 of 2

.CSV Files

  1. #1
    Roman
    Guest

    .CSV Files

    My csv file is delimited by commas and text is delimited by ". My file
    considers carriage returns and next line characters enclosed in " as
    text. I am facing a problem when trying to open this file in excel.
    The excel doesn't care that next line character enclosed by " and
    thinks it is the end of a record. Is there a way to excel that
    anything inside " should be treated as text?

    Thanks in advance


  2. #2
    Forum Contributor
    Join Date
    12-12-2005
    Posts
    667
    When Excel reads a .CSV file it will separate data by a single divider such as a comma or by fixed lengths. It does not use more than one separators.
    If I were you I would replace all the apostrophes, " , with a comma. I would edit the resulting worksheet.
    Best regards,

    Ray

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1