# Automation Areas

- [Charts](/legacy/legacy-experience/automation-areas/charts.md)
- [Add Legend](/legacy/legacy-experience/automation-areas/charts/add-legend.md): Enables a legend on an existing pie chart.
- [Add Trendline](/legacy/legacy-experience/automation-areas/charts/add-trendline.md): Add a linear or quadratic trendline to a scatter plot.
- [Create Chart](/legacy/legacy-experience/automation-areas/charts/create-chart.md): Generates a bar or pie chart.
- [Create Plot](/legacy/legacy-experience/automation-areas/charts/create-plot.md): Generates a scatter, line, or box plot.
- [Remove Legend](/legacy/legacy-experience/automation-areas/charts/remove-legend.md): Removes the legend on an existing pie chart.
- [Save Chart](/legacy/legacy-experience/automation-areas/charts/save-chart.md): Renders the current chart and saves it internally.
- [Show Chart](/legacy/legacy-experience/automation-areas/charts/show-chart.md): Renders a previously created chart.
- [Show Plot](/legacy/legacy-experience/automation-areas/charts/show-plot.md): Render a stored plot chart.
- [Date and Time](/legacy/legacy-experience/automation-areas/date-and-time.md): This section covers the automation procedures for working with dates and times in Kognitos.
- [Converting Date Strings Into Dates](/legacy/legacy-experience/automation-areas/date-and-time/converting-date-strings-into-dates.md): This procedure converts date strings (text representations of dates) into date objects.
- [Converting Date Strings to Different Formats](/legacy/legacy-experience/automation-areas/date-and-time/converting-date-strings-to-different-formats.md): This procedure converts text to a date in a specific format.
- [Converting Text to Date](/legacy/legacy-experience/automation-areas/date-and-time/converting-text-to-date.md): This procedure converts text to date in YYYY-MM-DD format.
- [Getting Date and Time Information](/legacy/legacy-experience/automation-areas/date-and-time/getting-date-and-time-information.md): These procedures are used to get current date and time information.
- [Sorting Dates](/legacy/legacy-experience/automation-areas/date-and-time/sorting-dates.md): This procedure sorts a list of dates in ascending order.
- [Department Boxes](/legacy/legacy-experience/automation-areas/department-box.md): Learn how to operate on a department box.
- [Add Items](/legacy/legacy-experience/automation-areas/department-box/add-items.md): Add item(s) to a department box.
- [Clean Items](/legacy/legacy-experience/automation-areas/department-box/clean-items.md): Removes all the keys from the department box.
- [Clean Items Before a Certain Date](/legacy/legacy-experience/automation-areas/department-box/clean-items-before-a-certain-date.md): Removes all the keys from the department box before a certain date.
- [Export Items](/legacy/legacy-experience/automation-areas/department-box/export-items.md): Export all the keys from the specified department box into a table.
- [Migrate to OpenSearch](/legacy/legacy-experience/automation-areas/department-box/migrate-to-opensearch.md): Migrates data from the current department box storage engine to OpenSearch.
- [Remove Item](/legacy/legacy-experience/automation-areas/department-box/remove-item.md): Removes a specified item from a department's box.
- [Remove Items](/legacy/legacy-experience/automation-areas/department-box/remove-items.md): Removes all items from a department box.
- [Retrieve Item](/legacy/legacy-experience/automation-areas/department-box/retrieve-item.md): Retrieve an item from a department box.
- [Excel Files](/legacy/legacy-experience/automation-areas/excel-v2.md): Learn to work with local Excel files in Kognitos.
- [Cells](/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value.md): Retrieves the value of a cell in an Excel worksheet.
- [Get a Cell's Column Label](/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/get-a-cells-column-label.md): Retrieves the column label of a specific cell in an Excel worksheet.
- [Get a Cell's Formula](/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/get-a-cells-formula.md): Gets the formula from a specified cell in a worksheet.
- [Get a Cell's Row Number](/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/get-a-cells-row-number.md): Retrieves the row number of a specific cell in an Excel worksheet.
- [Set a Cell's Value](/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/set-a-cells-value.md): Sets the value of a cell in a worksheet to a specified text or formula.
- [Set Cell Values](/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/set-cell-values.md): Updates the values in an Excel file for one or more cells.
- [Columns](/legacy/legacy-experience/automation-areas/excel-v2/insert-a-column.md): Inserts a column into an existing Excel worksheet.
- [Rows](/legacy/legacy-experience/automation-areas/excel-v2/get-a-row.md): Gets a row from an Excel worksheet that contains a specific value.
- [Get a Row's Cell](/legacy/legacy-experience/automation-areas/excel-v2/get-a-row/get-a-rows-cell.md): Retrieves a cell in a specific row of an Excel worksheet.
- [Insert a Row](/legacy/legacy-experience/automation-areas/excel-v2/get-a-row/insert-a-row.md): Inserts a row into an existing Excel worksheet.
- [Tables](/legacy/legacy-experience/automation-areas/excel-v2/extract-a-table-from-a-worksheet.md): Locates and extracts a table from an Excel worksheet.
- [Get a Singular Table from an Excel Worksheet](/legacy/legacy-experience/automation-areas/excel-v2/extract-a-table-from-a-worksheet/get-a-singular-table-from-an-excel-worksheet.md): Retrieves the single table from a worksheet.
- [Insert a Table](/legacy/legacy-experience/automation-areas/excel-v2/extract-a-table-from-a-worksheet/insert-a-table.md): Inserts a table into an Excel worksheet.
- [Workbooks](/legacy/legacy-experience/automation-areas/excel-v2/convert-an-excel-to-a-pdf.md): Converts an Excel file to PDF format.
- [Create an Excel File](/legacy/legacy-experience/automation-areas/excel-v2/convert-an-excel-to-a-pdf/create-an-excel-file.md): Creates a new Excel file.
- [Worksheets](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet.md): Gets a specific worksheet from an Excel file.
- [Add a Worksheet](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/add-a-worksheet.md): Adds an empty worksheet to an existing Excel file.
- [Copy a Worksheet in the Excel](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/copy-a-worksheet-in-the-excel.md): Creates a copy of an existing worksheet in the same Excel file.
- [Extract Text from a Worksheet](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/extract-text-from-a-worksheet.md): Extracts all text from an Excel worksheet
- [Format an Excel](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/format-an-excel.md): Formats cells in an Excel worksheet.
- [Get a Worksheet Name](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/get-a-worksheet-name.md): Intelligently retrieves a worksheet name from an Excel file.
- [Get an Item from an Excel Worksheet](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/get-an-item-from-an-excel-worksheet.md): Retrieves a specific item from a sheet.
- [Get Worksheet Names](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/get-worksheet-names.md): Retrieves the names of all worksheets in an Excel file.
- [Get Worksheets](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/get-worksheets.md): Gets all the worksheets from an Excel workbook.
- [Insert a Formula into an Excel](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/insert-a-formula-into-an-excel.md): Inserts formulas into a specified column across multiple rows in an Excel worksheet.
- [Remove a Worksheet](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/remove-a-worksheet.md): Removes a specified worksheet.
- [Rename a Worksheet in the Excel](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/rename-a-worksheet-in-the-excel.md): Renames an existing worksheet in the same Excel file.
- [Save a Worksheet](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/save-a-worksheet.md): Saves an Excel worksheet to a temporary location.
- [Files and Documents](/legacy/legacy-experience/automation-areas/summary-1.md)
- [JSON](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file.md): Opens a JSON file from either an S3 URL or an uploaded file.
- [Compare a JSON with a JSON](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-compare-a-json-with-a-json.md): Compares two JSON objects and identifies differences between them.
- [Create a JSON](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-create-a-json.md): Creates an empty JSON object.
- [Delete a JSON's Thing](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-delete-a-jsons-thing.md): Deletes a specified key from a JSON object.
- [Get a JSON as a String](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-get-a-json-as-a-string.md): Converts a JSON object to a string representation.
- [Get a JSON's Thing](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-get-a-jsons-thing.md): Extracts a specific element or elements from a JSON structure.
- [Get a String as a JSON](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-get-a-string-as-a-json.md): Converts a string to a JSON object.
- [Merge a JSON with a JSON](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-merge-a-json-with-a-json.md): Merges two JSON objects and returns the merged result.
- [Set a JSON's Thing to a Thing](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-set-a-jsons-thing-to-a-thing.md): Sets or changes a specific value within a JSON object to a new value.
- [PDFs](/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf.md): Automation procedures for converting files to PDF.
- [Getting Information from a PDF](/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/getting-information-from-a-pdf.md): Basic procedures for extracting information from a PDF.
- [Merging Documents](/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/merging-documents.md): This automation procedure combines multiple PDFs into a single PDF file.
- [Removing Duplicates from a PDF](/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/removing-duplicates-from-a-pdf.md): Automation procedures for removing duplicates from a PDF file.
- [Saving a PDF](/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/saving-a-pdf.md): Automation procedures for saving a PDF file after making changes.
- [Setting or Changing Information in a PDF](/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/setting-or-changing-information-in-a-pdf.md): Automation procedures to set or change field values in a PDF file.
- [Unlock a PDF File](/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/unlock-a-pdf-file.md): Unlocks a password-protected PDF file.
- [Templates](/legacy/legacy-experience/automation-areas/summary-1/create-pdfs-from-a-template.md): Generates a PDF document for each row in an Excel file by merging data into a .docx template.
- [Fill in a Template File](/legacy/legacy-experience/automation-areas/summary-1/create-pdfs-from-a-template/fill-in-a-template-file.md): Fills in a template with provided placeholder values.
- [Image Manipulation](/legacy/legacy-experience/automation-areas/image-manipulation.md): Automation procedures for image manipulation, including how to resize, rotate, convert to grayscale, and flip images.
- [Converting Images to Grayscale](/legacy/legacy-experience/automation-areas/image-manipulation/converting-images-to-grayscale.md)
- [Flipping Images](/legacy/legacy-experience/automation-areas/image-manipulation/flipping-images.md)
- [QR Code Generation](/legacy/legacy-experience/automation-areas/image-manipulation/qr-code-generation.md)
- [Resizing Images](/legacy/legacy-experience/automation-areas/image-manipulation/resizing-images.md)
- [Rotating Images](/legacy/legacy-experience/automation-areas/image-manipulation/rotating-images.md)
- [Text Visualization](/legacy/legacy-experience/automation-areas/image-manipulation/text-visualization.md)
- [LLMs](/legacy/legacy-experience/automation-areas/llm.md): Learn how to use automation procedures that interact with LLM models.
- [When to Use Ask Koncierge or Extract](/legacy/legacy-experience/automation-areas/llm/when-to-use-ask-koncierge-or-extract.md): Summarizing the differences, strengths, and use cases for each type of LLM procedure.
- [Foundational Procedures](/legacy/legacy-experience/automation-areas/llm/ask-koncierge.md)
- [Ask Koncierge](/legacy/legacy-experience/automation-areas/llm/ask-koncierge/ask-koncierge.md): Asks Koncierge, a virtual assistant, to perform a task, answer a question, or generate a message.
- [Ask Koncierge to Extract Information from a Document](/legacy/legacy-experience/automation-areas/llm/ask-koncierge/ask-koncierge-to-extract-information-from-a-document.md): Asks Koncierge to extract specific information from documents or text.
- [Automation Procedures](/legacy/legacy-experience/automation-areas/llm/automation-procedures.md): Extracts data from texts, documents, or files using LLM models.
- [Extract Data](/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-data.md): Extracts data from texts, documents, or files using LLM models.
- [Extract Data from Multiple Documents](/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-data-from-multiple-documents.md): Extracts data from multiple documents in a single LLM call using file upload.
- [Extract Pages](/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-pages.md): Extracts specified pages from a document or file as individual page documents.
- [Extract Subdocument](/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-subdocument.md): Extracts a subdocument from a document or file based on page numbers or markers.
- [Extract Subdocuments](/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-subdocuments.md): Extracts multiple subdocuments from a document using markers or fixed-size chunking.
- [Extract Tables](/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-tables.md): Extracts table data from documents, text, or files using AI-powered analysis.
- [Identify Elements in a Text](/legacy/legacy-experience/automation-areas/llm/automation-procedures/identify-elements-in-a-text.md): Finds a specified element within a given text using AI-powered text analysis.
- [Merge Pages into Document](/legacy/legacy-experience/automation-areas/llm/automation-procedures/merge-pages-into-document.md): Merges multiple page documents into a single consolidated document.
- [Merge Subdocuments into Document](/legacy/legacy-experience/automation-areas/llm/automation-procedures/merge-subdocuments-into-document.md): Merges multiple subdocuments into a single consolidated document.
- [Query Multiple Documents](/legacy/legacy-experience/automation-areas/llm/automation-procedures/query-multiple-documents.md): Process multiple documents with a custom prompt using LLM file upload APIs.
- [Numbers](/legacy/legacy-experience/automation-areas/numbers.md): Automation procedures for working with numbers in Kognitos.
- [Increase a Number by a Percentage](/legacy/legacy-experience/automation-areas/numbers/increase-a-number-by-a-percentage.md): This procedure increases a number by a percentage.
- [Reduce a Number by a Percentage](/legacy/legacy-experience/automation-areas/numbers/reduce-a-number-by-a-percentage.md): This procedure reduces a number by a percentage
- [Truncate a Number](/legacy/legacy-experience/automation-areas/numbers/truncate-a-number.md): Truncates a decimal number to a specified precision without rounding.
- [Tables](/legacy/legacy-experience/automation-areas/tables-v2.md): Learn to work with tables and tabular data.
- [Table Creation](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table.md): Creates an empty table. The column names and number of rows can be optionally specified.
- [Create a Combined Table](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-combined-table.md): Creates a combined table from two or more existing tables.
- [Create a Merged Table](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-merged-table.md): Merge two or more tables based on specified matching and merging criteria.
- [Create a Pivot Table](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-pivot-table.md): Generates a pivot table from an existing table based on specified criteria.
- [Create a Sample Table](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-sample-table.md): Creates a sample table with predefined data.
- [Create a Table from JSON](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-table-from-json.md): Creates a table from JSON input.
- [Create a Table from the Rows](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-table-from-the-rows.md): Creates a table from one or more rows.
- [Create an Integer Table](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-an-integer-table.md): Creates an integer table with predefined columns and rows.
- [Get a Table from a File](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/get-a-table-from-a-file.md): Opens a table from a file, provided either through direct upload or at an S3 URL.
- [Cells](/legacy/legacy-experience/automation-areas/tables-v2/set-a-cell-in-a-table.md): Sets the value of a cell in a table.
- [Columns](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column.md): Retrieves a specified column from a table.
- [Cast a Table Column](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/cast-a-table-column.md): Converts a table column to a specified data type.
- [Column Formulas](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/column-formulas.md): Use column formulas to dynamically populate and transform column data in your tables.
- [Delete Table Columns](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/delete-table-columns.md): Deletes one or more specified columns from a table.
- [Get a Column Number](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/get-a-column-number.md): Gets the column number of a specified column in a table.
- [Get a Column's Values](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/get-a-columns-values.md): Gets the values of a specified column in a table.
- [Get Column Count](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/get-column-count.md): Retrieves the number of columns in the table.
- [Get Column Names](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/get-column-names.md): Retrieves a table's header.
- [Get Column Stats](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/get-column-stats.md): Calculates an aggregate value of a table column.
- [Insert a Column in a Table](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/insert-a-column-in-a-table.md): Inserts a column into a table.
- [Move a Column](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/move-a-column.md): Moves a column in the table to a specified position.
- [Rename a Column](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/rename-a-column.md): Renames a column in a table.
- [Rename Columns](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/rename-columns.md): Renames columns in a table to new names specified by the user.
- [Round a Column's Values](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/round-a-columns-values.md): Rounds numeric values in a table column to a specified number of decimal places.
- [Update a Column in a Table](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/update-a-column-in-a-table.md): Updates a column in a table.
- [Rows](/legacy/legacy-experience/automation-areas/tables-v2/get-rows.md): Retrieves a single row or multiple rows from a table.
- [Get Row Count](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/get-row-count.md): Retrieves the number of rows in the table.
- [Get Row Number](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/get-row-number.md): Retrieves the row number of the specified row in the table.
- [Get Value from Row](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/get-value-from-row.md): Retrieves the value of a specified column from the row.
- [Group Rows](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/group-rows.md): Groups the rows of a table by specified criteria.
- [Insert a Row](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/insert-a-row.md): Inserts a row into the table with given data.
- [Insert an Empty Row](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/insert-an-empty-row.md): Inserts an empty row into the table at the specified row number.
- [Remove Duplicate Rows](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/remove-duplicate-rows.md): Deletes duplicate rows from the table, optionally based on specified columns.
- [Set a Row to JSON](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/set-a-row-to-json.md): Updates a row in the table using values from a JSON object.
- [Conversions](/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv.md): Converts a table to a CSV formatted file.
- [Convert a Table to Excel](/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv/convert-a-table-to-excel.md): Converts a table into an Excel file with customizable filename and worksheet name.
- [Convert a Table to JSON](/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv/convert-a-table-to-json.md): Converts a table into JSON.
- [Convert a Table to Text](/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv/convert-a-table-to-text.md): Converts a table into its text (string) representation.
- [Convert JSONs to Table](/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv/convert-jsons-to-table.md): Converts a specified non-empty JSON array of objects (or single object) into a table.
- [Convert Thing to Table](/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv/convert-thing-to-table.md): Converts a specified thing, such as a CSV file or JSON, into a table.
- [Manipulations](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table.md): Executes a SQL query on a table and returns the result.
- [Clear a Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/clear-a-table.md): Clears all data from a table.
- [Combine Tables](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/combine-tables.md): Combines multiple tables into a single table based on specified criteria.
- [Copy a Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/copy-a-table.md): Copies a table to a new table with a specified name.
- [Extract a Subtable from the Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/extract-a-subtable-from-the-table.md): Extracts a table from an existing table.
- [Group a Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/group-a-table.md): Groups a table by a specified column and optionally aggregates other columns.
- [Join Subtables](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/join-subtables.md): Combines multiple subtables into a single table.
- [Replace Value in a Column](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/replace-value-in-a-column.md): Replaces occurrences of a value in a table.
- [Replace Value in Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/replace-value-in-table.md): Replaces occurrences of a value in a table.
- [Sort a Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/sort-a-table.md): Sorts a table by one or more columns with optional ascending/descending order.
- [Split a Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/split-a-table.md): Split a large table into smaller subtables.
- [Transpose a Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/transpose-a-table.md): Transposes a given table.
- [Text](/legacy/legacy-experience/automation-areas/text.md): Learn how to manipulate text in your automations.
- [Boolean Checks](/legacy/legacy-experience/automation-areas/text/boolean-checks.md): Automation procedures for evaluating text conditions that yield either a "true" or "false" result.
- [Check Regex Match](/legacy/legacy-experience/automation-areas/text/boolean-checks/check-regex-match.md): Check if a text matches a regular expression pattern.
- [Check Text Contents](/legacy/legacy-experience/automation-areas/text/boolean-checks/check-text-contents.md): Check if a value is present within a text.
- [Check Text End](/legacy/legacy-experience/automation-areas/text/boolean-checks/check-text-end.md): Check if a text ends with another text value.
- [Check Text Start](/legacy/legacy-experience/automation-areas/text/boolean-checks/check-text-start.md): Check if a text is started by another text value.
- [Conversions](/legacy/legacy-experience/automation-areas/text/conversions.md): Automation procedures that transform text from one format or structure to another.
- [Convert a Character to a Number](/legacy/legacy-experience/automation-areas/text/conversions/convert-a-character-to-a-number.md): Convert a character into its corresponding numeric ASCII value.
- [Convert a Number to a Character](/legacy/legacy-experience/automation-areas/text/conversions/convert-a-number-to-a-character.md): Convert a number into its corresponding character ASCII value.
- [Convert Text Date to ISO Format](/legacy/legacy-experience/automation-areas/text/conversions/convert-text-date-to-iso-format.md): Convert a given text date to ISO-8601 format.
- [Convert Text to HTML](/legacy/legacy-experience/automation-areas/text/conversions/convert-text-to-html.md): Create an HTML file by converting text to HTML.
- [Convert Text to Number](/legacy/legacy-experience/automation-areas/text/conversions/convert-text-to-number.md): Convert a text representation of a number into its numeric value.
- [Get Lowercase Text](/legacy/legacy-experience/automation-areas/text/conversions/get-lowercase-text.md): Convert a given text to lowercase format.
- [Get Titlecase Text](/legacy/legacy-experience/automation-areas/text/conversions/get-titlecase-text.md): Convert a given text to title case.
- [Get Uppercase Text](/legacy/legacy-experience/automation-areas/text/conversions/get-uppercase-text.md): Convert a given text to uppercase.
- [Removal](/legacy/legacy-experience/automation-areas/text/removal.md): Automation procedures involving text removal.
- [Remove Text Using Regex](/legacy/legacy-experience/automation-areas/text/removal/remove-text-using-regex.md): Removes occurrences of a specified regular expression from a text.
- [Remove Text Using Substrings](/legacy/legacy-experience/automation-areas/text/removal/remove-text-using-substrings.md): Removes a specific piece of text from a larger text.
- [Combine Texts with Separator](/legacy/legacy-experience/automation-areas/text/combine-texts-with-separator.md): Combine a list of text values using a specified separator.
- [Extract Elements from Text](/legacy/legacy-experience/automation-areas/text/extract-elements-from-text.md): Extract lines, words, characters, URLs, numbers, or patterns from a text.
- [Extract Markdown Headings](/legacy/legacy-experience/automation-areas/text/extract-markdown-headings.md): Extract headings from a given markdown text.
- [Get Text Length](/legacy/legacy-experience/automation-areas/text/get-text-length.md): Get the length of a text string.
- [Replace Text](/legacy/legacy-experience/automation-areas/text/replace-text.md): Replace a text with another text.
- [Split Text](/legacy/legacy-experience/automation-areas/text/split-text.md): Split a text into smaller texts.