Texts + Strings 185

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

Sorted from new to old.

CutString_ReverseFrom

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

2024Feb27

VBInstr_Numeric

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

2024Feb25

CutString11

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

2024Feb24

ANStrSort3

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

2024Feb20

ANmaRemoveNestedTags

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

2024Feb4

SQL instr

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

2024Feb3

NumberBeforeString_HTML

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

2024Feb1

HTML_CleanNumber

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

2024Jan31

VBInstrRev

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

2024Jan24

Converts two bytes to long

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

2024Jan14

MultiRead_JSON

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

2024Jan13

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

2024Jan9

SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

2024Jan8

CutString9

Cuts from CutFrom starting from any of items found from ...

2024Jan7

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

2024Jan1

CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

2023Dec31

1 2 ...4 ...11 12