Community

Posted: **Tue Jan 04, 2011 7:14 pm**

How do I delete white space thru out the document?

I have 10,000 lines like this:

102| 0137138600| 30817| EA| VPS| A| Not Serial Tracking|
102| 0137138600| 30817| EA| FTW| A| Not Serial Tracking|
102| 0137139100| 30817| EA| FTW| A| Not Serial Tracking|
102| 0137139100| 30817| EA| VPS| A| Not Serial Tracking|
102| 0137139200| 30817| EA| FTW| A| Not Serial Tracking|
102| 0137139200| 30817| EA| VPS| A| Not Serial Tracking|

And I want to delete the white space between the columns all at once to make it look like the below:

102|0137138600|30817|EA|VPS|A|Not Serial Tracking|
102|0137138600|30817|EA|FTW|A|Not Serial Tracking|
102|0137139100|30817|EA|FTW|A|Not Serial Tracking|
102|0137139100|30817|EA|VPS|A|Not Serial Tracking|
102|0137139200|30817|EA|FTW|A|Not Serial Tracking|
102|0137139200|30817|EA|VPS|A|Not Serial Tracking|

Is this possible?

thanks.

Posted: **Tue Jan 04, 2011 7:49 pm**

Find what: |_ [Replace the underscore with a space]
Replace with: |

[ ] Regular expression [i.e., not selected]

Replace All

Posted: **Tue Jan 04, 2011 8:49 pm**

Thanks.

Worked great.

Community

mark blocks of text and delete white space

mark blocks of text and delete white space