Community

I have a file with entires like below. The lines are almost the same. They have the same ID but with different text. How do I with TextPad list out those pairs to a different file?

('00994','COLUMBUS JACK CORP','UNITED STATES');
('00994','COLUMBUS JACK CORPORATION','UNITED STATES');

or

('06324 ...

If I have a data file delimited by | how do I select just the first column of data?

1929393|dafda|d0354
492394|flat|dl303
239095860|daeio|3901

If I have thousands of rows of data like this how do I select and pull just the first column?

thanks.

Thanks.

Worked great.

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 ...