Skip to main content
Sign in

Search And Replace Text

  • Updated

Purpose

Find and replace any part of a text, whether whole words, partial words, or phrases.

 

Field Description

1.png

2.png

  1. Replace text found in: Select the attribute to replace values in.
  2. Add text to replace: Type text to replace.
  3. Replace with: Three options: replace with text, replace with blank, replace with new line.
  4. Replace with: This option is available when replace with text is selected in #3. Type text value to replace with.
  5. Visualize spaces: If selected, you will see a bullet where you've typed a space                3.png
  6. Select or search input data: Optional: select a reference data source to identify values to replace.
  7. Search and find: Select the attribute in the reference data source that contains the values to replace.
  8. Replace with attribute: Three options: replace with attribute, replace with blank, replace with new line.
  9. Replace with: Option available when replace with attribute is selected in #8. Select the attribute in the reference data source that contains the replacement value.
  10. Write replaced value to: Select the attribute to house the results.
  11. Ignore Case: Select this checkbox to analyze values on a NON case sensitive basis.
  12. Match whole word only: Select this checkbox to match on whole words only.

 

Tips

  • This is similar to any search and replace function you would find in word processor or spreadsheet.
  • If you have a short list of words to search and replace, just specify them in the task configuration.
  • If you have a long list of words to search and replace, then it is best to prepare a list and import it as a reference Data Source.
  • You can chose to replace the search string with text, a new-line, or a space (blank).
  • In the advanced options you can specify if the search should be case sensitive or if the search should be whole-word match only.

 

Examples

  1. Expand common abbreviations such as:
    • Find "V.P." and "VP" and replace it with "Vice President"
    • Find "SFO" and replace it with "San Francisco"
  1. Bulk changes such as:
    • Find "China, Hong Kong, Taiwan" and replace it with "Greater China"
    • Find "DF16" and replace it with "Dreamforce 2016"

 

 

Related articles