Random codes

Similar codes

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

ANmarAmdeen

all_tab_columns

List all columns in all tables for all schemas in oracle db workbench

2019Dec22

ANmarAmdeen

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

ANmarAmdeen

ANmaFilter3

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

Oct13

ANmarAmdeen

HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16

ANmarAmdeen

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

ANmarAmdeen

SQL Cross Apply String_Split with XML Path

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

Jan20

ANmarAmdeen

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

ANmarAmdeen

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

2021Nov26

ANmarAmdeen

Recently by developer

MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmarAmdeen

Files_FoundHours

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

Apr30

ANmarAmdeen

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

ANmarAmdeen

ANString_Location

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

Apr23

ANmarAmdeen

Sidebar navbar

Bootstrap side navbar (sidebar) Can be pushed to left or right From

2019Aug8

ANmarAmdeen

LoadingSquare

Loading animation in CSS only

2019Jan5

ANmarAmdeen

IsFolder

Returns a Boolean value that indicates if the parameter is a folder.

2018Jun18

ANmarAmdeen