Skip navigation

Issue with deleting text from CSV file in Numbers

246 Views 2 Replies Latest reply: May 14, 2013 2:52 AM by Yellowbox RSS
gergenson Calculating status...
Currently Being Moderated
May 13, 2013 1:59 PM

We are converting an Exel File into a CSV File by way of Numbers, in an effort to upload contacts into my Contacts database on my MacBook Air.  The Contacts database does not like the CSV file and I am pretty sure it is because there is text in the phone number column.  So a cell may read

 

"Office:  323.555.1212"

 

 

Before I change 600+ cells by manually taking out the word "cell" or "office" from these cells, I wonder if there is a way to format the column such that the text is ommitted.  Thanks!

MacBook Air, OS X Mountain Lion (10.8.3)
  • Jerrold Green1 Level 7 Level 7 (28,175 points)
    Currently Being Moderated
    May 13, 2013 2:43 PM (in response to gergenson)

    Gergenson,

     

    The most likely reason that Contacts doesn't like your CSV files is that they don't have the right fields.

     

    The best, and only practical way, to format a table for eventual import to Contacts is to first create a Numbers table template with a record from Contacts. Drag a Contact from your Contacts app to a blank part of a Numbers Sheet. This will create a table with the proper columns for import to Contacts after you fill it with your external data. There will be only a few columns showing, so you must "Unhide All Columns". Then you will see, by looking at the labels in the Header Row, where you data must be located.

     

    Jerry

  • Yellowbox Level 4 Level 4 (3,900 points)
    Currently Being Moderated
    May 14, 2013 2:52 AM (in response to gergenson)

    Hi gergenson,

     

    Find and Replace in Numbers.

     

    Edit > Find > Show Search (command f) will bring up a search box:

     

    Screen Shot 2013-05-14 at 7.50.04 PM.png

     

    Click on Find and Replace.

     

    In the Find box, type Office: followed by two spaces (there are two spaces in your example).

    Leave the Replace box empty.

    Click on Replace All.

     

    Repeat this for Cell.

     

    That editing process will replace the Find text with nothing, and will leave the rest of the cell contents unchanged.

     

    Regards,

    Ian.

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.