Search results 186

Sorted from new to old.
Card image
SQL Cross Apply String_Split with XML Path

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

Card image
Grandchildren files and count

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

Card image
ANStringListRead_JSON

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

Card image
CutString9

Cuts from CutFrom starting from any of items found from ...

Card image
ANmaPivotTable_Clear

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

Card image
ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

Card image
ReNumber_IDColumn_inTable

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

Card image
ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

Card image
MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

Card image
ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

Card image
GeWin - get windows list

Gets all windows that are enabled and actived and put them in a list. It also ...

Card image
HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

Card image
ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

Card image
USB Format in Car stereo

What format used to let Car stereo read USB thumb drive? To listen to MP3 ...

Card image
End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

Card image
FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to