Copy specific word from column to other customize column

[Munawar1881]

Hi,

hope all of you are doing well.

I have a question if anyone can please answer. I have a product description in one column which contain a word male or female with other details I want to create a column in and want to copy the male, female etc from description column to the new one. how can I do that.

please find the example below. it's in Excel but I need to it in Power BI

Thank you so much

[Munawar1881]

[wdx223_Daniel]

NewStep=Table.AddColumn(PreviousStepName,"Gender",each List.Skip({"BABY","LADIES","MEN'S"},(x)=>not Text.Contains([Style Name],x,Comparer.OrdinalIgnoreCase){0}? ??"OTHERS")

[Munawar1881]

can you please help the query you gave me is showing error

[Munawar1881]

no its not working