export/convert text from a numbers doc?

Discussion in 'Mac Apps and Mac App Store' started by Boomish69, Oct 18, 2014.

  1. Boomish69 macrumors 6502

    Boomish69

    Joined:
    Sep 13, 2012
    Location:
    London
    #1
    I have a column of text in Numbers which I want to copy the text from but can't seem to do it, does any one know how?

    EG I have 4 columns in numbers the first is full of text with Artist names , I want convert the fist column to a text doc like artist1-artist2-artist3 etc

    spent hours trying to find something on the web & copy & trying in pages & numbers..

    Appreciate any advice.
     
  2. kryten2 macrumors 6502a

    Joined:
    Mar 17, 2012
    Location:
    Belgium
    #2
    Have you tried selecting the first column --> copy --> open TextEditor --> paste --> Make Plain Text --> save your txt file. You can also try something like this :

    AppleScript Editor :

    Code:
    tell application "Numbers"
    	-- insert actions here
    	set mySheet to get active sheet of first document
    	
    	tell mySheet
    		tell table 1
    			-- Change the range to match your first column
    			set selection range to range "A2:A108"
    			set myValues to value of every cell of selection range whose value is not missing value
    		end tell
    	end tell
    	
    end tell
    
    set AppleScript's text item delimiters to return
    set contentToDump to myValues as string
    set AppleScript's text item delimiters to ""
    
    -- An ArtistNames.txt file will be created on your Desktop with the Artist names in it.
    do shell script "echo " & quoted form of contentToDump & " > ~/Desktop/ArtistNames.txt"
    
     
  3. saberahul macrumors 68040

    Joined:
    Nov 6, 2008
    Location:
    USA
    #3
    If your first column is:
    Header
    Artist 1
    Artist 2
    Artist 3

    And you want:
    Artist 1 - Artist 2 - Artist 3

    Then you can create a formula in another blank cell with:
    = A1 & " - " & A2 & " - " & A3

    And then copy that cell and paste into a text document.

    If you have a lot of rows, you can do the same as above, but:
    Type in B1:
    = A1 & " - "
    Type in B2:
    = B1 & " - "
    Drag down (gold icon in bottom middle of B2) to fill all cells in column
    Select last cell in column B and paste in text document like textEdit
    Remove the very last hyphen
     
  4. Boomish69 thread starter macrumors 6502

    Boomish69

    Joined:
    Sep 13, 2012
    Location:
    London
    #4
    ahhhhhhh what amazing replies thank you so much, trouble is I stupidly spent hours copying & pasting them one by one :(
    I knew there'd be a solution, I just tried it in text edit and posting with match style removes the table leaving the text hooray! At least I know now when I need to update it.

    Thank you both so much..I can't tell how much time I wasted on this one tiny silly thing.
     

Share This Page