?
Solved

Using Notepad++ Version 6.4.5 is there a way to make the first character on each row of data an Open Parenthesis and the last character a Close Parenthesis followed by a comma?

Posted on 2016-09-21
3
Medium Priority
?
163 Views
Last Modified: 2016-09-22
Using Notepad++ Version 6.4.5 is there a way to make the first character of each row of data an "Open Parenthesis" and the last 2 characters of each row a "Close Parenthesis" followed by a comma ?

In other words:

BEFORE

'   ABC Bank', '0180','PAYROLL'

AFTER

('   ABC Bank', '0180','PAYROLL'),
0
Comment
Question by:zimmer9
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 41809729
Hi,

you pres left Ctl + left Alt and then with mouse drag line in front of first character then the cursor will be spread across all lines and then just type "(".

For ")" repeat same procedure
notepad--.PNG
0
 
LVL 35

Accepted Solution

by:
Dan Craciun earned 2000 total points
ID: 41809791
In Find: ^(.*)$
In Replace: \($1\)-

Make sure Regular Expressions is selected and . matches new line is not checked.

HTH,
Dan
0
 
LVL 36

Expert Comment

by:Kimputer
ID: 41810263
Quickest method is from Dan (except for the typo that ends with - instead of ,)
That's because the Column editing as described by Haris is laborious for LONG text files.
1

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this tutorial viewers will learn to create a unique 3D lineart effect using the tilde key combinations in Illustrator Open a new document in Illustrator.: Locate the tilde key on your keyboard. It is usually in the top left and looks like a ~: Se…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question