Texts + Strings 145 Texts, strings, convert, replace, encode, parts and concatenations

Card image cap
TrimEnters

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

Card image cap
URLDecode

Decodes a URL encoded string back into the original text. Similar to ...

Card image cap
ReadHTMLTag

Reads string between open and close HTML tag (between < ... > and < / ... >), ...

Card image cap
JSON-VBA

2 modules to read output of json API (or file) into parsed array of objects. ...

JSON-VBA.zip

Card image cap
Sorting Strings

This is not a function as much as a note. I needed to force a line to show at ...

Card image cap
CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

Card image cap
Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

Card image cap
IntlIsAlphaCharacter

Test if a character is alphanumeric, regardless of the code page or language ...

Card image cap
Remove_Between2Quotes

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

Card image cap
Capitalize in JS

Convert text to all capital letters

Card image cap
RandomGUID

Creates a random GUID number like ... 879AE395-E026-0A63-EFC1-152038C4400B ...

Card image cap
ShrinkText

Shrinks a text into smaller text controlling where is the majority will be ...