• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Automation Blocks - List Reduction

Contributor ,
Nov 07, 2024 Nov 07, 2024

Copy link to clipboard

Copied

I'm looking to reduce a list from a spreadsheet and don't know how to do it.

I've got a .csv where column B is the 'type' of sequence that the shot belongs to.

Column C is the the actual sequence name and Column D is the shot name.

ShotList_csv.png

 

This is my current block set.

ShotListCurrentBlocks.png

The last two "in list" blocks add the last selected item to the top of the list with a space. (Super handy, but I can't figure out an easy way to exclude the space from actually being selected.)

 

It creates a list that is every single line of the .csv

ShotListInputDialog.png

How can I reduce all the "same" sequence to a single item? Or if I had many "reduced" sequence initials that would get pulled if they match the "if" block?

TOPICS
How to , Scripting

Views

155

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 08, 2024 Nov 08, 2024

Copy link to clipboard

Copied

Alternative 1:

Screenshot 2024-11-08 at 09.54.32.png

Alternative 2
if you want to remove the duplicates for whatever reason after you already inserted all of them, the easiest way is to ask  ChatGPT for a JavaScript function which removes all duplicates from an array of strings and then execute that one with the Execute Code Block.

Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Nov 08, 2024 Nov 08, 2024

Copy link to clipboard

Copied

I had never thought to look at ChatGPT. So I followed your advice and was able to cobble together something that worked exactly as you mentioned in Alternative 2.

Reduce List Execute Code GPT.png

So NEAT!

Thank you for opening up so many possibilities...

DesireToKnowMore.gif

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 09, 2024 Nov 09, 2024

Copy link to clipboard

Copied

LATEST

Oh, yes, the Execute Code block with ChatGPT is a very powerful combination 🙂
Whenever you need to do something with your data, like filtering, searching, replacing,sorting, ...  ChatGPT is pretty reliable. 

Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines