Press "Enter" to skip to content

Convert Text to CSV Using Notepad or Notepad++

In notepad, convert text to CSV using the Replace command.

Text File Sample

7369 SMITH CLERK 7902 17/12/1980 800 20
7499 ALLEN SALESMAN 7698 20/02/1981 1600 300 30
7521 WARD SALESMAN 7698 22/02/1981 1250 500 30

Convert to CSV Example

  1. Open the text file in Notepad or in Notepad++.
  2. Press ctrl+H to invoke Replace window.
  3. Then in Find What type single space and in Replace with type a comma.
  4. Then click on Replace All button to replace all single space with the comma “,”.
  5. Save as CSV file.

Result

7369,SMITH,CLERK,7902,17/12/1980,800,20
7499,ALLEN,SALESMAN,7698,20/02/1981,1600,300,30
7521,WARD,SALESMAN,7698,22/02/1981,1250,500,30

This method will work if your text file is containing only one space between each column. If having multiple spaces or having complex data, then it is better to convert using Microsoft Excel.

See also:

  1. Split large CSV using PL/SQL
  2. Import CSV using Toad in Oracle

Have you found the answer to your question? If not, you can discuss it with me in the comments section below or join my Q&A community OrclQA.com for developers and ask your question. It is FREE.

Vinish Kapoor

Follow

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

guest
0 Comments
Inline Feedbacks
View all comments