Search results 120

Sorted from new to old.

ANstr_Column

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

2024Jul29

ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

2024Jul26

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

2024Jul24

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

2024Jul13

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

2024Apr23

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

2024Apr17

Concatenate_HTMLColumn

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

2024Mar14

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

2024Mar2

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

2024Feb20

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

2024Feb5

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

2024Jan25

SQL Cross Apply String_Split with XML Path

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

2024Jan20

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

2024Jan17

MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns

2024Jan13

Grandchildren files and count

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

2024Jan11

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

2024Jan9

1 2 3 ...7 8