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) =INFO3i 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!
-
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