View Single Post
 
Old 02-22-2021, 08:22 AM
rupd911 rupd911 is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2021
Posts: 4
rupd911 is on a distinguished road
Post How to hide/delete slides based on keyword in a separate text file based on AND|OR condition?

Hello Team,

Can someone help me with this problem statement?

Problem Statement: I have a text file where the first line is "OR"/"AND". The subsequent lines are some keywords. I also have a ppt where each slide has a note with a bunch of comma-separated keywords. The idea is to develop an automation script that will read the first line of the text file and:

[if the first line is "OR"]: read all the keywords in the text file and hide/delete all the slides in the ppt except for the ones where "ANY" of the keywords in the notes field match the keywords in the text file.

[if the first line is "AND"]: read all the keywords in the text file and hide/delete all the slides in the ppt except for the ones where "ALL" of the keywords in the notes field match the keywords in the text field. if there are extra keywords in the notes field, that is okay.

With thanks and best regards,
RUPD
Reply With Quote