Found the solution:
Perl pattern [(?:((?:[^\t\n\f\r]+))\t(?:(?:\1)))(?:\r\n)] with [$0]
[ ] Match case
[ ] Whole words only
[ ] Case sensitive replace
[ ] Prompt on replace
[ ] Skip prompt if identical
[ ] First only
[X] Extract matches
Maximum text buffer size 4096
[ ] Maximum match ...
Search found 2 matches
- Sun Jan 03, 2016 1:27 am
- Forum: TextPipe Tips and Tricks, Questions and Support
- Topic: [Solved] Comparing Columns/Fields
- Replies: 2
- Views: 5997
- Sat Jan 02, 2016 11:52 pm
- Forum: TextPipe Tips and Tricks, Questions and Support
- Topic: [Solved] Comparing Columns/Fields
- Replies: 2
- Views: 5997
[Solved] Comparing Columns/Fields
i have a long list of email and passwords separated by tab
I need to compare and keep only the lines where email and password are same.
Unable to get it right.
Any heads up will be appreciated.
I need to compare and keep only the lines where email and password are same.
Unable to get it right.
Any heads up will be appreciated.