Search results 138

Sorted from new to old.

HTMLTable_FullRow

Returns full row from RowID ... the full area between < tr ...> and < /tr> from ...

2024Aug4

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

2024Jul29

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

2024Jun6

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

2024May16

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15

ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

2024Apr3

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

2024Mar14

FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

2024Mar4

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

2024Feb18

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

2024Jan26

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

2024Jan23

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

2024Jan11

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

1 2 ...8 9