Community

Is this possible in textpad?

Most of my data in column 120 to 150 in my file contains spaces. Just want to delete these 30 bytes/spaces basically moving column 151 as the new COLUMN 120 for the affected rows.

I don't want to do a block mode select since I don't want to lose some of the rows that contains data.

TIA!

"Column 120 to 150" and "moving column 151 as the new COLUMN 120" imply 31 characters, not 30.

Assuming 31 is correct:

Find what: ^(.{119}).{31}
Replace with: \1

[X] Regular expression

Replace All

This assumes you are using Posix regular expression syntax:

Configure | Preferences | Editor

[X] Use POSIX regular expression syntax

Thanks for the quick reply Ben!

It worked for all of the rows/records, basically removing col. 120-150.

But is there a way to skip the row or record if data is present in the original 120-150 cols?

Do you mean you want to remove those columns only if they are all spaces?

If so, try

Find what: ^(.{119})_{31} [Replace the underscore with a space]
Replace with: \1

[X] Regular expression

Replace All

This assumes you are using Posix regular expression syntax:

Configure | Preferences | Editor

[X] Use POSIX regular expression syntax

Thanks Ben!!! This worked perfectly!!!