It's quite easy with a Search/Replacement in Regex search mode.
So, to get the last column, only, of each line, even if lines include spaces/tabulations and/or are not aligned :
Type .*; in Search dialogue
Leave the Replacement dialogue empty
Tick the Regular expression radio button
Un-tick the . matches newline box, if necessary
Click on the Replace All button
That's all !
Cheers,
guy038
P.S. :
You will find good documentation, about the new PRCE Regular Expressions ( Perl Regular Common Expressions ), used by N++, since the 6.0 version, at the TWO addresses below :
Hi i have list like
Number;Name;IDclient;Workhours
how to get only the last one column ?
the others can be removed
Hi, Stratus102,
If your list has the general form below :
10;Smith;KB78592;220
227;Wilson;AZ12;70
.....................
It's quite easy with a Search/Replacement in Regex search mode.
So, to get the last column, only, of each line, even if lines include spaces/tabulations and/or are not aligned :
Type
.*;
in Search dialogueLeave the Replacement dialogue empty
Tick the Regular expression radio button
Un-tick the . matches newline box, if necessary
Click on the Replace All button
That's all !
Cheers,
guy038
P.S. :
You will find good documentation, about the new PRCE Regular Expressions ( Perl Regular Common Expressions ), used by
N++
, since the6.0
version, at the TWO addresses below :http://www.boost.org/doc/libs/1_48_0/libs/regex/doc/html/boost_regex/syntax/perl_syntax.html
http://www.boost.org/doc/libs/1_48_0/libs/regex/doc/html/boost_regex/format/boost_format_syntax.html
The FIRST link concerns the syntax of regular expressions in SEARCH
The SECOND link concerns the syntax of regular expressions in REPLACEMENT
Last edit: THEVENOT Guy 2013-05-25
thanks for the comprehensive answer mate! really thanks!