Community
    • Login

    Can't use search/replace against a .csv to create one long string

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    2 Posts 2 Posters 2.1k Views 2 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Jeff TaylorJ Offline
      Jeff Taylor
      last edited by

      trying to figure out how to Search/Replace a .csv to remove the carriage return but keep the value and comma

      BEFORE:
      value1,
      value2,
      value3,
      value4,
      etc

      AFTER:
      value1,value2,value3,value4,etc

      Notepad ++ can’t seem to find the character so that I can replace.

      Appreciate the help

      Jeff

      1 Reply Last reply Reply Quote 0
      • Claudia FrankC Offline
        Claudia Frank
        last edited by Claudia Frank

        Hi Jeff Taylor,

        using the replace dialog.
        Set Extended in Search Mode
        Find what: \r\n
        and leave Replace with empty
        press Replace All
        Done

        Cheers
        Claudia

        1 Reply Last reply Reply Quote 0

        Hello! It looks like you're interested in this conversation, but you don't have an account yet.

        Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

        With your input, this post could be even better 💗

        Register Login
        • First post
          Last post
        The Community of users of the Notepad++ text editor.
        Powered by NodeBB | Contributors