Results 1 to 11 of 11

Carriage returns (Enter) in a range

Threaded View

  1. #6
    Forum Contributor
    Join Date
    07-01-2009
    Location
    Maine, USA
    MS-Off Ver
    Excel 2016
    Posts
    161

    Re: Carriage returns (Enter) in a range

    Here is an better example of cell content:

    "The Cisco Smart Install (SMI) feature is enabled on the remote host.
    If the SMI Client role enabled, it is subject to protocol misuse,
    which could allow an unauthenticated, remote attacker to:
    
      - Substitute the switch's startup-config file with a file that the
        attacker prepared and force a reload of the switch after a defined
        time interval.
    
      - Load the attacker-supplied IOS image onto the switch.
    
      - Execute high-privilege configuration mode CLI commands on the
        switch, including do-exec CLI commands.
    
      - Copy arbitrary files from the switch to the attacker-controlled
        TFTP server."
    Which would be better worded as:

    "The Cisco Smart Install (SMI) feature is enabled on the remote host. If the SMI Client role enabled, it is subject to protocol misuse, which could allow an unauthenticated, remote attacker to:
    
      - Substitute the switch's startup-config file with a file that the attacker prepared and force a reload of the switch after a defined time interval.
      - Load the attacker-supplied IOS image onto the switch.
      - Execute high-privilege configuration mode CLI commands on the switch, including do-exec CLI commands.
      - Copy arbitrary files from the switch to the attacker-controlled TFTP server."
    So to your questions:
    - remove ALL line breaks - Not ALL. Perhaps it should be only if the break is preceded by anything other than period or semicolon, then delete the break.
    - insert line break after every full stop (Period) - This could be modified so if it is a period (or a colon or semicolon) followed by two consecutive breaks, then leave the period, but only remove one of the two breaks.
    Do you want an empty line between each sentence? - No, as shown by the example.

    As for my original items.
    1. delete a char(10) - same as your first item - I really shouldn't do this one.
    2. replace char(10) followed by a space with only one space - Think this would be better that if the sentence beings with " - " and ends with two chr(10), replace with only one chr(10).
    3. replace two consecutive char(10) with only one char(10) - this one should probably be skipped as it could create other issues.

    Besides the example above, another is:

    This test gives some information about the remote HTTP protocol - the
    version used, whether HTTP Keep-Alive and HTTP pipelining are enabled,
    etc... 
    
    This test is informational only and does not denote any security
    problem.
    Which should look like:
    This test gives some information about the remote HTTP protocol - the version used, whether HTTP Keep-Alive and HTTP pipelining are enabled, etc... 
    
    This test is informational only and does not denote any securityproblem.
    Maybe it would be easiest to just have it:
    • if one break, delete it
    • if two breaks, delete only one
    • if three breaks, delete only one
    Last edited by mainemojo; 02-07-2018 at 12:49 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Carriage Returns when concatenating
    By Wendy Collins in forum Excel General
    Replies: 2
    Last Post: 11-17-2011, 01:48 PM
  2. Carriage Returns
    By Highbury_White in forum Excel General
    Replies: 3
    Last Post: 02-24-2010, 10:09 AM
  3. How Do I Get Rid of Carriage Returns?
    By Ocean Zhang in forum Excel General
    Replies: 23
    Last Post: 07-02-2009, 10:49 AM
  4. Carriage returns in the formula bar?
    By rubeus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-06-2006, 02:00 PM
  5. Delete Carriage Returns
    By Andre in forum Excel General
    Replies: 4
    Last Post: 12-01-2005, 07:35 PM
  6. Replies: 3
    Last Post: 11-17-2005, 03:10 PM
  7. VBA: Concatenate with carriage returns
    By Rob in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2005, 09:05 AM
  8. Carriage returns
    By tracyt620 in forum Excel General
    Replies: 1
    Last Post: 07-07-2005, 09:52 AM

Tags for this Thread

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