Texts + Strings 175

Texts, strings, convert, replace, encode, parts and concatenations

Sorted from new to old.

VBInstr (or Instr parameters)

The great function InStr I use a lot has a small confusing part. Which string ...

2019Jan9

FormatPhoneNumber

Formats a given 10 digit number into a nice looking phone number

2019Jan5

Val2

Converts anything into an integer I used the function VAL() a lot, it is in ...

2019Jan3

pd

Format a number with total number of digits I used it to format a date as ...

2018Dec29

myURLEncode

Does what Server.URLEncode does In case you needed it, not sure when

2018Oct20

ChrW

Insert special characters inside Cell, using ChrW

2018Sep19

GenerateRandom

Generates a random string, returns string passed, then full date, then 8-chars ...

2018Sep12

PCase

Converts a string into proper case PCase or ProperCase since Classic ASP does ...

2018Sep7

IsValidUTF8 + DecodeUTF8 + EncodeUTF8

Checks UTF8, or convert to/from UTF8. Simple functions to convert the first 256 ...

2018Sep5

PCase (ProperCase)

Just like UCase and LCase, ProperCase (or PCase) will capitalize 1st letter of ...

2018Aug8

DigitsORLettersOnly

Check if the string has special characters or not, only Letters or digits ...

2018Aug8

CutString_Words_Left + CutString_Words_Mid

Cuts the left or Middle part of string without breaking words Can specify ...

2018Aug8

RemoveCommaBetween2Quotes

Removes comma between the first pair of quotations (RemoveCommaBetween2Quotes)

2018Jul24

doHighlight

Search for occurrences of a keyword in a string and highlight them, by either ...

2018Jul19

myURLDecode

Decode a URL, opposite of Server.URLEncode

2018Jul15

RemoveHTMLTags

Remove HTML tags from a string, note, this won't handle html encoding.

2018Jul15

1 2 ...8 ...10 11