$echo '{
< "pastedText": "Customer ID,Full Name ,Email,Phone,Signup Date,Amount Paid,Discount\\n1001,\\" Ana García \\",ANA@EXAMPLE.COM,+34 612 345 678,03/15/2024,\\"$1,250.50\\",10%\\n1002,Bob O’Neil,bob@example,(555) 010-9999,2024-03-16,€99,N/A\\n1002,Bob O’Neil,bob@example,(555) 010-9999,2024-03-16,€99,N/A\\n1003,Café Owner,cafe@example.com,555-0100,17 Mar 2024,\\"1,000\\",5 %\\n1004,Sam Lee,sam@example.com,,not a date,12abc,\\n",
< "headerCase": "snake_case",
< "caseRules": [],
< "findReplaceRules": [],
< "numericColumns": [
< "Amount Paid",
< "Discount"
< ],
< "dateColumns": [
< "Signup Date"
< ],
< "emailColumns": [
< "Email"
< ],
< "phoneColumns": [
< "Phone"
< ],
< "requiredColumns": [
< "Customer ID"
< ],
< "dedupeMode": "key",
< "dedupeKeyColumns": [
< "Customer ID"
< ]
<}' |
<apify call makentest/csv-excel-data-cleaner-dedupe-fix --silent --output-dataset