AI Sheets provides an efficient text cleanup solution:
- Uploading CSV/TSV files containing garbled text
- Click Add New Column and select Custom Prompt Type
- Enter the prompt 'Remove redundant punctuation from {{original column name}}'
- Recommended models with good structured output performance such as meta-llama/Llama-3
- Manually check some of the results after generation and edit the wrong cells
- Click 'Like' to mark quality results, these examples will be used as few-shot samples to optimize subsequent generation
- Finally use drag and drop to apply the optimization criteria to the entire column
This method can batch process millions of characters of text content, which is more than 20 times more efficient than manual operation.
This answer comes from the articleAI Sheets: building and processing datasets using AI models in tables without codeThe
May not be reproduced without permission:AI productivity tools " How can I eliminate the problem of confusing text punctuation in my dataset?
English 
简体中文 
日本語 
Deutsch 
Português do Brasil