Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    how to delete data on line as example

    Help wanted · · · – – – · · ·
    2
    2
    1488
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Sabah Siddiqui
      Sabah Siddiqui last edited by

      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!

      Claudia Frank 1 Reply Last reply Reply Quote 0
      • Claudia Frank
        Claudia Frank @Sabah Siddiqui last edited by

        @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

        1 Reply Last reply Reply Quote 0
        • First post
          Last post
        Copyright © 2014 NodeBB Forums | Contributors