Search results 203

Sorted from new to old.

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

ANStringListRead_JSON

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

2024Jan9

SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

2024Jan8

CutString9

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

2024Jan7

ANmaPivotTable_Clear

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

2023Dec22

ANStrFind_AndOrAdd

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

2023Dec19

ReNumber_IDColumn_inTable

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

2023Dec17

ReverseArray

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

2023Nov27

MathInsideANString

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

2023Nov20

ReplaceStrings

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

2023Nov11

GeWin - get windows list

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

2023Nov10

HMatchIf_Multi

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

2023Oct30

ANmaFilter3

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

2023Oct13

USB Format in Car stereo

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

2023Sep29

End ( xlDown )

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

2023Aug28

1 2 ...4 ...12 13