data-transformation Scenario 2 — Extract Salary with Regex and Export JSON

{
  "name": "Extract_Salary_With_Regex",
  "settings": {
    "urls": [
      "https://learn.rtila.com/scenarios/data-transformation/2"
    ]
  },
  "datasets": {
    "salaries": {
      "item_selector": "css=table.salary-table tbody tr",
      "properties": [
        {
          "name": "title",
          "type": "text",
          "selector": "css=td:nth-child(1)"
        },
        {
          "name": "company",
          "type": "text",
          "selector": "css=td:nth-child(2)"
        },
        {
          "name": "salary_min",
          "type": "text",
          "selector": "css=td:nth-child(3)",
          "transformations": [
            {
              "type": "script",
              "code": "const match = String(value).match(/\\$([\\d,]+)/); return match ? parseInt(match[1].replace(/,/g, ''), 10) : 0;",
              "default_value": 0
            }
          ]
        },
        {
          "name": "salary_max",
          "type": "text",
          "selector": "css=td:nth-child(3)",
          "transformations": [
            {
              "type": "script",
              "code": "const match = String(value).match(/\\$[\\d,]+\\s*-\\s*\\$([\\d,]+)/); return match ? parseInt(match[1].replace(/,/g, ''), 10) : 0;",
              "default_value": 0
            }
          ]
        }
      ]
    }
  },
  "commands": [
    {
      "command": "extract_data",
      "params": {
        "dataset": "salaries"
      }
    },
    {
      "command": "comment",
      "params": {
        "text": "Use JSON export trigger after extraction"
      }
    }
  ]
}