Icon

KNIME_​extract_​from_​ppt

Workflow to attempt to retrieve text from powerpoint slide text boxes, to assist with

https://forum.knime.com/t/extracting-text-from-powerpoint-and-save-the-content-in-an-excel/32136

This part is just included so I can put a relative path inworkflwo to legacy unzip nodeExtract Context PropertiesJava Edit Variable.Between them they create a relative path String flowvariable to be used by Unzip Files (legacy) Workflow to attempt to retrieve text from powerpoint slide text boxes, to assist with https://forum.knime.com/t/extracting-text-from-powerpoint-and-save-the-content-in-an-excel/3213614 April 2021 @takbb Brian Bates Loop through files in folder Loop through xml files in powerpoint unzip the ppt intoxml filesRead xmlGrab any text in a textBody(returning multiple rows)xpath query:/p:sld/p:cSld/p:spTree/*/p:txBodyLoop through the filtered xml filesEnd unzip xml file looprecord the currentfilename (URI)as a column valueCollect workflow context informationDefine an outputfile stringflow variablerelative relative to workflowGet list of pptx filesturn string into Pathloop through the filesEnd Folder Loopconvert path variable to string foruse with legacy unzipFind only the xmlfiles which areppt/slides/remove superflous columnsremove any textBodycontaining emptyvaluesCreate tempfolder for unzipof pptx file Unzip Files(legacy) XML Reader XPath Table Row ToVariable Loop Start Loop End Variable toTable Column Extract ContextProperties Java Edit Variable List Files/Folders String to Path(Variable) Table Row ToVariable Loop Start Loop End Path to String(Variable) Row Filter Column Filter Row Filter Create Temp Folder This part is just included so I can put a relative path inworkflwo to legacy unzip nodeExtract Context PropertiesJava Edit Variable.Between them they create a relative path String flowvariable to be used by Unzip Files (legacy) Workflow to attempt to retrieve text from powerpoint slide text boxes, to assist with https://forum.knime.com/t/extracting-text-from-powerpoint-and-save-the-content-in-an-excel/3213614 April 2021 @takbb Brian Bates Loop through files in folder Loop through xml files in powerpoint unzip the ppt intoxml filesRead xmlGrab any text in a textBody(returning multiple rows)xpath query:/p:sld/p:cSld/p:spTree/*/p:txBodyLoop through the filtered xml filesEnd unzip xml file looprecord the currentfilename (URI)as a column valueCollect workflow context informationDefine an outputfile stringflow variablerelative relative to workflowGet list of pptx filesturn string into Pathloop through the filesEnd Folder Loopconvert path variable to string foruse with legacy unzipFind only the xmlfiles which areppt/slides/remove superflous columnsremove any textBodycontaining emptyvaluesCreate tempfolder for unzipof pptx fileUnzip Files(legacy) XML Reader XPath Table Row ToVariable Loop Start Loop End Variable toTable Column Extract ContextProperties Java Edit Variable List Files/Folders String to Path(Variable) Table Row ToVariable Loop Start Loop End Path to String(Variable) Row Filter Column Filter Row Filter Create Temp Folder

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: brian
Created at: 2021-04-14
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.3.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!