3 Replies Latest reply: Sep 11, 2009 8:06 PM by YoungIn
YoungIn Level 1 Level 1 (0 points)
Dear forum users, I hope somebody can help me with this as I have been using Excel up to now and just converted to IWork09
If I have some CSV data that I paste into a Numbers sheet, how can I then use the comma to separate the data into separate columns.

Thanks in advance

MacBook Pro, Mac OS X (10.5.1), 2.33Ghz 2GB Ram 80GB iPod Several PCs XP
  • 1. Re: Getting CSV into Seperate columns
    Jerrold Green1 Level 7 Level 7 (28,995 points)
    Youngin,

    I've not had any luck Pasting CSV data into Numbers. Better to create a TEXT file with a .CSV Suffix and Open it from the Numbers File Menu, or Drag the .CSV file to the Numbers Icon in the Dock. This will open a new Numbers Document from the .CSV file, with the data separated into columns as dictated by the commas. Now you can Copy the Table of data from the new Numbers Document and Paste it into your current Numbers Document.

    Regards,

    Jerry
  • 2. Re: Getting CSV into Seperate columns
    Level 8 Level 8 (41,760 points)
    two soluces

    (1) paste in a Word processor document, export it as text file with the extension name ".csv"
    If the used separator is matching Numbers requirements you will be able to import it in Numbers.
    The requirements are simple:
    if your system uses period as decimal separator, your CSV file must use comma to separate values.
    if your system uses comma as decimal separator, your CSV file must use semicolon to separate values.

    (2) you may use this script

    --[SCRIPT]

    if character 2 of (0.5 as text) is "." then
    set delim to ","
    else
    set delim to ";"
    end if

    -- set delim to "@" -- If your source doesn't match Numbers requirements, activate this instruction and edit the value to fit your needs.

    set the clipboard to my remplace(the clipboard as text, delim, tab)

    on remplace(t, d1, d2)
    local l
    set AppleScript's text item delimiters to d1
    set l to text items of t
    set AppleScript's text item delimiters to d2
    set t to l as text
    set AppleScript's text item delimiters to ""
    return t
    end remplace
    --[/SCRIPT]


    Copy your CSV datas
    run the script
    paste where you want.

    Yvan KOENIG (from FRANCE mardi 3 février 2009 17:07:59)
  • 3. Re: Getting CSV into Seperate columns
    YoungIn Level 1 Level 1 (0 points)
    Thanks it took me a few months to get to this!
    But the solutions are good.
    Regards
    MW