Align and clean the following sales data into this format (one per line, semicolon at…
- User
Align and clean the following sales data into this format (one per line, semicolon at end):
Name sale [amount] return [amount] add [amount] USD; OR Name sale [amount] return [amount] add [amount] PKR;
Rules:
- Name: Properly capitalized (e.g. "usman" → "Usman")
- Sale, Return, Add: Only numbers, no commas or "Rs."
- Currency: If ad spend is in USD, write "USD" at the end; if in PKR, write "PKR" at the end.
- If currency is missing, try to detect from context or leave blank.
- Each entry must end with a semicolon (;)
- Ignore extra text, typos, or irrelevant info.
Example: Usman sale 50000 return 5000 add 100 USD; Ali sale 80000 return 12000 add 250 PKR; Ayesha sale 120000 return 20000 add 300 USD;
Data: [paste your messy/random data here]
- Assistant
Sure thing! To get started, could you please paste the messy/random data you’d like me to clean and align? Once I have that, I’ll format it like this (one entry per line, semicolon-terminated):
Name sale [amount] return [amount] add [amount] USD;
or
Name sale [amount] return [amount] add [amount] PKR;Looking forward to your data! 😊
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.