Menu

how to get one column ?

stratus102
2013-05-23
2013-05-26
  • stratus102

    stratus102 - 2013-05-23

    Hi i have list like
    Number;Name;IDclient;Workhours
    how to get only the last one column ?
    the others can be removed

     
  • THEVENOT Guy

    THEVENOT Guy - 2013-05-25

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

    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
  • stratus102

    stratus102 - 2013-05-26

    thanks for the comprehensive answer mate! really thanks!