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

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

ANmarAmdeen

Files_FoundHours

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

Tue 7AM

ANmarAmdeen

MatchIf2Up

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

Mon 9AM

ANmarAmdeen

ANString_Location

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

Apr23

ANmarAmdeen

ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

May5

ANmarAmdeen

Bootstrap 4 Date picker

Date and Time picker in Bootstrap 4 From

2019Jun19

ANmarAmdeen

RemoveCommaBetween2Quotes

Removes comma between the first pair of quotations (RemoveCommaBetween2Quotes)

2018Jul24

ANmarAmdeen

WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

2018Jul17

ANmarAmdeen