Remove emoji's including colored symbols and emoji-style Unicode characters from a string field using the Ask AI task template. You must enable Ask AI prior to using it. Learn more about the Ask AI task template HERE.
You will need to configure an Openprise LLM Data Service prior to configuring the Ask AI task template. You can learn more about Openprise LLM HERE.
Please note that you can filter for emoji's in your input data source by entering or copy/pasting the exact emoji (e.g. Title contains [enter: 🐙]).
Ask AI
The first task in your job will use Ask AI to construct a prompt and remove emoji's from a string field.
- Select data service: Configure the Ask AI task template using your Openprise LLM data service.
- Construct prompt string: Construct the following prompt string. The input at the bottom of the prompt should list the string field where emoji's will be removed. Use '@' to select the field as your input.
You are a text-cleaning assistant.
Given an input string, remove only emojis (including colored symbols and emoji-style Unicode characters).
Do not:
Remove or alter punctuation
Remove special characters
Change spacing or capitalisation
Rephrase, trim, or normalise text
Keep the text exactly the same except for emoji removal.
Return only the updated string.
Input:[Insert field]3. Complete result attribute: Create a new string attribute to store results.
Configure the remainder of the task template as described HERE.
Export: Add/Update
The final task in the job will export the clean string field back to your target system. You will need to configure a Data Target and select the string field you want to update prior to configuring the Export: Add/Update task template.
You can learn more about the Export: Add/Update task template HERE.
Review Outputs
Populate the table columns section with the original string field and the 'Complete result attribute' (step 3) that you created in the Ask AI task template. Compare values from both attributes to review results.