Tapatalk

Re: Replace in specified column only

Re: Replace in specified column only

2
NewbieNewbie
2

    Sep 20, 2004#1

    :o

    I'd like to do something quite simple... yet it seems complex ?

    I have a large file... each row is delimited by a crlf...

    I'd like to replace each occurence in Col 9 of each row.. so that if col 9 has a "A" in that col... I'd like to replace it with a "B".

    Can this be done ?

    6,685587
    Grand MasterGrand Master
    6,685587

      Sep 20, 2004#2

      Activate Column Mode.

      Set cursor to column 9 (with mouse or cursor keys).

      Press Ctrl+Shift+End to select everything to the end of file.

      If last line is an empty line, while still holding Shift press Up.

      While still holding Shift move cursor Right till whole column 9 is selected.

      Open Replace dialog.

      Enter the Find and Replace characters.

      Activate Match Case, if necessary.

      Important: activate Selected Text.

      Press button Replace All.

      Finished!
      Best regards from an UC/UE/UES for Windows user from Austria

      2
      NewbieNewbie
      2

        Sep 20, 2004#3

        Hmmm it would have to be that easy... wouldn't it ?

        Thanks again...

        1
        NewbieNewbie
        1

          Jan 03, 2005#4

          could someone please tell me how you would do the above, in only a few lines...say lines 12 through 23? thanks in advance!

          6,685587
          Grand MasterGrand Master
          6,685587

            Jan 06, 2005#5

            There is no real difference between whole file or only a certain range. Simply select with mouse OR with cursor keys while SHIFT is pressed the lines/columns where you want to replace something. You can also use Edit - Select Range to do the selection, if you need a third method.
            Best regards from an UC/UE/UES for Windows user from Austria