How to copy or paste a whole column

You can quickly transfer data between Direct Commander and other apps (like spreadsheets and word processing applications) or within Direct Commander itself by copying and pasting the contents of entire columns. You can use this method of bulk editing for fields with values that can be copied as plain text.

Example: correction of "broken" links

You can copy data from the Link column to a link verification program, fix broken links, and paste them back.

Copying

Right-click on a column title in a Direct Commander tab and select Copy from the menu.

The column content is copied to the clipboard, and then you can paste it to another column, spreadsheet, text editor, or messenger.

Pasting

1. Copy the data column to the clipboard.

2. Right-click a column title in a Direct Commander tab and select Paste from the menu.

How data is pasted:

• The column values are pasted into displayed objects regardless of which of them are selected. If you want to paste data into certain objects (rather than all of them), select relevant objects using quick search or query language first.

• Objects with the specified field blank are skipped. For example, in the Title 1 column values are pasted into Text & Image Ads, as if there were no image ads in the tab.

• If the pasted data contains more values than there are objects on the tab, then:

  • If multiple parent objects are selected (for example, when pasting data in the Ads tab you have selected multiple ad groups selected in the Groups tab), the "excessive" values are ignored.

  • If a single parent object is selected, new child objects are added. The type of new objects depends on which types have the pasted field. For example, when you paste ad text, only Text & Image ads can be created. When you paste links, either Text & Image ads or image ads are created, with the first object on the tab determining the ad type (except for video ads, which cannot be created in Direct Commander).

• Empty rows at the end of the pasted data are ignored. Blank rows in the beginning or middle of pasted data clear the corresponding fields in Direct Commander.