Data Prep- Error is displayed when attempting to replace value with apostrophe
Last updated 2022-02-10 ·Reference W-9294521 ·Reported By 0 users
Replace in recipe is not accepting the Apostrophe value and showing an error "There’s a syntax error in the formula node REPLACE8’s SQL expression. Update the formula’s SQL syntax in target column Vendor__c_replace at row 1, column 27"
1. In Analytics Studio , go to a recipes in data manager
2. Create a new recipe
3. Select Data
4. In data node click on add branch
5. Select Transformation and click on the column where value is required to be replace
6. On top, click on replace action
7.In replace add " value " and in find section and add in replace " value's"
8. Error will be displayed
To write a custom formula that looks like:
replace(fieldName, 'Value', 'Value\'s')
The "apostrophe" or single quote needs to be escaped with a backslash.
Reported By (0)
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.