Search results 52

Sorted from new to old.
Card image
DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Card image
CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

Card image
TrimLines

Remove all line breaks from text from a text. Not like

Card image
ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

Card image
SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

Card image
Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Card image
MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Card image
Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

Card image
SettingRead_Ajax + SettingRead_Ajax_IntoObject

Two functions to return an output of file into object on page or back to caller ...

Card image
ANStrFind_AndOrAdd

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

Card image
UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

Card image
Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

Card image
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

Card image
ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

Card image
OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

Card image
COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...