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

May6

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

Frm58

Build needed lines to create string variable having block of HTML. Provide the ...

Dec25

ANmarAmdeen

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

Aug13

ANmarAmdeen

ProfileBadge_Linkedin

Creates Linkedin profile badge for certain user as HTML output as string. ...

2019Jun28

ANmarAmdeen

Multi-level menu

CSS only. Bootstrap multi-level menu Originally from

2019Jun19

ANmarAmdeen