Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a data like this
knee join
knee pain
knee
knee JT
eye
eye pain
eye damage
eyelid retraction right eye
mouth
abdomen
dysprea
frontal
now i want to get like this ...
like when anywhere where knee word is found i want to name all these word with knee and when any word start from eye then want to name it eye
and except this all renaming i want to name it "other"
knee join | knee |
kneepain | knee |
Abrasion, left knee, initial encounter | knee |
knee JT | knee |
eye | eye |
eye pain | eye |
eye damage | eye |
eyelid retraction right eye | eye |
mouth | mouth |
abdomen | other |
dysprea | other |
frontal | other |
i tried this
If(WildMatch(col1,'*knee*'),'Kneee',If(WildMatch(col1,'*eye*'),'Eye'))
but this shows only 1 result with eye where as i have 3 records related to eye and knee record is not display..
not working just this file
what is +1 here?
Dear Capricorn,
Find the below attachment
Regards,
Jayshri
The addition of one will make sure that if there is no match the 'other' is picked...
WildMatch(Lower(Bodypart),'knee*','eye*','mouth') will return 0 (if not match), 1 for 'knee*' 2 for 'eye*' 3 for 'mouth'
by adding 1 you can cater for no match too in the Pick function....