Table of ContentsEncryptionErrorsError: Could not execute command: Value to encrypt is emptyFile UtilitiesHow-ToHow do you rename files in OneCloud?How to filter out the first record of a file?GeneralWhy are the File Utilities Commands not able to access a remote drive?HandlebarsHow-ToWhat is the Handlebars BizApp and how do I use it?How do I escape special characters with Handlebars?What are Handlebars JSON Variables and how can I use them?How do I set varying date formats using Handlebars?GeneralWhere can I find some additional information related to Handlebars?What's the difference between the Render File Template and Render Text Template Commands and which should I use?JSONHow-ToHow to use the CSV to JSON Command and iterate over the results?ErrorsError finding the root array element, please check your path: path not foundGeneralMy JSON to Tabular indicates “conversion successful”, but I do not get any data.Microsoft ExcelHow-ToHow to use the Create Workbook Command of the OneCloud Excel BizApp?GeneralHow does the OneCloud Excel BizApp handle the calculation of formulas in workbooks?What is the support for Excel macros when using the OneCloud Excel BizApp?Tabular TransformationHow-ToHow to fix the Advanced Query Command dropping of leading zeros?How can the Advanced Query Command suppress records with duplicate unique IDs?How do I add multiple columns to a file?How do I use Advanced Query with spaces in the columns names?What is the Smart Filter Rows Command and how do I use it?How to sum values with a dollar sign?How to Incorporate Multiple "Find and Replace" into a Single Command?How to display numbers in their native form?How to "Find and Replace" a single character (pattern)?How can fields be concatenated?ErrorsFind and Replace is not working with exact match.GeneralCan I use the UPDATE or INSERT statements with Advanced Query?