CODEWITHSUNDEEP
replacenotepad++paste
Forever Learner
Forever Learner

Reputation: 1483

How to replace column of values with another column of values in notepad++

How to replace column of values with another column of values in notepad++ For example , Let's say I have file 1 contents as below

name2.address2.age.location
name3.address5.age.location
name1.address1.age.location
name4.address4.age.location

and I want to replace address column with the new values from another file 

A123
234
5678
adafsffsafasfa

so that my replaced contents look like this

name2.A123.age.location
name3.234.age.location
name1.5678.age.location
name4.adafsffsafasfa.age.location

I tried Alt+c and alt+shift combination, but that didn't help. Thanks for your time.

Upvotes: 0

Views: 14844

Answers (1)

Forever Learner
Forever Learner

Reputation: 1483

I was playing around and I accidentally discovered the solution to my problem. To replace a column follow the steps below:

1. Select the column using "`Shift + Alt + Down`" key combination 
2. Then delete the column by pressing the "`Delete`" key.
3. Select "new" column using "`Shift + Alt + Down`" key combination
4. Do the `drag` while holding down the `Alt` key.

Attached is the animation for better clarity. enter image description here Alt drag can be used for even shifting the column positions as well

Upvotes: 8

Related Questions