Column Mode in UltraEdit

Simple editing in column mode

To enable column mode, press Alt + C, or click Column mode in the Edit tab.

You can configure a custom font for column mode so that it’s obvious when the editor is in column mode. To do this, go to View » Fonts » Set hex / column mode font. For this tutorial we’ve chosen a bold version of our standard font.

Column mode is useful for many things; even simple file editing is faster with column mode. In the sample Python script shown below, we have a section of code that needs to be commented out of the file. Instead of manually typing in the line comment char “#”, you can hold the caret in position on the first line of code, then drag downward to the last line to be commented out. You now have a multiline 0-width caret position.

Once the caret is positioned correctly, you can type the string, and the entire block of code will be commented out of the document.

You can also use column mode to manually prepend or append sets of data spanning a column. In the following sample data, we would like to add a character to the beginning of each value after the “=” character. The added character will be the same for all values. As before, click and drag to create a “multiline caret” to insert the new character.

You can prepend an entire column of data, with the same character, by simply typing.

Insert / fill columns

The “Insert / fill columns” command in the “Column / block” group of the Edit tab allows you to enter a text string into a specific column in your data. If a column is selected, the string will be inserted into every selected line. However if nothing is selected, the string will be inserted into all lines in the file. If there is no text data at the specified column on a row within the file, spaces will be added to pad the row, thereby allowing the text to be inserted in the correct position.

In the below sample data, we need to add a new field to each row of SQL data. This can be done using the manual methods described above, but it would be much easier and faster with the “Insert / fill columns” command.

Position the cursor in the appropriate placement of where you need to insert the data, and then select the “Insert / fill columns” icon in the Edit tab.

You are then prompted for the string to insert.

Type this in, and then press OK.

As shown in the above screenshot, UltraEdit inserts the string in the caret-specific position on every line. If a selection had been made, the string would have been inserted into only every selected line.

Insert number

Another useful feature of column mode is the “Insert number” feature. This is very helpful when you need to numerically order a list of data. You can use this feature by positioning your caret into the top row of the column where you need to add numbers. You can then click the “Insert number” in the Edit tab.

If any text is highlighted at the invocation of this command, the highlighted text will be replaced by the inserted line numbers. The spacing required for the line numbers is calculated automatically based on the number of lines that will have a number inserted, the initial value and the increment.

The ensuing dialog prompts you for specifications for numbering.

First number: The digit(s) you enter here will be the first number of the number string that is inserted. So, if you entered “10” instead of “1”, the number sequence would begin “10, 11, 12…” etc.

Increment: The digit(s) you enter here determines the increment of the count. For instance, if you enter “2” here, while your “First Number” is still specified as “10”, the number sequence would begin “10, 12, 14…” etc.

Leading zeros: This option will prepend each number with the appropriate amount of zeros to pad the field to the same width (in characters) as the maximum number. For instance, if you begin a count with “1,” and set the increment to “50” with “Leading Zeros” checked, your list would begin “001, 051, 101…”

For this tutorial, we only need numbering beginning with 1 and incrementing by 1, so we will leave the default options and press “OK”.

Sum selection

One way to save time and avoid error when adding column-specific data is to use “Sum selection” in the Edit tab. In our sample data below, we have some random sales figures that need to be totaled. Using the “Sum columns / selection” command we can total all the numbers that appear in a selected area.

You will need to first make your selection, making sure to include ALL columns that include data to be summed. With your selection still active, click the “Sum selection” command in the Edit tab (shown above). The sum is calculated and then displayed in the “Sum Selected Text” dialog box.