• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
logo

Tutsplanet

Free Technical and Blogging Resources

  • Home
  • Web Hosting
  • Programming
  • Plugins
  • Write For US
  • News
  • About Us
  • Snippets
You are here: Home / General / Replace “\n” with new line characters, using Notepad++

Replace “\n” with new line characters, using Notepad++

Jan 4, 2017 by Editorial Staff Leave a Comment

Due to bad formatting you will encounter the below scenario in your day to day work. You may want this file to convert to Excel/CSV.

Replace "\n" with new line characters, using Notepad++Replace with new line characters, using Notepad++

Replace "\n" with new line characters, using Notepad++Replace with new line characters, using Notepad++

First of all, you want to convert the escaped newline character to real “\n”. You can easily do this via using Notepad++(a free source code editor which supports several programming languages running under the MS Windows environment.).

Step 1

Load your file in the Notepad++ or copy/paste the content to Notepad++ new file.

Replace with new line characters, using Notepad++

Step 2

Select the Select -> Replace from the menu or hit Ctrl+H, to appear the replace dialogue. Fill out your values as per the below picture.  Most importantly make sure you select Extended(\n,\r,\t..) radio button in Search Mode.

Replace with new line characters, using Notepad++

Click the Replace All button, and all the escaped newline characters will be replaced with an original newline character.  And you will see that instead of a single line, it will be coming in one column. To convert to CSV you can just rename the extension of the file to .csv in my case images.csv.

Hope this helps.


Editorial Staff

Editorial Staff at Tutsplanet is a dedicated team to write various tutorials about subjects like Programming, Technology and Operating Systems.

View all posts by Editorial Staff

Filed Under: General

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar




Quick Links

  • A Simple YouTube Video Downloader Script in PHP
  • The 50 Most Useful jQuery Plugins for Frontend Development
  • Base64 Decode Online
  • Base64 Encode Online

Subscribe

* indicates required

Share

   

Hot topics

  • A Simple YouTube Video Downloader Script in PHP 270 views
  • Replace “\n” with new line characters, using Notepad++ 242 views
  • Add FTP/SFTP in Visual Studio Code 177 views
  • Open a URL in a new tab using JavaScript 141 views
  • Using Third-Party Libraries in Codeigniter 140 views
  • Upload Multiple Images and Store in Database using PHP and MySQL. 130 views
  • Laravel Image Intervention Tutorial With Example 125 views
  • Hierarchical Tree view Category Example in Laravel 112 views
  • Spout, an awesome library for reading and writing in Excel. 102 views
  • Manually Install APK Files In Android Studio Emulator 98 views

Categories

  • Design & Development
  • Drupal
  • Facebook
  • General
  • How To
  • ios
  • Javascript
  • Linux
  • Magento
  • Marketing
  • News
  • PHP
  • Plugins
  • Programming
  • Snippets List
  • Social Media
  • Softwares
  • Themes
  • Tips
  • Wordpress
  • YouTube

Copyright © 2021 · TutsPlanet Gene Theme on Genesis Framework · Powered By BunnyCDN