Hello,
Is their a way with Switch to search within an excel for the name of a file and then rename the file with the data from the column next to the found cell?
Greetings
Bart
Rename file with data from Excel
Re: Rename file with data from Excel
If it's a CSV, you can use https://appstore.enfocus.com/product/csvlookup
Otherwise, I'd imagine you'd need a script to parse xls,xlsx files which can be rather difficult.
Otherwise, I'd imagine you'd need a script to parse xls,xlsx files which can be rather difficult.
Chat: open-automation @ gitter
Code: open-automation & dominickp @ GitHub
Tools: Switch, Pitstop, EPMS, Veracore, PageDNA, SmartStream, Metrix
Code: open-automation & dominickp @ GitHub
Tools: Switch, Pitstop, EPMS, Veracore, PageDNA, SmartStream, Metrix