Hi everyone,
I need some help! I am trying to add a substring before and after certain words I'm searching for. The formatting of the original text should remain the same. It however need to identify all the different format variations of the word and add the substring to all of them.
Example:
String - "Thank you Alteryx for an amazing platform for Data Analysis. I am new to the data world, but am enjoying to learning experience. The problem with DATA is that it's in everything, it's dynamic, it's unstructured and difficult for an untrained process to understand. However, the better you structure the process, the better it will understand the data."
Search word - "data"
Result - "Thank you Alteryx for an amazing platform for {_Data_} Analysis. I am new to the {_data_} world, but I am enjoying to learning experience. The problem with {_DATA_} is that it's in everything, it's dynamic, it's unstructured and difficult for an untrained process to understand. However, the better you structure the process, the better it will understand the {_data_}."
(Excuse the example, I had to think of something with a couple of words repeating and voilà)
Thanks for the help
An Alteryx Enthusiast
