Saturday, 15 February 2014

with statement - If columns match then -


I have seen many examples and I am confused to what I use. I have 3 columns if the data (whole line) in all 3 columns is either to highlight it either or to indicate that at least one of the columns is different. What is the best way?

3550 3550 3550 true 3551 3150 3550

One like Excel or LibreOffice The quick way would be with the spreadsheet:

  • Paste your data into Excel or similar
  • Check values ​​and values ​​to check a function in the fourth column Whether or not it is based on truth or wrong

    Example If you have a value in your columns A, B, and C, then in the fourth column, enter a function like the following:

    = IF (($ A1 = $ B1) & ($ A1 = $ C1), "true", "wrong")

If you have data in a text file, for example

$ cat data.txt 3550 3550 3550 3550 3551 3552 3550 3550 3550 $ Ajax '{if (($ 1 == $ 2) & amp; ($ 1 == $ 3)) {Print $ 1, $ 2, $ 3, "true"} Else {print $ 1, $ 2, $ 3}} 'data Txt 3550 3550 3550 true 3550 3551 3552 3550 3550 3550 true

No comments:

Post a Comment