Texts + Strings 165

Texts, strings, convert, replace, encode, parts and concatenations
Sorted from new to old.
Card image
TrimEnters

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

Card image
URLDecode

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

Card image
ReadHTMLTag

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

Card image
JSON-VBA

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

Card image
Sorting Strings

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

Card image
CreateList_Matching

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

Card image
Column2AnString_Unique

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

Card image
IntlIsAlphaCharacter

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

Card image
Remove_Between2Quotes

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

Card image
Capitalize in JS

Convert text to all capital letters

Card image
RandomGUID

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

Card image
ShrinkText

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

Card image
Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

Card image
HTMLDecode + HTMLEncode

Decode and encode back a string using HTML Technically found online, but ...

Card image
ProfileBadge_Linkedin

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

Card image
Save to, Read from, Delete registry key

Save into registry, read from registry or delete a key. Accessible to only ...