Search results 60

Sorted from new to old.

RegExPatternMatch

Checks string against pattern using RegEx (VBScript.RegExp). The pattern ...

Nov10

QuickEncrypt plus others ...

Text encryption/decryption snippet that utilizes the powerful xICE encryption ...

Aug15

CountNumbers_inString

Returns how many numbers found inside a text

Aug1

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

Jul26

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Jul13

ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

Jul2

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

Jun10

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

May27

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

ANmaCellFormat

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

Apr18

CopyFields_FromTo

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

Apr17

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Mar14

Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

Mar4

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

VBHTMLInstr

Searches for string in readable text from HTMLBlock. So it will not find what ...

2023Dec3

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

1 2 3 4