String Parsing and matching

[Komal_]

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

[griffinwelsh]

You need to use the tokenize function of the regex tool. Expression is ([^|]+). Sample solution workflow is attached.

[binu_acs]

@Komal_ using text-column tool