Similar codes

Card image cap
Random GUID

Generate a random GUID using oracle db workbench Also add timestamp to ensure ...

2019Dec22

Card image cap
DB Functions (By AI)

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

2023Apr23

Card image cap
Most recent in Oracle DB

List the most recently added rows based on a date column.

2020Feb7

Card image cap
ANmaRemoveDuplicates

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

2022Sep25

Card image cap
DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

Card image cap
FilterSheet_1By1 + FilterSheet_Clear

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

2020Jan3

Card image cap
Posts_per_Year

Gets list of years and total of posts per year from a table, by using date ...

2018Jul29

Card image cap
RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

2018Jul29

Card image cap
ReNumber_IDColumn_inTable

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

Dec17

Recently by developer

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

Card image cap
Files_FoundHours

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

Tue 7AM

Card image cap
MatchIf2Up

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

Mon 9AM

Card image cap
ANString_Location

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

Apr23

Random Codes

Card image cap
Rotated Nav

Animated Rotated Nav links, brilliant!

2019Nov11

Card image cap
DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

2018Jul7

Card image cap
RemoveChars

Removes all chars found in Chars_to_remove from String1

2018Jun22

Card image cap
Find and Replace

This will find all occurences of a string in a text file and replace it with ...

2018Apr15