Search results 60

Sorted from new to old.

CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

Feb26

TrimLines

Remove all line breaks from text from a text. Not like

Jan31

VBInstr_Occurance

Returns location of text inside another with jump ability for any certain ...

2024Dec1

RegExPatternMatch

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

2024Nov10

QuickEncrypt plus others ...

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

2024Aug15

CountNumbers_inString

Returns how many numbers found inside a text

2024Aug1

Quarter1stLastDate_FromQuarterText

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

2024Jul26

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

2024Jul13

ReturnLongestString_Of2

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

2024Jul2

CalculateQuarterText

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

2024Jun10

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

2024May27

MatchIF5

Searching for rows having 5 values in 5 columns Like

2024May6

ANmaCellFormat

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

2024Apr18

CopyFields_FromTo

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

2024Apr17

Concatenate_HTMLColumn

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

2024Mar14

Triangular coded msg in file

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

2024Mar4

1 2 3 4