Transform String if substring is present

romain_romain

Hello, I would like to transform a string if a substring is present inside it.

For example I would like to transform each string containing the substring "Computer" into "Computer Science" and keep the string that don't contain Computer the same as before. The first column is what I have and the second column is what I would like :

Column 1	Column 2
Computer Network	Computer Science
Agriculture	Agriculture
Computer Software	Computer Science
Accounting	Accounting

I tried to do that with a formula by using RegexReplace, my exact formula is :
if REGEX_Match([Column 1], '.*Computer*.') then "Computer Science" else [Column 1] endif

But it is not working.
Anyone has any tips on how to do this?

Thanks in advance.

randreag

Hi @romain_romain 

For this you dont need regex a simple if would do it.

if Contains([Column 1], '.*Computer*.') then "Computer Science" else [Column 1] endif

I hope it helps