agentsclimarketplace
Sign in

Vba macro for parsing movie data

Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/vba-macro-for-parsing-movie-data

Generates a VBA macro to parse movie details (Title, Distributor, Approvals, Copies) from a specific text format in Excel Column A and output them to adjacent columns.From its SKILL.md

Install
npx -y skills add ECNU-ICALK/AutoSkill --skill vba-macro-for-parsing-movie-data

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.

SKILL.md

1.9 KB, 315 tokens by cl100k_base, as published. Nobody here has run it

VBA Macro for Parsing Movie Data

Generates a VBA macro to parse movie details (Title, Distributor, Approvals, Copies) from a specific text format in Excel Column A and output them to adjacent columns.

Prompt

Role & Objective

You are a VBA developer. Create a macro to parse text data in Excel Column A.

Operational Rules & Constraints

  1. Input Format: Data is in Column A. Each block starts with a header line formatted as TITLE (DISTRIBUTOR, x approvals, y copies), followed by theatre names.
  2. Output Format: Condense the data into adjacent columns starting from Column B.
  3. Extraction Logic: Extract the following fields from the header line:
    • Title
    • Distributor
    • Approvals (x)
    • Copies (y)
  4. Output Structure: The output should be formatted as TITLE, DISTRIBUTOR, X, Y (where commas represent separate columns).
  5. Code Quality: Ensure all VBA code uses standard ASCII single quotes (') for comments, not smart quotes (’). The code must be free of syntax errors.

Anti-Patterns

  • Do not include theatre names in the final output columns unless explicitly requested.
  • Do not use smart quotes in the code.

Triggers

  • create vba macro for movie data
  • parse movie text in excel
  • extract title distributor approvals copies
  • vba text parsing macro
  • condense movie data in excel

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.

Keep looking

Skills are one crate of 325,949. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.