how to delete data on line as example



  • Dear,
    I have file notepad++ as below:
    1 | a | b | 2015 | a| d | f | CA | g | r | g | CA | s | b | v | CA | --2
    2 | d | c | 2015 | d| e | h | CA | c | x | n | CA | m | e | q | CA | --2
    3 | s | x | 2016 | v | w | BR | x |w | CA | d | d | CA | --2

    ( a| d | f | CA), (d| e | h | CA), (v | w | BR) = INFO 1
    (g | r | g | CA), (c | x | n | CA), (x |w | CA) =INFO 2
    (s | b | v | CA | --2), (m | e | q | CA | --2), (d | d | CA | --2) =INFO3

    i only want info 2, result is:
    1 | a | b | 2015 | g | r | g | CA |
    2 | d | c | 2015 | c | x | n | CA |
    3 | s | x | 2016 | x |w | CA |

    Thank you!



  • @Sabah-Siddiqui

    too many open questions.

    Are a b d f variable in length? Or is it really one char?
    Is the pipe symbol part of the data?
    Is it true that there is a space after the char v in | v | (line 3)
    but not after char d in | d| (line 2 and 1)?

    Cheers
    Claudia


Log in to reply