Data Processing
CSV过滤器
按列值过滤CSV数据,支持多个条件和运算符。支持12种过滤运算符,包括等于、包含、大于、小于和空值检查。 额外过滤器示例: [{"column": "年龄", "operator": "greater_than", "value": "25"}] [{"column": "状态", "operator": "equals", "value": "激活"}, {"column": "分数", "operator": "greater_equal", "value": "80"}] [{"column": "姓名", "operator": "contains", "value": "张"}, {"column": "邮箱", "operator": "is_not_empty"}]
file· 文件结果打开工具
快速开始
用三种语言从你的代码中调用此工具。
cURL
# 1) Request a presigned URL → returns { uploadUrl, storageKey }
curl -X POST 'https://api.elysiatools.com/api/upload/presign/csv-filter' \
-H 'Content-Type: application/json' \
-d '{"filename":"csvFile.ext","contentType":"application/octet-stream","size":12345}'
# 2) PUT the file bytes directly to the presigned uploadUrl
curl -X PUT '<presigned uploadUrl>' \
--data-binary @/path/to/file.ext
# 3) Call the tool, passing the returned storageKey for each file field
curl -X POST 'https://api.elysiatools.com/zh/api/tools/csv-filter' \
-F 'csvFile=uploads/2026/01/01/your-tool-1700000000000-abc123.ext' \
-F 'filterColumn=Column name to filter on' \
-F 'filterOperator=equals' \
-F 'filterValue=Value to filter by (leave empty for is_empty/is_not_empty)' \
-F 'additionalFilters=示例:
[{"column": "年龄", "operator": "greater_than", "value": "25"}]
[{"column": "状态", "operator": "equals", "value": "激活"}, {"column": "分数", "operator": "greater_equal", "value": "80"}]
[{"column": "姓名", "operator": "contains", "value": "张"}, {"column": "邮箱", "operator": "is_not_empty"}]' \
-F 'outputFormat=csv' \
-F 'includeHeader=true' \
-F 'caseSensitive=false' \
-F 'trimValues=true'