Similar codes

Card image cap
Remove_Between2Quotes

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

2020Mar9

Card image cap
strUnQuote

This will tests to see if strQuotedString is wrapped in quotation marks, and, ...

2018Jul3

Card image cap
Replace Single Quotes

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

2018Apr16

Card image cap
InternationalComma

Convert an international numeric with , instead of . Into American style . ...

2018Aug8

Card image cap
Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

Card image cap
Char(39) in SQL table

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

2019Aug31

Card image cap
ReplaceStrings

Replace strings found in list of strings from inside a string, does taht make ...

Nov11

Card image cap
TrimEnters

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

2020Sep19

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
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

Card image cap
Encrypt1 + Decrypt1

Encrypts (and decrypts) a string. To decrypt an encrypted string, use the ...

2018Jul25

Card image cap
CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14

Card image cap
Numbers in Textbox

Force textbox to accept numbers only. Needs adjustments to work on VB6

2018Jun6