CODEWITHSUNDEEP
replacenotepad++paste
user2871554
user2871554

Reputation: 731

Notepad++ How do I insert a column of data?

So I am trying to take a column of text data and replace that data with edited information. I am trying to manipulate values in a fixed width file. I want to leave the rows intact. I know I can hold ALT and select a whole column of information but when I try to paste into the selected area Notepad++ just adds the information above the first row and deletes the column Ive selected. Please help, I have been researching for a while now and cant find anything on this.

Below I will try to explain a bit better, if I were to select the asterisks using Alt+mouse and I have a column of data that I have copied from another file how could I replace the asterisks but leave the other data intact?

1111122222**22233333333333

1111122222**22222223333333

1111111122**22222223333333

Upvotes: 73

Views: 129273

Answers (6)

DigitalNomad
DigitalNomad

Reputation: 1031

You can use ALT + Mouse to select the columns to copy the data and replace it. This animated gif is self explanatory.

enter image description here

Upvotes: 22

Ani Menon
Ani Menon

Reputation: 28229

Copy required text(columns) with Shift+alt and mouse (or arrows), then paste as required with ctrl+v.

Upvotes: 0

stedes
stedes

Reputation: 1571

If I understand your question correctly, you want to paste a certain text in front of all columns you've selected ?

  1. Either use ALT + Mouse or SHIFT + ALT + up/down arrow to select the desired number of columns.
  2. Either use ALT + C or Menu Edit -> Column Editor to enter the Column Editor.
  3. Fill in the "Text to Insert" and press Ok.

Good luck !

Edit: as pointed out in the comment, this is actually answered in Notepad++ How to paste string across multiple lines

Upvotes: 13

Gustav Delius
Gustav Delius

Reputation: 1953

If I understand the question correctly, you have copied the column of data from somewhere else and want to copy it as a column into notepad++. If you simply select a column in your notepad++ document and try to replace it with the external column, you will get many copies of that column. The trick is to first paste your column into an empty document (or into new lines in an existing document), then select that column you just pasted in but make sure you select it in column mode, i.e., while holding down the Alt key, and then copy it with Ctrl-C. Now you can column-select the column you want to replace and copy in your copied column with Ctrl-V

Upvotes: 125

psxls
psxls

Reputation: 6935

Replacing a column with new data is easy:

  1. Hold ALT + select with your mouse the column (you already did that)
  2. Press DELETE or CTRL + X to remove the old column
  3. Leave the cursor flickering in the same position (or wherever you want to add the new column)
  4. Paste CTRL + V

Note: you must NOT have your column selected when pasting. I think that's what confused you.

Upvotes: 1

gpanich
gpanich

Reputation: 39

ALT+Mouse works alright for me. I was able to replace the asterisks with other charactes. Maybe we have diferent versions? I don't think so, though.

Make sure you are also using Alt+Mouse when you select the information you want to copy. Not only when you paste it.

I hope that helps you.

Good luck!

Upvotes: 4

Related Questions