Hi,
I am currently using the latest version of the tool. I don't have experience with Regular Expression before. Here is what I am looking for.
I have two files.
File 1 contains text :
TEXT|TEXT|TEXT||G|00100|TEXT|TEXT|TEXT|P|20151124| TEXT
TEXT||TEXT TEXT TEXT ||||||||6548071000|||TEXT|TEXT|
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT|TD||||
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT||G|00100|TEXT|TEXT|TEXT|P|20151124| TEXT
TEXT||TEXT TEXT TEXT ||||||||1234324569|||TEXT|TEXT|
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT|TD||||
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT||G|00100|TEXT|TEXT|TEXT|P|20151124| TEXT
TEXT||TEXT TEXT TEXT ||||||||4528962220|||TEXT|TEXT|
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT|TD||||
TEXT|TEXT|TEXT|TEXT|TEXT|||
File 2 contains text:
TEXT|TEXT|TEXT||G|00100|TEXT|TEXT|TEXT|P|20151124| TEXT
TEXT||TEXT TEXT TEXT ||||||||1234324569|||TEXT|TEXT|
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT|TD||||
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT||G|00100|TEXT|TEXT|TEXT|P|20151124| TEXT
TEXT||TEXT TEXT TEXT ||||||||6548071000|||TEXT|TEXT|
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT|TD||||
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT||G|00100|TEXT|TEXT|TEXT|P|20151124| TEXT
TEXT||TEXT TEXT TEXT ||||||||5828962290|||TEXT|TEXT|
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT|TD||||
TEXT|TEXT|TEXT|TEXT|TEXT|||
My requirement is like to compare only the 10-Digit number in the 2nd, 7th, 12th,... line and ignore all other lines( lines 1,3,4,5,6,8,9,10,11,13,14,15,...) . So if you look at the above two files and also in the attachment ( I highlighted the matching numbers in the attachment), the 10-Digit number that I am referring to is the same but it is in a different line number. So is there anyway in Beyond Compare that meets my requirement using regular expression or any rules in the tool.
My file format is a regular text document. All the strings are delimited by '|'.
Thanks in advance.
I am currently using the latest version of the tool. I don't have experience with Regular Expression before. Here is what I am looking for.
I have two files.
File 1 contains text :
TEXT|TEXT|TEXT||G|00100|TEXT|TEXT|TEXT|P|20151124| TEXT
TEXT||TEXT TEXT TEXT ||||||||6548071000|||TEXT|TEXT|
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT|TD||||
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT||G|00100|TEXT|TEXT|TEXT|P|20151124| TEXT
TEXT||TEXT TEXT TEXT ||||||||1234324569|||TEXT|TEXT|
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT|TD||||
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT||G|00100|TEXT|TEXT|TEXT|P|20151124| TEXT
TEXT||TEXT TEXT TEXT ||||||||4528962220|||TEXT|TEXT|
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT|TD||||
TEXT|TEXT|TEXT|TEXT|TEXT|||
File 2 contains text:
TEXT|TEXT|TEXT||G|00100|TEXT|TEXT|TEXT|P|20151124| TEXT
TEXT||TEXT TEXT TEXT ||||||||1234324569|||TEXT|TEXT|
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT|TD||||
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT||G|00100|TEXT|TEXT|TEXT|P|20151124| TEXT
TEXT||TEXT TEXT TEXT ||||||||6548071000|||TEXT|TEXT|
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT|TD||||
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT||G|00100|TEXT|TEXT|TEXT|P|20151124| TEXT
TEXT||TEXT TEXT TEXT ||||||||5828962290|||TEXT|TEXT|
TEXT|TEXT|TEXT|TEXT|TEXT|||
TEXT|TEXT|TEXT|TD||||
TEXT|TEXT|TEXT|TEXT|TEXT|||
My requirement is like to compare only the 10-Digit number in the 2nd, 7th, 12th,... line and ignore all other lines( lines 1,3,4,5,6,8,9,10,11,13,14,15,...) . So if you look at the above two files and also in the attachment ( I highlighted the matching numbers in the attachment), the 10-Digit number that I am referring to is the same but it is in a different line number. So is there anyway in Beyond Compare that meets my requirement using regular expression or any rules in the tool.
My file format is a regular text document. All the strings are delimited by '|'.
Thanks in advance.
Comment