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

Card image cap
Between_HTMLtag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

Card image cap
CutString_ReverseFrom

Returns full string starting from the point of LocIndex minus back where we ...

Card image cap
VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

Card image cap
CutString11

Cuts long string from certain character to certain character with option to ...

Card image cap
ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

Card image cap
ANmaRemoveNestedTags

Remove tags that are identical and nested inside each other in an HTML document, ...

Card image cap
SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

Card image cap
NumberBeforeString

Cuts a number that would be found before certain word inside a block string. ...

Card image cap
HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

Card image cap
VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

Card image cap
Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

Card image cap
MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns