This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!
i am trying to parse a word document and convert to Excel.
for example if the input word document name is Test.docx i want the same name for excel output as Test.xls. is there any way i can automate that ? Appreciate the support.
Configure your Input Tool to 'Output File Name as Field: Full Path, then use the following expression in a Formula Tool before your Output:
Thanks for the response.
As input Data Tool doesn't support Word Docs i am using a macro to read a word doc file. Will this complicate it or i can use the logic at output side alone for this to work ?
Does the macro have the Input Date Tool?
Nope but it have Text Input Tool
Yes, this will work, if the input file field is named FileName, or modify the below to reference that field name.
In the macro, output the field, then add this formula.