Random codes

Similar codes

strUnQuote

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

2018Jul3

ANmarAmdeen

Char(39) in SQL table

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

2019Aug31

ANmarAmdeen

RemoveCommaBetween2Quotes

Removes comma between the first pair of quotations (RemoveCommaBetween2Quotes)

2018Jul24

ANmarAmdeen

TrimEnters

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

2020Sep19

ANmarAmdeen

Replace Single Quotes

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

2018Apr16

JeffSmith

RemoveChars

Removes all chars found in Chars_to_remove from String1

2018Jun22

ANmarAmdeen

NMACode

Converts all Æ¼ found in a string into their actual chars

2018Jun27

ANmarAmdeen

TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

2018Jun26

ANmarAmdeen

ReplaceChars

Replaces all chars found in Chars_to_remove from String1 with Char_to_put One ...

2018May26

ANmarAmdeen

Recently by developer

ANString_Location

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

Tue 8AM

ANmarAmdeen

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

ANmarAmdeen

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

ANmarAmdeen

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

ANmarAmdeen

ArCaptcha

Captcha in Arabic, great library, will look forward to apply it in my next ...

Feb11

ANmarAmdeen

Capitalize in JS

Convert text to all capital letters

2020Feb16

ANmarAmdeen

Web browser in Excel VBA

Example on how to use Web browser control inside Excel userform

2019Apr25

ANmarAmdeen

TreeView

A plain pure VBA Treeview control to be used inside Excel (official link has ...

2018Sep2

ANmarAmdeen