Notepad++ Search by Columns
I would like to search a file only on the first column based on a set of IDs from another file. Copy and paste the results to another output file.
For example , My first file contains
ABHA-PHY49M
ABHA-PHY49N
ABHA-PHY49O
My second file contains
"ABHA-PHY49M";"Blah blah";"Ashwin";"";"10/14/2 009 10:36:29";"ABHA-PHY49N";"Hi, Some mail contents1 Kind Regards,"
"ABHA-8RXIYY";"Blah blah";"Ashwin";"";"10/14/2 009 10:36:29";"ABHA-PHY49N";"Hi, Some mail contents2 Kind Regards,"
"ABHA-PHY49M";"Blah blah";"Ashwin";"";"10/14/2 009 10:36:29";"ABHA-PHYCCC";"Hi, Some mail contents3 Kind Regards,"
"ABHA-8RXIXX";"Blah blah";"Ashwin";"";"10/14/2 009 10:36:29";"ABHA-PHYDDD";"Hi, Some mail contents4 Kind Regards,"
I need to retrieve all lines matching the ids from the first file with the first column value. I cant use excel because there is a field called Verbatim where the contents could be free text and would contain CR+LF etc which destroys the formatting when opening with Excel. I would like to know if we can write/record a macro to achieve this. All I can think of is to search the ids(obtained from file1) and search in the first column , extend the selection and copy the data. Not sure if this is possible or how to do it.
In the above example , just two rows will be selected because of the Id ABHA-PHY49M
"ABHA-PHY49M";"Blah blah";"Ashwin";"";"10/14/2 009 10:36:29";"ABHA-PHY49N";"Hi, Some mail contents1 Kind Regards,"
"ABHA-PHY49M";"Blah blah";"Ashwin";"";"10/14/2 009 10:36:29";"ABHA-PHYCCC";"Hi, Some mail contents3 Kind Regards,"
I would like to search a file only on the first column based on a set of IDs from another file. Copy and paste the results to another output file.
For example , My first file contains
ABHA-PHY49M
ABHA-PHY49N
ABHA-PHY49O
My second file contains
"ABHA-PHY49M";"Blah blah";"Ashwin";"";"10/14/2 009 10:36:29";"ABHA-PHY49N";"Hi, Some mail contents1 Kind Regards,"
"ABHA-8RXIYY";"Blah blah";"Ashwin";"";"10/14/2 009 10:36:29";"ABHA-PHY49N";"Hi, Some mail contents2 Kind Regards,"
"ABHA-PHY49M";"Blah blah";"Ashwin";"";"10/14/2 009 10:36:29";"ABHA-PHYCCC";"Hi, Some mail contents3 Kind Regards,"
"ABHA-8RXIXX";"Blah blah";"Ashwin";"";"10/14/2 009 10:36:29";"ABHA-PHYDDD";"Hi, Some mail contents4 Kind Regards,"
I need to retrieve all lines matching the ids from the first file with the first column value. I cant use excel because there is a field called Verbatim where the contents could be free text and would contain CR+LF etc which destroys the formatting when opening with Excel. I would like to know if we can write/record a macro to achieve this. All I can think of is to search the ids(obtained from file1) and search in the first column , extend the selection and copy the data. Not sure if this is possible or how to do it.
In the above example , just two rows will be selected because of the Id ABHA-PHY49M
"ABHA-PHY49M";"Blah blah";"Ashwin";"";"10/14/2 009 10:36:29";"ABHA-PHY49N";"Hi, Some mail contents1 Kind Regards,"
"ABHA-PHY49M";"Blah blah";"Ashwin";"";"10/14/2 009 10:36:29";"ABHA-PHYCCC";"Hi, Some mail contents3 Kind Regards,"
No comments:
Post a Comment