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
I'm ready to help. Please go ahead and paste the messy sales data, and I'll clean and align it according to the provided format and rules. I'll transform it into the desired format, one entry per line, with a semicolon at the end. Let's get started!
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.