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?

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'),
zimmer9Asked:
Who is Participating?
 
Dan CraciunConnect With a Mentor IT ConsultantCommented:
In Find: ^(.*)$
In Replace: \($1\)-

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

HTH,
Dan
0
 
Haris DulicCommented:
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
 
KimputerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.