Search results 106

Sorted from new to old.

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

Nov3

FixURL

Return safe URL after converting critical chars to whatever passed in SafeChar

Sep16

IsNumericChar

Checks if character is number or no. Returns True or False Number includes the ...

Aug21

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

Aug2

CountNumbers_inString

Returns how many numbers found inside a text

Aug1

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

Jul28

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

Mar3

NumberNumberNumber

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

Mar2

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

Feb3

SQL Cross Apply String_Split with XML Path

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

Jan20

HMatchIf_Multi

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

2023Oct30

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

Send page to print

JavaSctipt commnad to show Print dialog when a page is visited. I usually put ...

2023Aug11

O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27

1 2 ...6 7