Creating New column based on Keyword in Another Column

[Karthick461]

Hi,

I have a column(Col A) which has 25K records. Now I need to create New column(Col B) 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

[binuacs]

@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

[binuacs]

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

[Karthick461]

Hi @binuacs ,

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

[binuacs]

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

[Karthick461]

@binuacs 

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

[binuacs · Accepted solution]

@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 

[Karthick461]

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