Creating New column based on Keyword in Another Column

Hi,

I have a column(Col A) which has 25K records. Now I need to create New column(Col based on keyword in Col A.

For example , If Col A has *Microsoft* , then all corresponding col B data needs to show 'Microsoft Patch'. Like that I have few set of Keywords with me.

What is the best function to use in this case. And Is there any restrictions of using more Keywords.

Any advice on this please

Developer

Accepted answers

binu_acs

@Karthick461 I dont think you can give multiple search conditions in one file like the first example, because here the "Red Hat Computer nodejs" will be considered as one word and search in the file and if it doesnt find any match it will return null. I think this case you need to only mention Red Hat, this will replace as Redhat Patch

All comments

binu_acs

@Karthick461 I think find and replace tool would be suitable for this use case

Karthick461

Thanks for the Idea. but Find and Replace is renaming same column rather than creating new column. Also only that particular word is replacing and remaining characters are coming as it is now. New column should show only the fields which I am creating in Replace column

now I am getting output as ,

Col A Col B

Apache HTTPD ISAI Apache Usage HTTPD ISAI

My Replace table has 'Apache' as 'Apache Usage'

But Actual Requirement is,

If I have Apache (keyword) in Col A , then my Col B should show only 'Apache Usage'

Any thoughts on this

Now I am getting oup

binu_acs

@Karthick461 you can use the append option in the Find and Replace tool

Find_Replace_31_05.yxmd

Karthick461

Hi @binu_acs ,

Thanks for the Answer. we have one last issue. If I have 2 words in search criteria , which is not in sequence. how to achieve that.

like Below example, col A has to refer for 'Red Hat' and 'nodejs' words and give output as Redhat Patch

Any suitable way to achieve this

binu_acs

@Karthick461 one option is to mention the keyword seperate along with the keywords

Find_Replace_31_05.yxmd

Karthick461

@binu_acs

If that column has Redhat and nodejs then it needs to come as 'Redhat Patch'. but if that column has only 'nodejs' it should show as 'Nodejs Patch'.

Combination of 2 words needs to show one output ,and only single word needs to show another output

binu_acs

Karthick461

Got it @binu_acs . Thanks for your help on this.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703