Hi All,
I have below dataset and also mentioned the expected output from the data set -
Data | Value | Match/Mismatch |
CATERPILLAR|IN | IN | MATCH |
CATERPILLAR|IN | CATERPILLAR | MATCH |
CATERPILLAR|IN | A | MISMATCH |
CATERPILLAR|IN | CAT | MISMATCH |
BUBBLE GUM|BOX | BUBBLE | MISMATCH |
BUBBLE GUM|BOX | BOX | MATCH |
BUBBLE GUM|BOX|PIN | BUBBLE GUM | MATCH |
BUBBLE GUM|BOX|PIN | PIN | MATCH |
BUBBLE GUM|BOX|PIN | B | MISMATCH |
BUBBLE GUM|BOX|PIN | P | MISMATCH |
The issue is there is no constant blocks (|) between the each word in each row. They could be multiple.
any help is appreciated.
Thanks in Advance,
Komal
@Komal_ using text-column tool