Search results 58

Sorted from new to old.

ANmaTableAddress

Returns the full name of table with its sheet name to be used in formulas or in ...

Apr26

Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

2025May27

HTML_CountTags

Counts how many certain tag found in an HTML block. like how many tr found in ...

2025May16

HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

2025Jan12

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

2024Dec4

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

2024Dec4

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

HTMLTable_Cell

Returns content of cell by location ... RowID and ColumnID HTMLTable expected ...

2024Aug5

HTMLRow_Cell

Returns column with ColumnID ... the full area between < td ...> and < /td> ...

2024Aug4

HTMLTable_FullRow

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

2024Aug4

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

VLookup_HTML

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

2024Jan26

SQL Cross Apply String_Split with XML Path

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

2024Jan20

ReNumber_IDColumn_inTable

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

2023Dec17

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

1 2 3 4