主页  »  技术支持  »  指南/使用技巧  »  UltraEdit  »  Column Based Find and Replace
IDM Power Tips

Column Based Find and Replace

Have you ever wanted to search for data in specific column ranges? UltraEdit/UEStudio's column-based search does just that.. UltraEdit/UEStudio allows you to restrict your search by column range, giving you the ability to search for literal strings and even regular expressions in specific columns.


Step 1: Determine the Column Range

The first step is to determine the column range that we wish to restrict the search to.

For the purposes of this power tip, we are using address information as shown in the screenshot. We are going to search for people who live in Ohio (postal code OH). The column that contains the postal codes is in the range of 51 - 53.

You can easily find the column range using the Ruler at the top of the edit window or by checking the column number in the status bar.

Column Based Find and Replace

Please note: If you are using the status bar, you can see the entry for the column number following the "Col.". You will need to subtract 1 from the number here because it is showing you the column that text will be entered into when you next type.

Column Based Find and Replace


Step 2: Do the Search

Open the find dialog from the Search menu, toolbar, or by hitting CTRL + F. To access the Search in Column feature, you will need to click on the Advanced button to expand the advanced options.

Enable (Click) the option to Search in Column and type your column range. For our example, we are using 51 and 53.

Column Based Find and Replace

Now, when you click Next (or hit Enter), you will see that the text is matched only in the specific column range.

Column Based Find and Replace

As you can see in our example, OH is matched in column 51-53, but not it the other instances of "oh" - such as in the name "John" on the first and second lines of the file.


Replace in Columns

The same technique as above also applies to the column based replace.

Column Based Find and Replace

Back to power tips index


Buy Now
Upgrade
Download

Cnet/Download.com review
"我们并没有夸大其词:
UltraEdit真的非常棒..."

Corporate Licensing

It's easy to purchase corporate licensing from us!

  • Bulk/quantity discounts
  • Enterprise/plant/site licensing
  • Purchase with PO or invoice

The new UltraSuite

The only fully integrated solution of its kind!

Four powerful applications: UltraEdit, UltraCompare, UltraFinder, and UltraSentry!

Save over 33% when you bundle with the UltraSuite!

Power of Portable

Now supporting PortableApps!

UE/UC Mobile

Unleash the power of the total file management solution on your flash drive!