Email address with imbedded escape character to be used as a parameter

Document created by pete_mccoy1.3055586893899446E12 Employee on Oct 29, 2013
Version 1Show Document
  • View in full screen mode
Want to perform an extract of data using an email address that contains the escape character ' as a filter.
Example email address:

p'test.jones@email.com
To be able to pass this value as a parameter to be used in a filter, you would need to use a Data Process component that does a search and replace on the unicode value of the escape character, and replace it with a set of single quotes.

UniCode value of ' = U+0027
In the Search and replace function enter the following values:

Text To Find:   \u0027
Replace With: ''  (2 single quotes)

This will allow the ', which is an escape character, to be recognized as part of the email address, and allow it to be passed in as a parameter to be used in the filter value.

Attachments

    Outcomes