Remove spaces and tabs at the beginning of all lines

Remove spaces and tabs at the beginning of all lines

12
Basic UserBasic User
12

    Mar 23, 2012#1

    I have records which have spaces in front of them:

    [space]Mike Dawson
    Allen toole
    [space]Chasey White
    Robert Weyes

    I want to bring them to this format:

    Mike Dawson
    Allen toole
    Chasey White
    Robert Weyes

    There is trim trailing spaces but no trim preceding spaces.

    6,615550
    Grand MasterGrand Master
    6,615550

      Mar 23, 2012#2

      Run an UltraEdit regular expression Replace All searching for %[ ^t]+ and an empty replace string.

      Or if you prefer Unix or Perl regular expression engine use as search string ^[ \t]+ and also an empty replace string.

      115
      Power UserPower User
      115

        Mar 23, 2012#3

        This can be performed without writing a regular expression. You highlight the text and then select Format, Remove Indents and pick a number larger than the biggest gap, say 20 or so. This will move all of the lines flush to the left margin. You won't lose any characters except tabs or spaces from the beginnings of the lines, even when they are already flush.