BrendonD
Level 1 (0 points)

Q: Advanced Find and Replace. How to replace space with carriage return?

10.9.13.0/24, 10.9.4.2/32, 10.9.4.3/32

 

 

into

 

10.9.13.0/24
10.9.4.2/32
10.9.4.3/32

 

 

Find replace ", " with carriage return.

 

I keep find articles about an advanced find and replace but I can't seem to locate it.

 

OS X El Capitan 10.11.3

Numbers 3.6.1

Posted on Feb 8, 2016 4:45 PM

by Yellowbox,Apple recommended
Yellowbox Yellowbox
Level 6 (10,550 points)
Mac OS X
A:

Hi Brendon,

 

In Numbers 3, click on the View button in the ToolBar

Screen Shot 2016-02-09 at 8.30.06 pm.png

Choose Show Find & Replace

Screen Shot 2016-02-09 at 8.32.29 pm.png

In the Find box, type comma space.

Insert a text box and type a single return character (press the enter key) and select that return.

Screen Shot 2016-02-09 at 8.37.59 pm.png

Menu > Edit > Find > Use Selection for Replace

Screen Shot 2016-02-09 at 8.39.03 pm.png

The return doesn't show, but it is there in the Replace box.

Click on Replace All to replace every occurrence in that document.


From Numbers Help: Find and Replace Text:

Screen Shot 2016-02-09 at 8.51.22 pm.png

Screen Shot 2016-02-09 at 8.40.45 pm.png

 

Regards,

Ian.

Posted on Feb 9, 2016 1:55 AM

Close
BrendonD

Q: Advanced Find and Replace. How to replace space with carriage return?

  • All replies
  • Helpful answers

Previous Page 2

  • by SGIII,

    SGIII SGIII Aug 25, 2016 7:12 PM in response to KittenPetter
    Level 6 (10,796 points)
    Mac OS X
    Aug 25, 2016 7:12 PM in response to KittenPetter

    KittenPetter wrote:

     

    I have a lot of names separated by Comma-Space and I want a list of names separated by CarriageReturns [CR].

     

     

    One of the easiest ways is to use a simple script. Just select, copy, click, and copy-paste.  No need to know AppleScript to use.  A few seconds and you're done.

     

    1. Copy-paste script below into Script Editor (in Applications > Utilities)
    2. Select the comma space-separated names and command-c to copy them to the clipboard.
    3. Click the triangle 'run' button in Script Editor.
    4. Click in Pages (or wherever you want the list) and command-v to paste.

     

    (If you've not run a script on your machine before yyou may need to make sure Script Editor is checked at System Preferences > Security & Privacy > Privacy > Accessibility.)

     

    SG

     

    (*

    converts  text in form of name1, name2, name3, name 4

    to:

    name1

    name2

    name3

    etc.

    *)

     

    set inText to the clipboard as text

    set text item delimiters to ", "

    set tempList to inText's text items

    set text item delimiters to return

    set outText to tempList as text

    set the clipboard to outText

    display notification "Click somewhere and command-v to paste"

Previous Page 2