With Data Prep Studio, you can easily replace a fixed sequence of characters. Here, let’s say we need to replace Thomas Hanson with the name of the new supervisor. Go to Replace then choose Using Find and Replace. Set Thomas Hanson as the Search String, and the new name as the Replace string. The results are immediately shown in the table of sample values.
Using the Advanced option, you can also put in a newline, tab or backslash if you wish.