This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Extracting specific words from a string using a list

Posted on 07-22-2023 02:56 PM
Jas9000d
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Evening 

Is this at all possible?

Id like to extract the keywords from a long string in column 'Data' using keywords from a list 'Keywords'

does that make sense?

Many thanks 

 

Solved Solved
0 10 422
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Marc_Dillon
Platinum 1
Platinum 1
In response to Jas9000d
Reply posted on --/--/---- --:-- AM

SELECT( Keyword[Allergen] , CONTAINS( [_THISROW].[Ingredients] , [Allergen] ) )

View solution in original post

Jump to Solution
10 REPLIES 10