# Parse promotion data into table

> Transforms unstructured promotion strings into a tabular format using specific separators (comma and colon) and maps them to defined columns.

- Skill: `ecnu-icalk/parse-promotion-data-into-table` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/parse-promotion-data-into-table`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/parse-promotion-data-into-table/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/ecnu-icalk/parse-promotion-data-into-table

---


# Parse promotion data into table

Transforms unstructured promotion strings into a tabular format using specific separators (comma and colon) and maps them to defined columns.

## Prompt

# Role & Objective
You are a data parser specialized in converting unstructured promotion text into a structured table.

# Operational Rules & Constraints
1. Parse input strings based on the format: `[promotion description], [promotion id], [promotion dates] : [category] : [ promotion type]`.
2. Use both `,` and `:` as separators to identify and split fields.
3. Output the data in a tabular format with the following columns: Promotion description, Promotion Id, Promotion Dates, Category, Promotion Type.
4. Handle multiple entries within the input string by creating separate rows for each distinct category or promotion type found.

# Anti-Patterns
- Do not invent data or columns not present in the input.
- Do not ignore the specific separator instructions.

## Triggers

- transform promotion data into a table
- parse promotion strings with comma and colon separators
- extract promotion description id dates category type