如何用Ruby从结果集提取指定字段并生成指定格式文件？

核心思路 #

直接遍历结果集中的每个客户对象，按需提取指定字段，拼接成字段1 | 字段2 | 字段3格式的字符串，逐行写入文件即可，完全不用CSV模块或复杂的列表转换。

Python 实现示例 #

# 假设你的客户数据已经是Python列表字典格式
customer_data = [
    {"name": "John", "age": 20, "state": "y", "city": "w", "country": "x"},
    {"name": "Alice", "age": 28, "state": "z", "city": "v", "country": "y"},
    # 更多客户数据...
]

# 注意：你问题中描述的提取字段是name/state/city，但输出格式写的是name|age|city，这里按提取需求设置字段
# 如果确实需要输出name|age|city，只需把下面的列表改成["name", "age", "city"]
target_fields = ["name", "state", "city"]

# 构建输出内容：先写表头，再遍历生成每行数据
output_content = [" | ".join(target_fields)]
for customer in customer_data:
    # 提取字段，缺失时用空字符串填充
    line_items = [str(customer.get(field, "")) for field in target_fields]
    output_content.append(" | ".join(line_items))

# 写入文件
with open("customer_info.txt", "w", encoding="utf-8") as f:
    f.write("\n".join(output_content))

如果你的原始数据是JSON字符串，先添加一行转换代码：

import json
# 假设raw_data是你的JSON格式字符串
customer_data = json.loads(raw_data)

JavaScript（Node.js）实现示例 #

// 客户数据数组
const customerData = [
    {name: "John", age: 20, state: "y", city: "w", country: "x"},
    {name: "Alice", age: 28, state: "z", city: "v", country: "y"}
];

const targetFields = ["name", "state", "city"]; // 按需调整字段
const outputLines = [targetFields.join(" | ")];

customerData.forEach(customer => {
    const lineParts = targetFields.map(field => customer[field] || "");
    outputLines.push(lineParts.join(" | "));
});

// 写入文件（Node.js环境）
const fs = require('fs');
fs.writeFileSync('customer_info.txt', outputLines.join('\n'), 'utf8');

内容的提问来源于stack exchange，提问作者pralxx