m0_71797874 2024-09-18 12:30 采纳率: 0%
浏览 6

EXCEL 提取字符串

求问各位大 神,在A2这种复杂的字符串里,如何用Excel公式提取出B2,C2这两个值?

img

字符串如下:
[{"tax_fee": "0", "quantity": 1, "pay_price": "1393.31", "sale_price": "1546", "coupon_infos": [{"type": 6, "price": "152.69", "promotion_id": 22973}], "reduce_amount": "0", "subsidy_price": "152.69", "activity_infos": [{"type": 99, "price": "0", "value": "0", "promotion_id": 22973}], "settlement_amount": "0", "brand_coupon_price": "0", "merchant_coupon_price": "0", "platform_coupon_price": "152.69", "promotion_reduce_price": "0", "merchant_promotion_price": "0", "platform_promotion_price": "0", "merchant_preferred_coupon_price": "0", "external_merchant_discount_amount": "0", "external_platform_discount_amount": "0"}]

  • 写回答

2条回答 默认 最新

  • 赵4老师 2024-09-18 15:45
    关注
    评论

报告相同问题?

问题事件

  • 修改了问题 9月18日
  • 创建了问题 9月18日