J
Jan
Hi,
I have one column that contains large strings of text data (e.g., a1:
"the quick brown fox jumps over the lazy dog", a2: The old lame mule
hit the quick brown fox", a3: "the quick dog bit the brown mule") and
want to categorize this data according to criteria in a second column
or an arrayb (e.g, b1: fox, b2: dog, b3: lazy, b4: quick, etc.) . So, I
want to assign number 1 in column c to all rows which contain the
words "dog" or "fox" in a, number 2 to all rows which contain "
quick" or "lazy", number 3 to all rows which contain "brown"., etc. All
categories can occur several times in column a. "match" does not work
with larger strings, since exact match (x;y;0) is not possible, and
"search" does not give the right results with the search terms in an
array.
Does anyone have an idea?
Many thanks
Jan
I have one column that contains large strings of text data (e.g., a1:
"the quick brown fox jumps over the lazy dog", a2: The old lame mule
hit the quick brown fox", a3: "the quick dog bit the brown mule") and
want to categorize this data according to criteria in a second column
or an arrayb (e.g, b1: fox, b2: dog, b3: lazy, b4: quick, etc.) . So, I
want to assign number 1 in column c to all rows which contain the
words "dog" or "fox" in a, number 2 to all rows which contain "
quick" or "lazy", number 3 to all rows which contain "brown"., etc. All
categories can occur several times in column a. "match" does not work
with larger strings, since exact match (x;y;0) is not possible, and
"search" does not give the right results with the search terms in an
array.
Does anyone have an idea?
Many thanks
Jan