Results 1 to 11 of 11

Problems with CSV import due to comma in string

Threaded View

  1. #1
    Registered User
    Join Date
    02-06-2018
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2016
    Posts
    29

    Problems with CSV import due to comma in string

    Hi guys,

    I have a issue when importing .CSV file to Excel due to delimeter being a comma, but one of the values also has a comma included.

    How the data looks in the .CSV file
    "Level", "Type Name"
    "Level K2, #6399175", "Type 1"

    The trouble is with this value "Level K2, #6399175".

    When importing this is what comes out. See picture 1.

    How it should look. See picture 2.

    Could someone please explain what to do? I mean the delimeter is a comma, but how do I overcome that the value "Level K2, #6399175" includes a comma (as marked)
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Substitute alphanumeric string into a comma separated string
    By icyrius in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-09-2017, 07:16 AM
  2. Import from *.csv cuts off digits after comma
    By mary26 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2015, 12:52 PM
  3. how to Get all Strings Except last string in comma sepated string
    By narasappaj in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-20-2014, 07:05 AM
  4. [SOLVED] CSV file with a comma in some text fields how to import
    By etaf in forum Access Tables & Databases
    Replies: 4
    Last Post: 09-12-2013, 10:54 PM
  5. Import a Comma Deliniated List
    By maroonlover in forum Excel General
    Replies: 2
    Last Post: 05-26-2011, 09:49 AM
  6. CSV comma/semicolon problems
    By Hitch75 in forum Excel General
    Replies: 0
    Last Post: 01-27-2011, 05:05 AM
  7. Change delimiter in import function from comma to tab
    By marksince1984 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2006, 12:40 AM

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