Random codes

Similar codes

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

ANmarAmdeen

Replace Single Quotes

This script will replace single quotes so the data is SQL-safe

2018Apr16

JeffSmith

Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

2019Aug31

ANmarAmdeen

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

ANmarAmdeen

RemoveCommaBetween2Quotes

Removes comma between the first pair of quotations (RemoveCommaBetween2Quotes)

2018Jul24

ANmarAmdeen

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

May23

ANmarAmdeen

PCase

Converts a string into proper case PCase or ProperCase since Classic ASP does ...

2018Sep7

ANmarAmdeen

ContainerHTMLTag

Returns HTML tag of the container of certain location inside HTML block. ...

Oct21

ANmarAmdeen

PI

Returns a double representing the mathematical constant Pi

2018Jul5

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

O365 Blocked Macros

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

Jul10

ANmarAmdeen

Pps vs ppsx

PowerPoint slideshow file types and differences in file size. Bottom line, if ...

2020Dec20

ANmarAmdeen

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

ANmarAmdeen

Programming Languages

A nice illustration on different types of languages (the most famous ones only) ...

2018Aug31

ANmarAmdeen