Hi,
I was wondering if anyone can help me with this issue. I tried to search and found following page which is not helpful as Comma Separated format which is inbuilt to beyond compare does not have grammer tab and then if I create a new format it is unclear how that really works and how do I tell it to specify that the files are in csv format.
Anyways my problem is simple and is in two parts. I have following two files:
File1.txt
Country,Time,GMTOffset,Value
US,10:30:10,+5,50
UK,20:30:20,+0,50
AUS,9:30:30,+10,80
File2.txt
Country,Time,GMTOffset,Value
US,10:30:40,+4,50
UK,20:30:60,+1,50
AUS,9:30:20,+11,80
So, differences are the 3rd column (GMTOffset) and the seconds in the Time column.
Problem 1:
When I compare the two files how can I specify that I want to ignore column 3 (GMTOffset) when doing the comparison.
Problem 2:
When I compare the two files how can I specify to ignore seconds field i.e. in column 2 of csv file ignore the 3rd field in the value which is seperated by ':'. Or something along that sort.
So, basically when I apply this rules beyondcompare will tell me that the two files are identical.
Help would be very much appreciated as I am pretty sure that BeyondCompare supports features like that.
I was wondering if anyone can help me with this issue. I tried to search and found following page which is not helpful as Comma Separated format which is inbuilt to beyond compare does not have grammer tab and then if I create a new format it is unclear how that really works and how do I tell it to specify that the files are in csv format.
Anyways my problem is simple and is in two parts. I have following two files:
File1.txt
Country,Time,GMTOffset,Value
US,10:30:10,+5,50
UK,20:30:20,+0,50
AUS,9:30:30,+10,80
File2.txt
Country,Time,GMTOffset,Value
US,10:30:40,+4,50
UK,20:30:60,+1,50
AUS,9:30:20,+11,80
So, differences are the 3rd column (GMTOffset) and the seconds in the Time column.
Problem 1:
When I compare the two files how can I specify that I want to ignore column 3 (GMTOffset) when doing the comparison.
Problem 2:
When I compare the two files how can I specify to ignore seconds field i.e. in column 2 of csv file ignore the 3rd field in the value which is seperated by ':'. Or something along that sort.
So, basically when I apply this rules beyondcompare will tell me that the two files are identical.
Help would be very much appreciated as I am pretty sure that BeyondCompare supports features like that.
Comment